Reference Data Management -Data Analyst

About the job

The Reference Data Management (RDM) capability is a foundational pillar of Sanofi's commercial data ecosystem, designed to deliver clean, governed, and AI-ready reference data and codelists at enterprise scale.

RDM manages 200+ commercial codelists spanning 50 countries, providing the standardized definitions, mappings, hierarchies, and classifications that underpin downstream analytics, AI models, and business intelligence across the commercial organization. These codelists — covering domains such as markets, products, customers, hierarchies, and organizational structures — serve as the single source of truth for commercial reference data, ensuring consistency, accuracy, and compliance across global markets.

The capability integrates tightly with Sanofi's Snowflake-based data platform, where RDM data is consumed by 50+ downstream systems, data shares, and AI/analytics applications. A key architectural principle is that clean, governed codelists are the foundation for AI/analytics consumption — without accurate, well-structured reference data, AI models and business insights cannot be trusted or scaled.

RDM is built on the Informatica MDM platform and follows enterprise data governance standards, ensuring that all reference data changes are properly assessed, approved, validated, and documented. The capability is governed by a cross-functional team including the RDM Platform Product Owner, Data Owners, Data Stewards, and Platform/System teams, and is sponsored by the Global Head of GTMC Data Management and Head of Global Commercial Data Foundations.

As Sanofi scales its AI-powered commercial capabilities, RDM plays a critical role in enabling trusted, reusable, and interoperable data — reducing duplication, maximizing data quality, and accelerating time-to-insight for business stakeholders worldwide.

Main Responsibilities

Hands-On Data Analysis & Codelist Management

· Query, profile, and analyze commercial reference data and codelists using SQL to answer business questions, validate data quality, and identify inconsistencies or risks

· Maintain and manage commercial codelists, including values, definitions, attributes, mappings, hierarchies, and relationships within the Informatica MDM platform

· Perform data quality audits and proactively flag data issues, duplications, or structural problems that may impact downstream consumers

· Develop strong working knowledge of commercial reference data domains (markets, products, customers, organizational hierarchies) and their definitions, structures, and interdependencies

Requirements Translation & Impact Assessment

· Work closely with business stakeholders, Data Owners, and Data Stewards to understand and translate business requirements into clear RDM, data, and codelist requirements

· Assess the business and functional impact of reference data changes, including effects on downstream consumers, integrations, Snowflake data shares, views, and synchronization processes

· Support analysis of RDM-to-Snowflake data flows and proactively flag potential impacts to Platform, System, and Data teams

· Coordinate with the RDM Platform Product Owner and technical teams to understand platform capabilities, dependencies, and constraints

End-to-End Change Coordination & Validation

· Coordinate RDM changes end-to-end, from requirement clarification and technical scoping through implementation, UAT, validation, and confirmation of outcomes after deployment

· Define and execute test cases (UAT) to validate that codelist changes meet functional and business requirements before production deployment

· Ensure required business and data governance approvals are obtained and documented before changes are implemented

· Support UAT and data validation activities, engaging business and technical stakeholders as needed

Data Governance, Documentation & Compliance

· Ensure all RDM data is managed and analyzed in compliance with applicable Data Privacy, GxP, SOX, and cybersecurity requirements

· Maintain accurate and audit-ready documentation for codelists, including definitions, ownership, mappings, dependencies, change history, and required approvals

· Coordinate with Data Owners and Data Stewards to ensure data governance responsibilities are clear and upheld

· Support enterprise data governance processes and contribute to continuous improvement of RDM data quality and standards

Reporting, Access Management & Support

· Maintain and support existing Power BI reports, including basic synchronization, refresh activities, and troubleshooting

· Manage access requests for commercial codelists, RDM data, and related Power BI reports, coordinating with Platform/System or Access teams as required

· Perform first-line troubleshooting of reporting and access issues; escalate to the appropriate technical team when required

Collaboration & Continuous Improvement

· Maintain Jira records for assigned activities, including scope, estimates, status, dependencies, risks, blockers, and ETAs; proactively communicate progress and issues

· Collaborate effectively with Product Owners, Data Owners, Data Stewards, Business, Platform, System, and Data teams in an Agile environment

· Contribute to continuous improvement of RDM processes, data quality, documentation, and ways of working

· Take end-to-end ownership of assigned activities and proactively raise risks, blockers, or dependencies that may impact delivery

About you

Technical & Data Skills

· Strong SQL and data analysis/profiling skills — ability to query, manipulate, and validate complex datasets

· Good understanding of databases, data structures, and data flows

· Experience with Reference Data Management (RDM), Master Data Management (MDM), and/or Data Governance

· Understanding of codelists, mappings, hierarchies, classifications, and business rules

· Experience with RDM/MDM platforms; knowledge of Informatica MDM is strongly preferred

· Good understanding of data quality and data governance concepts, including ownership, stewardship, definitions, metadata, and approvals

· Understanding of cloud data platforms such as Snowflake and downstream data consumption patterns (views, data sharing, synchronization)

· Understanding of integration, ETL, and MDM concepts

· Basic Power BI knowledge, including report refresh/synchronization and access management

· Ability to perform first-line investigation of data, reporting, and access issues and coordinate resolution with technical teams

Analytical & Problem-Solving Skills

· Strong ability to investigate data issues and identify root causes

· Ability to assess business and technical impact, dependencies, and risks associated with data changes

· Ability to translate business requirements into clear data and technical requirements

· Strong attention to detail and ability to identify inconsistencies or potential risks

· Ability to work independently, investigate issues, and provide clear recommendations

Collaboration & Ways of Working

· Strong stakeholder management skills across Business, Data, Platform, and System teams

· Demonstrated ability to take ownership of activities from requirement through implementation, validation, and handover

· Proactive communication and timely follow-up of requests, actions, and issues

· Ability to work effectively in a matrix and global organization

· Experience working in an Agile environment and using Jira

· Strong documentation and knowledge-sharing skills

· Ability to provide clear responses, incorporate feedback, and collaborate constructively with others

· Professional, respectful, and collaborative communication style

· Ability to work effectively in a global and multicultural environment

· Excellent written and verbal communication skills

Experience

· 4+ years of experience as a Data Analyst, with demonstrated experience in data manipulation, data analysis, and/or master data management

· Experience in a healthcare or pharmace