About this role
Salary: £45,000 - 60,000 per year
Requirements
- Strong experience in dimensional data modelling, including star schema design, fact and dimension tables, data relationships and schema optimisation.
- Demonstrable hands-on Databricks coding experience, including data transformation, processing and modelling.
- Strong SQL development skills, including complex queries and transformation logic.
- Experience translating business data requirements into logical and physical data models, technical specifications and reporting structures.
- Experience collaborating with data engineering teams to implement data models and transformations in cloud-based data platforms.
- Good understanding of Azure Data Lake, Azure Data Factory and medallion architecture principles.
- Experience with Power BI, semantic modelling, DAX and reporting development.
- Good understanding of ETL/ELT processes, data integration and data quality principles.
- Experience with data warehouse modernisation, migration or cloud data transformation programmes is advantageous.
- Cognos knowledge is beneficial but not essential.
- Strong analytical and problem-solving skills, attention to detail, and a methodical approach to solution design.
- Ability to work independently, own technical deliverables and make informed design decisions.
- Effective communication and collaboration skills.
- Proactive, curious approach to technology and comfortable working in an agile environment.
Responsibilities
- Design and develop scalable dimensional data models, including star schemas, fact and dimension tables, relationships and semantic layers.
- Translate business requirements and user stories into technical specifications covering data structures, transformations, calculations and reporting logic.
- Develop logical and physical data models, measures, KPIs and critical data elements.
- Apply modelling best practices and define data quality requirements, validation criteria and transformation logic.
- Design reusable data structures for reporting and analytics.
- Use Databricks and SQL to design, develop and validate models, transformation logic and reporting structures in an Azure data lake environment.
- Apply Azure Data Lake and medallion architecture principles to organise and prepare data for reporting.
- Work with offshore data engineers, providing specifications and guidance for pipelines, transformations and integrations.
- Review technical solutions, identify architectural or data quality issues, and contribute to problem-solving and architecture decisions.
- Support migration of data sources, reporting structures and Cognos reports from the legacy warehouse to Azure.
- Develop reporting models and semantic layers for Power BI dashboards, financial reporting and management information.
- Develop and maintain solutions using Power BI, Power BI Report Builder and DAX; define calculations, measures and KPIs.
- Review existing reporting structures for opportunities to simplify, automate and improve performance.
- Support financial, operational, regulatory and risk-related reporting, collaborating with the Management Information team to improve data quality, consistency and accessibility.
- Collaborate with data engineers, BI developers, governance specialists and other technical colleagues; provide technical guidance on modelling, schema design and reporting architecture.
- Contribute to data governance, data quality and technical standards, and identify improvements to efficiency, scalability and maintainability.
- Support the development and mentoring of a Data Apprentice.
Technologies
- Azure
- Cloud
- Data Warehouse
- Databricks
- DAX
- ETL
- Support
- Power BI
- SQL
- Backend
- Business Intelligence
- Flow
More
We are hiring an experienced Data Modeller & Developer for our Finance & Management Information team, within the financial services division of a major international organisation. The role contributes to a significant transformation from a legacy Cognos and SQL data warehouse to a modern Microsoft Azure data lake, helping shape future data and reporting capabilities. Our UK team has approximately 350 people, and we offer a collaborative, supportive and professional environment that values employee development, teamwork, mutual respect and continuous improvement. This is a permanent, technically focused position based in Milton Keynes, with a hybrid arrangement requiring three days onsite per week. The salary is £45,000–£60,000 per year. Benefits include a company car, company pension, free and onsite parking, life insurance, private medical insurance and work-from-home options.
last updated 45 week of 2026