Senior Data Engineer

Senior Data Engineer (Databricks & CRM Integration)

Work setup:

Project start date: 10.06.2026 (TBC)

Phase 0.5: Design workshop completed ASAP after contract signing

Phase 1 (Data products live on ADP): 10.07.2026 (first major milestone)

Phase 2 (Light UI production-ready): 04.09.2026

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. CHE-101.865.121. 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. If you apply, your personal data will be processed as described in the Allegis Group Online Privacy Notice available at our website.

To access our Online Privacy Notice, which explains what information we may collect, use, share, and store about you, and describes your rights and choices about this, please go our website.

We are part of a global network of companies and as a result, the personal data you provide will be shared within Allegis Group and transferred and processed outside the UK, Switzerland and European Economic Area subject to the protections described in the Allegis Group Online Privacy Notice. We store personal data in the UK, EEA, Switzerland and the USA. If you would like to exercise your privacy rights, please visit the "Contacting Us" section of our Online Privacy Notice on our website for details on how to contact us. To protect your privacy and security, we may take steps to verify your identity, such as a password and user ID if there is an account associated with your request, or identifying information such as your address or date of birth, before proceeding with your request. commitments under the UK Data Protection Act, EU-U.S. Privacy Shield or the Swiss-U.S. Privacy Shield.