Data Engineer

Industry: Pharma

Project language: English

Project length: 6 months contracts + option for prolongations; full-time

Start: ASAP

Assignment type: B2B

About the Role

Join the Global Commercial IT team as a Senior Analytics Engineer and take part in transforming our Common Data Platform (CDP), which integrates and delivers business-critical data across 43 European and Canadian affiliates. You’ll be joining a product team responsible for building and maintaining our AWS-based Data Lake, DBT Cloud transformation pipelines, and Snowflake data warehouse, enabling high-quality commercial and engagement insights across channels.This role goes beyond coding – we’re looking for someone with strong technical expertise, a proactive mindset, and the ability to build foundations where there are none, improve data quality and reliability, and collaborate closely with business-facing product owner.

Key Responsibilities

 •  Design, build, and maintain robust ETL/ELT pipelines in DBT Cloud, ingesting data from sources like OCE IQVIA, Adobe Analytics, Qualtrics, Salesforce CIAM, and others.  

•  Contribute to the migration of legacy Snowflake and Qlik environments into the unified EUCAN CDP instance.  

•  Implement data quality validation frameworks (e.g., DBT tests, freshness checks, anomaly detection).  

•  Support and improve our RUN Management process: monitoring, reruns, root-cause analysis and preventive actions.  

•  Maintain and document model ownership, schema logic, and transformations within our CDW_CORE > CDW_STAGE > CDW_PROD architecture.  

•  Collaborate closely with Product Owner, Data Architect, and affiliate stakeholders to ensure delivery of trusted, scalable and governed data products.  

•  Mentor junior engineers and act as a point of escalation for complex data issues.

Tech Stack & Environment

•  DBT Cloud (core ELT engine).

•  Snowflake (Data Warehouse).

•  AWS S3 (Data Lake, ingestion zone).

•  GitHub, Azure DevOps.

•  Data sources: IQVIA OCE, Salesforce Marketing Cloud, Adobe AEM/Analytics, Shopify, Qualtrics, Accutics, Facebook/LinkedIn/Instagram.

Must-Have Qualifications

•  5+ years of experience as a Data Engineer working with cloud-based ELT pipelines.

•  Expert-level SQL and DBT modeling skills.

•  Deep understanding of data warehousing concepts (dimensional modeling, incremental loading, performance optimization).

•  Experience with Snowflake and cloud data architecture.

•  Strong communication and documentation skills – must work well in distributed teams.

•  Proactive attitude: ownership over data quality, incident handling and delivery discipline.

Nice-to-Haves

•  Experience in the pharmaceutical or commercial and Sales data domains (CRM, HCP, field force).

•  Exposure to GDPR and data privacy requirements in commercial data.