Senior Data Modeller / Architect - Financial Services

THE JOB

You’ll be one of the earliest senior hires into a brand-new Data Programme team, working directly alongside the Technical Programme Lead and helping shape a multi-year transformation programme that feeds directly into executive-level reporting and strategic decision-making.

This isn’t a role where you inherit established governance and documentation. You’ll be defining it.

Day one looks like this: analysing poorly documented source systems, designing logical and physical Lakehouse models, establishing modelling conventions within ER Studio, and building the semantic structures that Power BI reporting will consume. Alongside that, you’ll help define how Unity Catalogue operates as the governance and metadata layer across the entire platform.

WHAT YOU’LL NEED

Strong enterprise-level data modelling experience - logical, physical, and conceptual modelling across large-scale, multi-source environments

Hands-on experience designing Lakehouse or Data Warehouse architectures, including medallion architecture and semantic layer design

Experience producing canonical data models, dimensional models, and consumption-layer structures aligned to BI and reporting requirements

Experience working in highly regulated data environments, ideally within financial services like wealth management, investment platforms, or similar

Strong understanding of Databricks architecture, including Delta tables, Unity Catalogue, and governance considerations

Experience with ER Studio or equivalent enterprise modelling tooling, with confidence in establishing repositories, standards, naming conventions, and model management processes from scratch

Confidence operating at both strategic and hands-on levels - defining standards while still producing detailed modelling artefacts yourself

Strong stakeholder communication skills - able to challenge, guide, and translate complex modelling decisions for both technical and non-technical audiences

A BONUS IF YOU HAVE

Experience implementing enterprise data governance within Databricks environments

Familiarity with Power BI semantic model design and KPI layer definition

Experience working within Agile delivery environments using Azure DevOps

Experience helping organisations establish enterprise data modelling capability from scratch

#J-18808-Ljbffr