Senior Data Engineer (Databricks & CRM Integration)
Work setup:
•Project start date: (TBC)
• Phase Design workshop completed ASAP after contract signing
• Phase 1 (Data products live on ADP): (first major milestone)
• Phase 2 (Light UI production-ready):
• Phase 3: Q4 2026
• Extension option: Yes – likely extension based on positive outcomes
• Service time/week: 5 days (100%)
• Core hours: CET 08:00 – 17:00
• Location: Baden / Hybrid (40% onsite / 60% remote)
• Language: English required; German advantage
Background:
Group Sales operates a fragmented CRM landscape across Salesforce, Microsoft Dynamics 365, and Excel/SharePoint, with no group-wide view of customers, opportunities, or interactions. The B2B Sales aggregation project aims to bring unified visibility to coordinate cross-unit engagement, govern sales at group level, and lift CRM data quality — built on the Data Platform (Databricks).
To deliver the B2B Sales Data Aggregation Hub on Databricks: ingest and harmonize CRM data (Salesforce, Dynamics 365, Excel/SharePoint) into Databricks Bronze and Silver layers using Databricks native pipelines and Delta Lake features; implement daily CDC/incremental ETL, automated data quality checks and a data quality snapshot, and deliver KPI cards for CEO/EB.
Tasks:
• Lead technical implementation (Databricks-native architecture)
• Design & build ETL pipelines and CDC/incremental connectors for Salesforce & D365 (and Excel/SharePoint) using Databricks patterns (Auto Loader / Structured Streaming / Jobs)
• Implement Bronze → Silver transformations and reusable SQL/Notebook templates in Databricks (Delta Lake)
• Develop Databricks notebooks (PySpark) and apply Delta Lake optimisations (compaction, Z-order, caching)
• Build automated data-quality checks, metrics and the CEO/EB data-quality snapshot & KPI cards
• Set up monitoring, alerting, job orchestration and operational runbooks (Databricks Jobs / Alerts / Observability)
• Document architecture, data lineage (Unity Catalog / Delta timetravel) and handover to operations
• Support UAT, performance testing and hypercare
Experience - skills/Experience are required:
• 5+ years data engineering Experience
• 3+ years Databricks + Delta Lake
• Strong PySpark / Python and SQL skills
• Proven Experience integrating Salesforce & Dynamics 365 (APIs, CDC, Bulk API)
• Data modelling, ETL design, incremental sync/CDC approaches
• Experience with Azure cloud services and Databricks workspace admin
• Experience building data quality frameworks and monitoring
• Good stakeholder communication; able to act as technical owner
Experience - Additional skills that would be considered as plus:
• Proven CRM expertise (Salesforce, Dynamics 365)
Job Title: Senior Data Engineer
Location: Baden, Switzerland
Job Type: Contract
TEKsystems, an Allegis Group company. Allegis Group AG, Aeschengraben 20, CH-4051 Basel, Switzerland. Registration No. TEKsystems is a company within the Allegis Group network of companies (collectively referred to as "Allegis Group"). Aerotek, Aston Carter, EASi, TEKsystems, Stamford Consultants and The Stamford Group are Allegis Group brands.