The role
Job description
Key Responsibilities
• Migrate existing Medical Affairs data pipelines, reporting grains, datasets, and business logic into the IMD Hub target architecture.
• Re-point upstream and downstream integrations to ensure seamless transition from legacy platforms to IMD Hub.
• Validate migrated datasets, KPIs, metrics, and reporting outputs to ensure alignment with source systems and business requirements.
• Create and maintain Source-to-Target Mapping (STTM), data dictionaries, metadata, and technical documentation.
• Support deployment and operationalization of Facts, Dimensions, Gold datasets, Transactional datasets, and existing reporting assets.
• Collaborate with business, analytics, and engineering teams to resolve migration, reconciliation, and data quality issues.
• Support release management, CI/CD processes, monitoring, defect resolution, and production support activities.
• Drive data quality, governance, automation, and standardization initiatives across the IMD Hub ecosystem. • Ensure migrated assets are scalable, maintainable, and aligned with enterprise data architecture standards.
Technical Skills
• Strong expertise in Snowflake (Stored Procedures, Tasks, Data Modelling, Data Pipelines, Performance Optimization, and Data Validation).
• Hands-on experience with Python, automation frameworks, and CI/CD processes.
• Strong understanding of Data Warehousing concepts including Facts, Dimensions, Medallion Architecture, Reporting Datasets, and RRDs.
• Experience in data migration, modernization, and transformation programs.
• Strong experience in data validation, reconciliation, testing, and root-cause analysis.
• Experience creating and maintaining STTM documents, metadata artifacts, and data dictionaries.
• Knowledge of data quality, governance, monitoring, and operational support frameworks.
• Ability to build and support scalable, secure, and maintainable enterprise data products.
Functional Skills
• Strong understanding of the Pharmaceutical / Life Sciences domain, preferably within Medical Affairs. • Ability to understand, interpret, and validate business rules, KPIs, and reporting logic used in Medical Affairs analytics.
• Experience in translating business requirements into data mappings, validation scenarios, and migration strategies.
• Strong understanding of end-to-end data lineage from source systems through data products and reporting layers.
• Ability to work effectively with business stakeholders, Data Governance, Analytics, and Data Management teams.
• Strong documentation, communication and stakeholder management skills.