Go to search Go to main content

A Range of Possibilities

CHC Data Engineer M/F

date posted 08/09/2022
contract type Full time
job id R2656707
location Barcelona, Spain
Descripción de puesto

Le contenu du poste est libellé en anglais car il nécessite de nombreuses interactions avec nos filiales à l’international, l'anglais étant la langue de travail.

About Consumer healthcare (CHC) business unit.  The role will regard Sanofi’ Consumer Healthcare.  Becoming a standalone division, Consumer Healthcare’s purpose is to serve healthier, fuller lives by offering moments of relief to our Patients & Consumers in our key platforms, including Allergy, Physical & Mental Wellness, Pain, Digestive Health. CHC does business in 133 countries; 4000 professionals work in marketing, sales and services teams. Learn more at www.sanofi.com/en/your-health/consumer-healthcare.

Consumer Healthcare is becoming a standalone division within Sanofi in order to become a faster moving, consumer and customer centric business as part of project CHLOE (Consumer HealthCare Lead Optimize Empower). This business and IT transformation will entail a standalone ERP, Financial, Systems, Regulatory and People.

Global Digital Team. The team is charged with accelerating the shift to precision marketing and to e-commerce sales, scaling best-in-class data driven decision making tools, capturing new opportunities in the digital health space and uphauling disjointed commercial systems. This team leverages both dedicated expertise internally at Sanofi, and delivery and deployment partners. It builds products, runs service / outsourcing contracts, and develops centers of excellence in technology and digital.

IShift. IShift is the new generation of SAP S4/ HANA, with one common framework across Sanofi BUs and geographies replacing JDEdwards in the US, OEP and unity in all other geographies.


  • The CHC Data Engineer position reports to Head of Data Governance and Master Data in CHC business unit in Sanofi
  • The Data Quality & Cataloging Expert role is responsible for working in CHC business unit across all functions to implement and manage platform-based support as the Data Quality platform (Informatica IDQ) gets rolled out in the CHC Organization
  • This position requires profound experience of Informatica technologies for Data Quality operationalization
  • This role will work with vendors and contractors, and lead the development of business and technical requirements, monitor end-to-end development lifecycle such as UT, FUT, SIT and conduct UAT
  • The role will be responsible for providing detailed guidance on running data analysis, data profiling, data validation, data cleansing, data standardization, data quality scorecards, integrating sources for running quality checks as well as developing scripts to perform data analysis on the platform as required
  • The Data Quality & Cataloging Expert will work closely with Data Domain Stewards, Data Governance and the broader Data + Analytics team to ensure any technical solution related best practices and guidance is available as programs with focus on data are being rolled out as per the established program charter


  • Manage data quality technical rollouts to program teams from a platform usage & functional coverage standpoint
  • Lead DQ projects as a Lead SME to deliver core DQ objectives as per defined DQ framework
  • Manage a team of internal and external data quality resources and ensure deliverables are met
  • Lead informational training sessions to walkthrough core use cases covered by the applications
  • Create functional use cases on the platform and develop standards of maintaining DQ rules in the platform
  • Provide design guidance IDQ mapplets and rules for deploying data quality validation checks and bring up scorecards
  • Manage integrations between Axon and IDQ applications to display integrated rules/scores on Axon
  • Provide expertise in all aspects of data quality including profiling, validation, standardization, error handling and data cleansing using IDQ (v10.x)
  • Ensure data models, data architecture, data mapping and data dictionary are being used to develop IDQ rules as applicable
  • Assess and recommend IDQ design for individual project tracks
  • Perform Data Analysis using IDQ as applicable
  • Share Enterprise Logical (executable) DQ rules in the form of Mapplets and use CDO’s & LDO’s to run data analysis
  • Implement DQ Scorecards for data validation across chosen dimensions of DQ
  • Run validation checks and help in formulating dimensional comparisons
  • Work in collaboration with IT and Security teams standards & capabilities. Provide support on how data governance should address as part of platform maintenance
  • Communicate regularly with program teams and stewards to make necessary design reviews on the platform as needed
  • Share DQ technology best practices and performance optimization methods as applicable
  • Provide best practice for designing DQ Dashboards using Power BI or Tableau
  • Ensure that data is managed in compliance with applicable quality, regulatory (Data Privacy, GxP, SOX, etc.) and cybersecurity requirement


7+ years or more experience in Digital, 3+ years’ experience in Master Data Management and Data Quality

  • Experience of Master Data Management and DQ, preferably in FMCG 
  • Experience in IICS and Informatica IDQ
  • Enterprise software deployment (design, build, integration, migration, go live, core model) 
  • Agile ways of working and large projects phased delivery 

Data & Business intelligence domain and software experience is a plus

  • Experienced in Informatica IDQ
  • Working knowledge of Interfacing heterogeneous systems and data sources 
  • Working knowledge of Snowflake, DataBricks, Python/R, Tableau, Power BI 
  • Working knowledge of Layer 7, Tibco and Apigee 
  • Working knowledge of procuring data from ERPs (SAP, JDE, etc.)


  • Bachelor's degree
  • Fluent in English

International program management skills

  • Leading multicultural and multi-sourced teams
  • Multi-country deployment, involving local stakeholders
  • Cross functional leadership and influencing
  • Lead people and timelines in a matrix organization in compliant and professional manner
  • Excellent presentation to executive teams, writing, power point and organizational skills
  • Contracting and contract managing software vendors and system integrators
  • Strategic development in a multi-dimensional and rapid changing environment

Digital Program Leadership

  • Working with cross-functional teams to create Digital strategies and roadmaps
  • Design thinking and product development methods (blueprint, iteration, fast pivot, etc.)
  • Transformative digital and/or technology solutions track record (design, develop, deliver)
  • Relentless & creative problem-solving to deliver in a complex governance environment
  • Outstanding risk management and “get things done” mindset
  • Educates on basics (SEO, UI/UX, Agile, etc.) and complexity (architecture, emerging tech)
  • Fast learner in new industries and functions (e.g., legal, finance)

People leadership

  • Outstanding relationship-building, effective in a matrixed, culturally diverse organization
  • Influence skills at all levels of seniority, including people who do not work for him/her
  • Balance pushing for change and bringing people along; conflict resolution mindset
  • Fast & high-quality written communications, business cases and analyses (MS Office)

FMCH/IT skills and competencies

  • Job in FMCG & MDM (advanced)
  • Data Quality (advanced)
  • Lean & Agile practices (advanced)
  • User Experience (intermediate)
  • Vendor Management (intermediate)

Transversal Skills & Competencies (Soft skills)

  • Business Acumen (advanced)
  • Business Partnership (advanced)
  • Transversal collaboration (advanced)
  • Strategic Thinking (advanced)
  • Decision Making (advanced)
  • Change Management (advanced)

At Sanofi diversity and inclusion is foundational to how we operate and embedded in our Core Values. We recognize to truly tap into the richness diversity brings we must lead with inclusion and have a workplace where those differences can thrive and be leveraged to empower the lives of our colleagues, patients and customers. We respect and celebrate the diversity of our people, their backgrounds and experiences and provide equal opportunity for all.

Please note you are leaving the corporate site of Sanofi and are being redirected to our applicant tracking system, Workday, which allows you to apply to our open positions.


Here's who you know at Sanofi!

Reach out to find out more about our company, this opportunity and request a referral.

Please note you are leaving the corporate site of Sanofi and are being redirected to our applicant tracking system, Workday, which allows you to apply to our open positions.