Job Description

Data Engineer / Developer - IMD (International Medical Data) Hub 6 to 10 years Exp

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.