Reference Data Management -Data Analyst

Overview

Analyse, maintain and govern commercial reference data and codelists within the Informatica MDM platform, supporting the Reference Data Management capability that feeds Sanofi's Snowflake-based commercial data ecosystem.

What you'll do

• 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 working knowledge of commercial reference data domains (markets, products, customers, organizational hierarchies) and their definitions, structures and interdependencies
• Work with business stakeholders, Data Owners and Data Stewards to 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
• 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 UAT test cases 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
• 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
• 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 and escalate to the appropriate technical team when required
• Maintain Jira records for assigned activities, including scope, estimates, status, dependencies, risks, blockers and ETAs, and proactively communicate progress and issues
• Collaborate 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

What you'll need

• Strong SQL and data analysis/profiling skills, with the 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
• 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
• 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
• 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
• Ability to work effectively in a global and multicultural environment
• Excellent written and verbal communication skills
• 4+ years of experience as a Data Analyst, with demonstrated experience in data manipulation, data analysis and/or master data management
• Fluent in English

Nice to have

• Experience with RDM/MDM platforms; knowledge of Informatica MDM is strongly preferred
• Experience in a healthcare or pharmaceutical company is a strong plus
• Bachelor's or Master's Degree in Computer Science, Information Management, Data Science, Mathematics or a related field

Details

• Location: Hyderabad