Senior Data Architect

About the Job

At Sanofi Consumer Healthcare, we build trusted and loved brands that connect with hundreds of millions of consumers worldwide. Our mission is to enable better self-care for individuals and communities, while also contributing to a healthier planet. We strive to act as a force for good by integrating sustainability along our business and employees’ mission and operate responsibly from both a social and environmental point of view. To achieve this, we need people who can shape the future of our business and help us on our journey to becoming the best fast-moving consumer healthcare company in and for the world.

This position reports to the Head of Data Architecture and Modeling in the Consumer Healthcare business unit at Sanofi.

Job Responsibilities

• Lead data architecture & modeling efforts within Snowflake and related cloud data products, including the design of data structures and the identification of business transformation logic.
• Analyze and translate business requirements into conceptual and detailed logical data models.
• Create logical data models based on existing applications and databases.
• Develop on-prem and cloud-native RDBMS, operational data stores (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
• Collaborate 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 the assessment of appropriate data platform(s) for solution efforts.
• Collaborate with the BI and Analytics teams on creating an 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, describing the data model, its structure, and semantics.

About You

• 10+ years of experience in Data Architecture and Modeling.
• 5+ years of experience in Snowflake.
• Strong experience in Snowflake and related cloud data products.
• Proficient in dbt ETL/ELT technologies.
• Advanced SQL skills.
• Experience working in FMCG.
• Experience in data strategies and developing logical and physical data models on RDBMS, NoSQL, and Cloud-native databases.
• Familiarity with Agile methodologies and large project phased delivery.
• Experience interfacing heterogeneous systems and data sources.
• Working knowledge of procuring data from SAP.

Education

• Bachelor's degree.
• TOGAF certification or similar Data Architecture education preferred.
• Fluent in English.
• International program management skills.
• Experience working with multicultural and multi-sourced teams.
• Experience in multi-country deployment involving local stakeholders.
• Cross-functional leadership and influencing skills.
• Expertise in contracting and contract managing software vendors and system integrators.
• Strategic development in a multi-dimensional and rapidly changing environment.

Why Sanofi

At Sanofi, we believe in the power of progress. Better medications, better outcomes, and better science are possible, but progress doesn’t happen without people – people from diverse backgrounds, in different locations, doing different roles, all united by one goal: making miracles happen. So, let’s be those people.

Sanofi is an equal opportunities employer and welcomes applications from all qualified individuals regardless of race, colour, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, ability, or gender identity. Watch our and learn more about our Diversity, Equity, and Inclusion initiatives.

Company Name: Sanofi

Job Title: Senior Data Architect