Data Engineer

The role will regard Sanofi Consumer ; Becoming a standalone division, Consumer Healthcare s purpose is toserve healthier, fuller livesby offering moments of relief to our Patients & Consumers in our key platforms, including Allergy, Physical & Mental Wellness, Pain, Digestive CHC does business in 133 countries; 4000 professionals work in marketing, sales and services Learn more at .

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

Global Digital 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 This team leverages both dedicated expertise internally at Sanofi, and delivery and deployment It builds products, runs service / outsourcing contracts, and develops centers of excellence in technology and

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

JOB PURPOSE

• 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
  

KEY ACCOUNTABILITIES

• 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 ()
  
• 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 & 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, ) and cybersecurity requirement
  

Requirements

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

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

Data & Business intelligencedomain and software experience is a plus

• Experienced in Informatica IDQ
  
• Working knowledge ofInterfacing heterogeneous systems and data sources
  
• Working knowledge ofSnowflake,DataBricks, Python/R, Tableau, Power BI
  
• Working knowledge ofLayer 7, Tibco and Apigee
  
• Working knowledge of procuring data from ERPs (SAP, JDE, )
  

Education

• Bachelors 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, )
  
• 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, ) and complexity (architecture, emerging tech)
  
• Fast learner in new industries and functions (, 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)