At Intuita, we're looking for a Senior Consultant - Data Modeler (Engineering) to lead the migration and redevelopment of an existing Data Warehouse into a modern AWS-based environment. You will analyze current data structures and ETL processes, then re-engineer them using dimensional and analytical modelling best practices as part of a growing consultancy team.

What You'll Do

Analyze 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.

What We're Looking For

Strong understanding of data modelling principles such as Kimball, dimensional modelling, and 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 Agile methodologies like Scrum or Kanban.
Proactive, dynamic, and driven by delivering quality work, with a great eye for detail.
Takes accountability and ownership of tasks, and finds the best way to solve problems.
An excellent communicator who can make sense of and communicate complex ideas.
Ability to quickly understand client context and demonstrate expertise in their business.
A relationship builder, with the ability to motivate and engage effectively to build trust with clients and colleagues.
An interest in industry trends, emerging technologies, and client’s businesses.

Nice to Have

Experience with dbt for transformation modelling.
Experience working within the Telecoms sector.
Experience with AWS data platform services.
Familiarity with BI/reporting tools and how data models support downstream consumption.
Knowledge of data governance, metadata management, and data lineage practices.

Technical Stack

Team & Environment

You will be part of a growing consultancy, collaborating closely with Data Engineers, BI Developers, and business stakeholders. The team is supportive, friendly, and works hard while enjoying time together.

Benefits & Compensation

Salary: £45,000 - £68,000 per annum depending on experience.
(Really) flexible and remote working.
Genuine care and support for your health and wellbeing – free therapy sessions, financial education, birthday treats and much more.
Incredible training and learning opportunities.
Freedom and empowerment to own problems and explore new ideas.
A supportive, friendly team.
Dog friendly offices.