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!
Director of Embedded Software Development & Delivery at Cochlear driving next - generation software platforms. Leading engineering teams across Europe while ensuring regulatory compliance in medical devices.
Senior Architect overseeing DevSecOps Platform Transformation at Travelers. Building relationships across engineering teams and advocating for technical direction with a focus on AI - powered solutions.
Senior Engineer providing technical support for Carolinas Dispatchable Generation Stations within Duke Energy. Responsibilities include project implementation, controls support, and technical resource management in engineering specialization.
Senior Associate Developer responsible for designing and developing integration solutions for State Street's high - volume middleware platform. Collaborating within a diverse team to enhance enterprise integration capabilities.
Software Development Analyst at Northrop Grumman supporting Product Lifecycle Management systems. Collaborating across functional teams while providing user support in a technology - driven environment.
Engineering Technician IV providing professional technical support to engineers in research and development. Involves hands - on tasks with electrical, electronic, and mechanical components.
Deep Learning Algorithm Developer developing perception technologies for autonomous driving in real - world environments. Tackling challenges from object detection to 3D perception using state - of - the - art deep learning models.
Senior Manager Engineering Projects at Amgen, managing global capital planning and continuous improvement initiatives for innovative biopharmaceutical solutions.
CNC Programmer responsible for preparing NC programs for milling aerospace components using advanced technologies. Working with cutting tools and machining steel and aluminum at Expleo.
C#.Net Developer responsible for creating software applications. Involves working with various technologies including C#.NET, MVC, .Net Core, and Microservices.