Expert D&T - Senior Data Modeler - Finance

dsm-firmenich; Barcelona; Presencial; EUR 70.000 - 90.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Career paths

Science-led company

Growth opportunities

Collaborative culture

Voice matters

Descripción de la vacante

dsm-firmenich in Barcelona is seeking 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 for the Finance domain.

You will translate business requirements into formal data models, define standards, and deliver implementation-ready specifications to data engineering teams, ensuring historical correctness and data integrity across layers.

Formación

• Proven ability to lead the full Data Vault modeling lifecycle—from conceptual sessions with business stakeholders and domain experts through logical design to physical model specs.
• Deep hands-on expertise in Data Vault 2.0 and dimensional modeling for analytical consumption.
• Ability to own and govern data models across historized and consumption layers with clear contracts.

Responsabilidades

• Own the data model design across the integrated vault layer and business-facing analytical structures.
• Define and govern the modeling approach for each business domain based on requirements.
• Deliver precise, implementation-ready model specifications for data engineering teams.
• Translate complex business requirements into formal data models with SME input.
• Collaborate with BI/analytics to validate consumption-ready structures for reporting.
• Define and enforce modeling standards, naming conventions, and metadata documentation.

Conocimientos

Data Vault modeling

Data Vault 2.0

Medallion Architecture

Dimensional modeling

Data governance

Documentation

Stakeholder collaboration

ETL/ELT patterns

SQL collaboration

Herramientas

SAP data structures

Descripción del empleo

Job Title: Expert D&T - Senior Data Modeler - Finance

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 for Finance domain.

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.