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

\n
• Design and maintain enterprise and domain-based data models
\n
• Analyse and integrate complex data sources
\n
• Develop source-to-target mappings across batch, real-time and streaming data
\n
• Support the evolution of an enterprise data model and data products
\n
• Produce data modelling, mapping and design documentation
\n
• Work closely with data engineers, architects, business stakeholders and third parties
\n
• Present technical designs and recommendations to senior stakeholders
\n

What We’re Looking For

\n
• Strong experience in data modelling, mapping and enterprise data architecture
\n
• Knowledge of Kimball/Inmon, star schemas, fact/dimension modelling, OLAP, data lakes and ERDs
\n
• Experience with modelling tools such as ER/Studio, Erwin or Sparx EA
\n
• Experience with Azure data services, particularly Azure Data Factory or Databricks
\n
• Strong understanding of ETL, CDC, data integration and transformation
\n
• Experience working in complex, agile and/or multi-vendor environments
\n
• Strong communication and stakeholder management skills
\n

Experience within financial services or another regulated environment would be advantageous but not a hard ask.

The role offers:

e

\n
• Hybrid working, with approximately 50% home / 50% office.
\n
• 28 days annual leave plus bank holidays.
\n
• Employer pension contributions of up to 14% and discrestionary bonus.
\n
• Private medical insurance.
\n
• The opportunity to work with modern cloud data platforms and large-scale enterprise data architecture.
\n

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.