Senior Analytics Engineer

Data & Analytics

Job ID: #214758

Start Date: ASAP Duration: 4-6 months Language: English (Full Professional) Seniority: Senior Industry: Pharma

Project Language: English Project Length: 6 months contracts + option for prolongations; full-time 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 owners.

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 CDWCORE > CDWSTAGE > 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.