Patient Insights Data Engineering Lead

About the role

Alexion Japan is looking for a Patient Insights Data Engineering Lead to build the foundation for Patient Insights across APJ. The role leads the integration, modelling and use of patient-related data such as Patient Ladder and Real World Data (RWD), using a cloud data platform centred on Snowflake, with Fivetran for data movement and dbt for transformation and modelling.

Key responsibilities

• Integrate Patient Ladder, RWD, EMR, CRM, Patient Support Systems and market research data, design pipelines from each CRM source to Snowflake, map and standardise data sources and manage data quality
• Design Snowflake data warehouses and data marts, data models usable by Patient Insights, BI, analytics and AI, and build a reusable, scalable architecture
• Build reusable data models and a sustainable data engineering process with dbt, including testing and documentation
• Set up and run Fivetran pipelines between source systems and Snowflake, troubleshoot issues and design new integrations
• Build datasets for patient journey analysis and provide analytics-ready data for BI, advanced analytics and AI teams

Required profile

• Native Japanese, able to define requirements and communicate independently with Japanese business stakeholders
• English at a level sufficient for APJ stakeholder communication
• Experience designing and developing data pipelines and data modelling in practice
• Preferred: pharmaceutical industry experience, RWD handling, patient analytics, healthcare data knowledge, CRM/HCP data integration, BI tools, AI/ML dataset building and data governance

Required skills

• Snowflake data warehouse and data mart design and development
• SQL-based data processing and modelling
• dbt data transformation and modelling
• Fivetran data integration and pipeline building
• Data modelling, data quality and ETL/ELT knowledge