Expert Master Data - Quality & Performance

About the job

• Design, build, and maintain data structures to support Master Data quality initiatives.
• Develop and manage Snowflake-based data architectures and advanced data models including star & snowflake schemas optimized for analytics.
• Design and implement modular, reusable SQL models in dbt
• Integrate dbt with orchestration tools and cloud warehouses (Snowflake)
• Implement best practices for data governance, integrity, and compliance across Snowflake and DBT workflows.
• Secure master data (MD) quality and availability at the Sanofi target
• Support master data quality improvement activities across all sites in the frame of M&S master data playbook
• Identify any master data quality and availability issues and propose solutions and remediation (continuous improvement spirit)
• Provide technical analysis on Masterdata and implementation of new scope

Data technical lead:

• Responsible the architecture and data modelling of the DataLab
• Support the development of Power BI tools and Power Apps by providing organized data sets
• Design and manage Snowflake data architectures and advanced data models.
• Create and maintain optimal data pipeline architecture
• Identification and sourcing of data (Snowflake). Close collaboration with Sanofi Digital Data Foundation.
• Propose and design technical solution to topics relative to the DataLab, in collaboration with Sanofi Digital team
• Ensure the integrity of the tool and the correctness of the data sources

Continuous improvement responsibility:

• Driving continuous improvement for Master DataLab efficiency by identifying and raising initiatives to respective team lead
• Supporting Master DataLab evolutions, projects, and improvement initiatives by performing feasibility study and assessment
• Providing input for documentation, training materials, and knowledge management for the architecture, data modelling and technical part of the DataLab

Master data user support and monitoring:

• Supporting MD community on site level, for instance conduct impact analyses for upcoming site project
• Contributing to the education of the MD community

Preferred skills/expertise/experience:

Experience:

• Minimum 5 years in Master Data Management with knowledge of pharma industry (e.g., GxP)
• Preferably, work experience / educational background in data analytics (covering supply chain mgmt. / logistics / pharma quality mgmt. / pharma manufacturing)

Skills/expertise:

• Strong understanding of Master Data Management, Data governance frameworks local processes, and site systems
• Work experience with data analytics tools, data visualization (PowerBI and PowerApps), Data sourcing (Snowflake, SP List, Power Automate), data processing (dbt) - Mandatory
• Work experience with SAP ERP (ECC 6.0, S/4H) / LIMS - Optional
• Mandatory English, preferably languages for key markets (French)

Competency requirements:

• Strong problem-solving skills
• Analytic mindset
• Detail-oriented and deep understanding of Data lifycycle
• Effective communicator and team player for resolving ad-hoc issues.
• Strong willingness to learn

Sanofi values

• Stretch to go beyond the level we have operated at up until now
• Act in the interest of our patients and customers
• Take action instead of waiting to be told what to do
• Put the interests of the organization ahead of my own or those of our team