Expert D&T - Senior Data Modeler (Cross-Domain)

Job Title: Expert D&T - Senior Data Modeler (Cross-Domain)

Location: Barcelona, Spain

Join us as a Senior Data Modeler to own the design and governance of enterprise data models built on Data Vault 2.0 principles within a Medallion Architecture. Be the authoritative voice on data structure, semantics, and integrity.

Your key responsibilities

• Own the data model design across the integrated vault layer and business-facing analytical structures, ensuring historical correctness, structural integrity, and fitness for analytical consumption.
• Define and govern the modeling approach for each business domain, determining the right structure at each layer based on business and technical requirements.
• Deliver precise, implementation-ready model specifications for data engineering teams.
• Translate complex business requirements into formal data models, working directly with subject matter experts and product owners to capture domain semantics accurately.
• Collaborate with BI and analytics teams to validate that consumption-ready structures effectively meet reporting and analytical requirements.
• Define and enforce modeling standards, naming conventions, and metadata documentation practices, maintaining a living catalog of enterprise data models.

We offer

• Unique career paths across health, nutrition and beauty, explore what drives you and get the support to make it happen.
• A science led company, cutting edge research and creativity everywhere, from biotech breakthroughs to sustainability game-changers, you'll work on what's next.
• Growth that keeps up with you, you join an industry leader that will develop your expertise and technical depth.
• A culture that lifts you up, with collaborative teams, shared wins, and people who cheer each other on.
• A community where your voice matters, it is essential to serve our customers well.

You bring

• Proven ability to lead the full Data Vault modeling lifecycle — from facilitating conceptual sessions with business stakeholders and domain experts, through logical design, down to physical model specifications — ensuring every layer reflects both business intent and technical feasibility.
• Deep, hands-on expertise in Data Vault 2.0 and strong command of dimensional modeling for analytical consumption.
• Proven ability to own and govern data models across an integrated historized layer and a business-facing consumption layer, maintaining clear structural contracts between them.
• Solid understanding of Medallion Architecture and how modeling responsibilities map to each layer.
• Ability to produce unambiguous, implementation-ready model specifications that data engineering teams can execute without requiring constant clarification.
• Experience working at the intersection of business and technology — capturing domain knowledge and formalizing it into rigorous data structures.
• Proficiency with data modeling tools and familiarity with how models translate into ETL/ELT patterns, without owning their development. Excellent documentation and communication skills to articulate modeling decisions to both technical and non-technical audiences.
• Familiarity with SAP data structures and business object models from a modeler’s perspective: understanding of how SAP organizes key business entities across core modules, the implications of multi-instance SAP landscapes on integration and awareness of the structural differences between ECC and S/4HANA that affect modeling decisions.
• 5–8 years of experience in enterprise data modeling roles, with a track record of delivering scalable, well-governed data models in complex, cross-functional environments.

About dsm-firmenich

At dsm-firmenich, we don’t just meet expectations – we go beyond them.

Join our global team powered by science, creativity, and a shared purpose: to bring progress to life.

From elevating health to making fortified food and sustainable skincare, the impact of your work here will be felt by millions – every single day. Whether it’s fragrance that helps you focus, alternative meat that’s better for the planet, or reducing sugar without losing flavor, this is where you help shape the future of nutrition, health, and beauty for everyone, everywhere.

And while you’re making a difference, we’ll make sure you’re growing too. With learning that never stops, a culture that lifts you up and the freedom to move across businesses, teams, and borders. Your voice matters here. And your ideas? They’re essential to our future.

Because real progress only happens when we go beyond, together.

Inclusion, belonging and equal opportunity statement

At dsm-firmenich, we believe being a force for good starts with the way we treat each other. When people feel supported, included, and free to be themselves, they do their best work – and that’s exactly the kind of culture we’re building. A place where opportunity is truly equal, authenticity is celebrated, and everyone has the chance to grow, contribute, and feel they belong.

We’re proud to be an equal opportunity employer, and we’re serious about making our hiring process as fair and inclusive as possible. From inclusive language and diverse interview panels to thoughtful sourcing, we’re committed to reflecting the world we serve.

We welcome candidates from all backgrounds — no matter your gender, ethnicity, sexual orientation, or anything else that makes you, you.

And if you have a disability or need any support through the application process, we’re here to help – just let us know what you need, and we’ll do everything we can to make it work.

Agency statement

We’re managing this search directly at dsm-firmenich. If you’re applying as an individual, we’d love to hear from you. We’re not accepting agency submissions or proposals involving fees or commissions for this role.