Location
London, hybrid working with requirement to visit the central London office twice a week.

Hours
Contract role for 6 months, full-time hours.

Salary
Competitive daily rate (Outside IR35)

About the Role
Our London-based client is seeking a Lead Data Business Analyst to act as the bridge between business stakeholders and technical data teams. You will define, document, and validate requirements for their enterprise data warehouse, ensuring data models and warehouse structures accurately support business reporting, analytics, and strategic decision-making. Key responsibilities include eliciting and translating business requirements into detailed data requirements, collaborating with data architects and engineers to design dimensional data models, producing and maintaining warehouse documentation, analysing source systems for data quality and lineage, validating data models and ETL/ELT pipelines through testing and UAT, and partnering with stakeholders to prioritise requirements and manage delivery backlogs. You will also identify opportunities to improve data models, resolve inconsistencies, and support data governance and reporting standards.

Experience
- Strong understanding of data warehousing principles including dimensional modelling, star and snowflake schemas, normalisation and denormalisation.
- Extensive experience in data modelling using industry-standard tools.
- Strong SQL skills for data analysis, profiling, reconciliation, and validation.
- Proven experience gathering and documenting business and data requirements.
- Experience producing source-to-target mappings, ERDs, and functional specifications.
- Excellent stakeholder management and communication skills.
- Experience working in Agile environments including user story creation, backlog refinement, sprint planning, and UAT support.
- Experience with cloud-based data platforms, particularly Snowflake.
- Understanding of ETL/ELT frameworks and tools such as dbt and Apache Airflow.
- Knowledge of data governance, metadata management, and data lineage concepts.
- Experience supporting Business Intelligence and reporting solutions.
- Familiarity with modern analytics engineering practices.

About you
Demonstrated ability to deliver enterprise data warehouse or analytics platform projects. Strong communicator able to translate complex technical concepts into business-friendly language and facilitate collaboration across cross-functional teams.

Qualifications
Relevant experience and skills in data warehousing, modelling, and analytics platforms are essential. Formal qualifications are not specified but strong technical and business analysis expertise is required.