Senior Data Modeller
Senior Data Modeller
Location: Glasgow or Manchester
Working: Hybrid, 50% office / 50% home
Type: Permanent
We’re looking for a Senior Data Modeller to join a large-scale data transformation programme in a pensions & investment firm, helping build trusted data products that support analytics, reporting, data science and AI.
The Role
- Design and maintain enterprise and domain-based data models
- Analyse and integrate complex data sources
- Develop source-to-target mappings across batch, real-time and streaming data
- Support the evolution of an enterprise data model and data products
- Produce data modelling, mapping and design documentation
- Work closely with data engineers, architects, business stakeholders and third parties
- Present technical designs and recommendations to senior stakeholders
What We’re Looking For
- Strong experience in data modelling, mapping and enterprise data architecture
- Knowledge of Kimball/Inmon, star schemas, fact/dimension modelling, OLAP, data lakes and ERDs
- Experience with modelling tools such as ER/Studio, Erwin or Sparx EA
- Experience with Azure data services, particularly Azure Data Factory or Databricks
- Strong understanding of ETL, CDC, data integration and transformation
- Experience working in complex, agile and/or multi-vendor environments
- Strong communication and stakeholder management skills
Experience within financial services or another regulated environment would be advantageous but not a hard ask.
The role offers:
e
- Hybrid working, with approximately 50% home / 50% office.
- 28 days annual leave plus bank holidays.
- Employer pension contributions of up to 14% and discrestionary bonus.
- Private medical insurance.
- The opportunity to work with modern cloud data platforms and large-scale enterprise data architecture.
If you’re a Data Modeller or Analytics Engineer looking for the opportunity to work on a significant enterprise data platform and help shape the foundations for analytics and AI, we’d love to hear from you.