Senior Analytics 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.