> Markdown version of [/jobs/ext/2797507-senior-consultant-data-modeler-engineering](https://www.wearedevelopers.com/jobs/ext/2797507-senior-consultant-data-modeler-engineering). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Consultant - Data Modeler (Engineering) - **Company:** Intuita - **Location:** Liverpool, UK (Remote available) - **Experience:** Expert - **Salary:** £45,000.0 - £68,000.0 - **Contract:** Permanent contract - **Skills:** Agile Methodology, Amazon Web Services, Business Intelligence Development, Data Governance, Extract Transform Load (ETL), Data Structures, Data Warehousing, Database Queries, Meta-Data Management, Scrum Methodology, Data Streaming, Technical Data Management Systems, Data Lineage, Tools for Reporting - **Published:** September 8, 2026 - **Apply:** https://www.collegerecruiter.com/job/2840645494-senior-consultant-data-modeler-engineering ## About the Role We are looking for an experienced, driven, and hands-on data engineer with strong data modelling experience, to join our growing consultancy and lead the delivery of a key migration project. You will play a key role in the migration and redevelopment of an existing Data Warehouse into a modern AWS-based environment. This position focuses on analysing current ETL processes, understanding existing data structures, and re-engineering them in line with dimensional and analytical modelling best practices. There will be a strong emphasis on data modelling, transformation logic, and data quality. Key to this role will be the ability to take ownership of highly technical data challenges, with an unrivalled attention to detail. You will thrive on complex data challenges, working both independently and through collaboration with team members to find elegant and efficient solutions., * 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. * Experience working in Agile methodologies (Scrum / Kanban). * 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. * 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. ## Description * 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. ## Related Videos - [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Python-Based Data Streaming Pipelines Within Minutes](https://www.wearedevelopers.com/videos/1233-python-based-data-streaming-pipelines-within-minutes) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Unlocking Value from Data: The Key to Smarter Business Decisions-](https://www.wearedevelopers.com/videos/1367-unlocking-value-from-data-the-key-to-smarter-business-decisions) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [UK Business Culture and Etiquette](https://www.wearedevelopers.com/magazine/326-uk-business-culture-and-etiquette) - [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023) - [IT Salaries in UK](https://www.wearedevelopers.com/magazine/288-it-salaries-in-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)