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.