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.

POSITION OVERVIEW:

Data Architect position reports to the Head of Data Architecture, Modeling & BI in the CHC business unit in Sanofi

• A cornerstone of CHC transformation in the coming years, the Data Modeling Architect create relationships across the enterprise that help to understand CHC’s business model, current data environment and needs, and how data drives the success.

• This position will collaborate with all our business functions to provide guidance in implementing the right data model and practices that meet their needs.

• The Data Modeling Architect will closely work with business partners, business stakeholders, and the data governance team to create a logical data model architectures for various data objects.

• The Data Modeling Architect will work on modern data architecture techniques and cloud data technologies.

• The candidate must be able to work independently and collaboratively

You will work with a diverse team of business analysts, data scientists, technical engineers, data architects, and project managers to deliver outcomes aligned with our business need.

KEY RESPONSIBILITIES:

The Data Architect will be responsible for:

• Lead all data modeling efforts within Snowflake, including the design of data structures and the identification of business transformation logic.

• Analyzing and translating business requirements into conceptual and fully detailed logical data models.

• Creating logical data models based on existing applications and databases.

• Working with business architects, data architects, and data stewards to capture business requirements in a Logical Data Model.

• Transform the logical representation of the model into a physical representation and work with database administrators to instantiate and manage the data.

• Contribute to assessment of appropriate data platform(s) for solutioning efforts.

• Responsible for the development of the implementation of on-prem and/or cloud native RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL)

• Collaborate with the BI and Analytics teams on creating the optimized, reusable semantic model, complete with metadata and lineage information.

• Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices

• Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models

• Optimize the model to ensure predictable performance

• Maintain the metadata – the “data about the data” describing the data model, its structure, and semantics

• Setup and govern end-to-end DevOps lifecycle using Git

QUALIFICATIONS:

7 years or more experience in Data Analytics and Modeling. 3+ years’ experience in Snowflake

• Experience working in FMCG

• Experience in Data Vault methodology would be a strong added value.

• Experience in Data strategies and developing logical and physical data models on RDBMS, NoSQL and Cloud native databases

• Advanced SQL Skills

• Experience with BI tools

• Agile ways of working and large projects phased delivery

Data & Business intelligence domain and software experience is a plus:

• Experience of Interfacing heterogeneous systems and data sources

• Experience in Snowflake and Power BI

• Working knowledge of Informatica, Layer 7 and Apigee

• Working knowledge of procuring data from ERPs (SAP, JDE, etc.).

Education:

• Bachelor’s Degree

• Fluent in English

International program management skills:

• Work with 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:

• Leading 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)

REQUIRED SKILLS & COMPETENCIES:

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.