Senior Data Modeller / Architect - Financial Services

Data Science Talent; Swindon; On-site; GBP 70,000 - 90,000; Full time

Job summary

Data Science Talent is seeking a senior data modeller to join a new Data Programme team in Swindon, England. You will work alongside the Technical Programme Lead to shape a transformative data strategy, define governance standards, and design complex data models. Ideal candidates will have extensive experience in data modelling, governance in regulated environments, and strong communication skills with stakeholders. As one of the earliest hires, you’ll play a pivotal role in executive-level reporting and strategic decision-making.

Qualifications

• Defining data governance and documentation standards.
• Designing logical and physical Lakehouse models.
• Building semantic structures for Power BI reporting.

Skills

Strong enterprise-level data modelling experience

Hands-on experience designing Lakehouse or Data Warehouse architectures

Strong stakeholder communication skills

Experience working in highly regulated data environments

Strong understanding of Databricks architecture

Tools

ER Studio

Azure DevOps

Job description

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