Senior Data Modelling Analyst (data modelling and architecture)

Brand New Day; Amsterdam; Hybrid; EUR 83,700 - 106,020; Full time

Benefits offered by this job

Salary range 7,500–9,500 EUR (monthly)

Pension accrual

25 vacation days

Remote work 2 days/wk + 1 week remote/

Training budget €1,000/year

€25 monthly benefit budget

Weekly catered lunch

Job summary

Brand New Day is seeking a Senior Data Modelling Analyst to bring structure to complexity across Finance, Risk and regulatory reporting. You will translate ambiguous requirements into a coherent BIRD-based data model and engineering-ready mappings, owning the logical data model and ensuring scalable, traceable definitions.

You will collaborate with business analysts, stakeholders and data engineers, driving decisions and shaping the path forward toward a hands-on Data Architect role.

Qualifications

• Fluency in English with seven+ years in banking or financial services data roles.
• Proven ability to translate business requirements into precise, testable data definitions.
• Experience delivering BCBS 239-compliant data management capabilities and regulatory reporting requirements.
• Ability to produce implementation-ready mappings and maintain clear data lineage.

Responsibilities

• Translate business input into a coherent, BIRD-based logical model across Finance, Risk, BSM and regulatory reporting.
• Own the logical data model ensuring consistency, maintainability and scalability.
• Produce engineering-ready mapping logic from source systems to the data warehouse and reporting outputs.
• Establish end-to-end data lineage, validation and reconciliation logic for auditability.
• Document models, mappings and metadata with version-controlled, reusable artifacts.

Skills

SQL

Semantic modelling

Data lineage

Metadata management

Stakeholder management

Regulatory reporting

Implementation-ready specs

Tools

Databricks

Azure

dbt

Git

Collibra

Confluence

Job description

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.

What You’ll Receive From Us

• 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.

Must-haves

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

One more thing: research shows that women and members of underrepresented groups often only apply when they meet 100% of the requirements. Does this sound familiar? If so, we encourage you to apply anyway. We look forward to meeting you!