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