Senior data modelling analyst (data modelling and architecture)

Brand New Day is building a BIRD-aligned semantic layer that will become the foundation for finance, risk, balance sheet management and regulatory reporting. We are looking for a Senior Data Modelling Analyst who can bring structure to complexity. Someone who enjoys turning ambiguous requirements into clear definitions, consistent data models and implementation-ready mappings.

You will work at the intersection of business and engineering. One day you are aligning finance and risk stakeholders on a single definition. The next, you are helping engineers translate that definition into a scalable and traceable data model.

This role is ideal for someone who enjoys ownership, thrives in situations where not everything is defined yet, and wants to grow towards a hands-on Data Architect position.

What will you do as a Senior Data Modelling Analyst?

Brand New Day is investing in the next generation of its data platform. As part of a broader transformation programme, we are implementing BCBS 239-compliant data management capabilities, modernising regulatory reporting and building a BIRD-aligned semantic layer as the foundation for consistent reporting and risk management.

As a Senior Data Modelling Analyst, you translate business input into a coherent, Industry-standard semantic data model (BIRD) and engineering-ready mapping specifications. You take ownership of the logical data model across Finance, Risk, BSM and regulatory reporting, ensuring consistent definitions, clear lineage and a scalable structure across domains.

You do more than just document requirements, you shape them. You work closely with business analysts, stakeholders and data engineers to clarify requirements, challenge inconsistencies, make trade-offs explicit and drive decisions needed to build a usable and trusted data foundation. You are comfortable working without complete upfront clarity and are able to shape the path forward. You have the ambition to grow into the role of hands-on Data Architect.

Success in this role means: helping establish a complete, maintainable semantic layer and mapping logic that engineers can implement without reinterpretation, and that stakeholders can trust for regulatory reporting , risk management and decision-making..

Your key activities and responsibilities in short:

• Run focused workshops with Finance, Risk, BSM and Data stakeholders where you facilitate decision-making on clear company definitions, and priorities.
• Translate business concepts into structured BIRD-aligned logical models, including entities, attributes, relationships, grain, definitions and business meaning.
• Take ownership of the logical data model and ensure it remains consistent, maintainable and scalable across domains over time.
• Produce engineering-ready mapping logic from source systems to the data warehouse and reporting outputs, including transformations, business rules, aggregations and edge cases.
• Establish end-to-end data lineage, validation and reconciliation logic so data can be traced, explained, audited and trusted for regulatory use.
• Document models, mappings, naming standards, metadata and decisions in a precise, version-controlled and reusable format, enabling engineers and future maintainers to extend the model consistently.

Fluency in English and at least seven years of relevant experience in the Dutch banking sector, with proven knowledge of/track record in:

• Driving decisions, maintaining consistency and guarding the quality of the logical data model
• Semantic modelling, data lineage and metadata management
• Working with Finance and Risk stakeholders and the ability to both challenge and align with them
• Working with DNB, EBA or ECB regulatory reporting expectations
• Using SQL to validate data and mappings
• Turning business requirements into precise, testable definitions and mappings.
• Working across business and engineering teams and producing implementation-ready specifications

Nice-to-haves:

• Exposure to data architecture concepts and an interest in growing into a data architect role
• Experience with medallion architectures, such as Bronze, Silver and Gold
• Experience with Databricks, Azure, dbt or similar modern data platforms
• Experience with data modelling tools and version-controlled documentation, such as Git, Collibra, Confluence or similar
• Experience in smaller or scaling organizations where structure needs to be built pragmatically
• Fluency in Dutch

• A pleasant salary 7.500 between and 9.500 plus pension accrual
• 25 vacation days + 1 extra day off for celebration!
• The option to work from home two days per week and one week remote per year (two weeks for expats)
• Training budget of €1,000 per year to stay up to date in your field
• €25 per month benefit budget for 1,001 fun or useful things (via Alleo)
• Every week a fully catered lunch at the company’s expense (On other days, you’ll need to arrange your own, but no worries: we’re right next to the Amsterdamse Poort, so you’ll have plenty of options.)

Who are you?

You are a structured, decision-oriented thinker who brings clarity to complex questions. You enjoy working in environments where precision matters. You take ownership of requirements, challenge inconsistencies, and translate ambiguity into clear, practical outcomes. You enjoy building models and mappings that others can rely on. You collaborate easily, but you also take responsibility for the quality and usefulness of what you deliver.