- 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 recent 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:
- Solid 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