Hybrid Senior Consultant – Data Modeler, Engineering

at Intuita

• Job title: Senior Consultant – Data Modeler, Engineering
• Job type: Full Time
• Experience level: Senior
• Salary: £45,000 - £68,000 per year
• Degree requirement: Bachelor's Degree
• Tech skills: ETL, SQL
• Location requirements: Hybrid, Liverpool, United Kingdom

About the role

• Senior Consultant specializing in data modeling for consultancy projects in various sectors. Leading the migration to modern AWS-based environments and ensuring data quality and best practices.

Responsibilities

• Analyse existing data warehouse structures, ETL logic, and reporting datasets to understand current data flows and business rules.
• Design and document dimensional, analytical, and reporting data models aligned to business requirements and best-practice modelling standards.
• Design clear mapping specifications from source systems to target dimensional models.
• Perform testing, reconciliation, and validation of new models and pipelines to ensure data correctness and completeness.
• Collaborate with Data Engineers, BI Developers, and business stakeholders to ensure models support analytical, reporting, and operational needs.
• Support the wider project team with documentation, data lineage, definitions, and modelling artefacts.
• Contribute to improving modelling standards, governance, and data quality across the project.

Requirements

• Strong understanding of data modelling principles (e.g., Kimball, dimensional modelling, analytical modelling).
• Proven experience delivering or contributing to a data warehouse build or migration project.
• Hands-on experience designing analytical and reporting data models.
• ETL/ELT development experience, including analysis of existing transformation logic.
• Strong SQL skills, comfortable writing complex queries for transformation, validation, and reconciliation.
• Experience validating data pipelines and performing reconciliation testing between legacy and new environments.
• Ability to translate business requirements into robust data model designs.
• Strong documentation skills, including producing data dictionaries, mappings, and model diagrams.
• Experience working in an Agile methodologies (Scrum / Kanban).

Benefits

• Really flexible and remote working – we don’t mind when, where or how you work; you are trusted to work in the way that suits you best.
• Genuine care and support for your health and wellbeing – free therapy sessions, financial education, birthday treats and much more.
• Incredible training and learning opportunities – you’ll be surrounded by the best in the business and encouraged to keep growing.
• Freedom and empowerment to own problems and explore new ideas – we allow our consultants to actually be consultants, not just bodies.
• A supportive, friendly team – we work hard and enjoy spending time together, whether it’s in-person at socials or via silly Slack conversations.
• Dog friendly offices – we’re a team of dog lovers, so we’ve made our offices dog friendly!