Data Business Analyst
We are seeking a Lead Data Business Analyst for a 6-month contract in London. The role involves collaborating with business stakeholders and technical teams to define and validate requirements for an enterprise data warehouse. Responsibilities include data modelling, documentation, and ensuring data structures support business goals. Essential skills include expertise in data warehouse principles, strong SQL capabilities, and experience in Agile methodologies. The successful candidate will have excellent communication skills and a robust understanding of cloud-based data platforms.
Job description
Lead Data Business Analyst (Data Warehouse & Data Modelling) Our London based client are currently looking for a Lead Data Business Analyst to act as the bridge between business stakeholders and technical data teams to define, document, and validate requirements for their enterprise data warehouse. The Data Business Analyst will ensure that data models and warehouse structures accurately support business reporting, analytics, and strategic decision-making. The successful Data BA will be required to visit the clients central London office twice a week. Key Responsibilities
- Elicit, analyse, and translate business requirements into detailed data requirements, including source-to-target mappings and logical, conceptual, and physical data models.
- Collaborate with data architects and data engineers to design and enhance dimensional data models, including fact and dimension tables using star and snowflake schemas.
- Produce and maintain data warehouse documentation, including entity relationship diagrams (ERDs), data dictionaries, business glossaries, and metadata.
- Analyse source systems to understand data structures, assess data quality, evaluate data lineage, and perform impact analysis for proposed changes.
- Validate data models, ETL/ELT pipelines, and warehouse structures against business requirements through testing and User Acceptance Testing (UAT).
- Partner with business stakeholders, BI developers, data engineers, project managers, and product owners to prioritise requirements and manage the delivery backlog.
- Identify opportunities to improve existing data models, resolve data inconsistencies, and recommend best practices for data governance and modelling.
- Support the definition of business rules, data standards, and reporting requirements to ensure consistent use of enterprise data.
Skills & Experience Essential
- Strong understanding of data warehousing principles, including:
- Dimensional modelling
- Star and snowflake schemas
- Normalisation and denormalisation
- Extensive experience in data modelling using industry-standard modelling 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 with the ability to engage both business and technical audiences.
- 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.
Preferred Background
- Demonstrated experience delivering enterprise data warehouse or analytics platform projects.
- Ability to communicate complex technical concepts in business-friendly language and facilitate collaboration across cross-functional teams.
Job details
- Published
- July 9, 2026
- Job source
- jworkable
- Workplace
- On-site · London, GB
- First seen
- July 9, 2026
See how well you match this job
Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.
Sign up to see your matchAlready have an account? Log inMore at Station
Similar jobs from this company
None listed.
Across the market
Similar jobs from other companies
- Data Business AnalystStationLondon, GBOn-site
- Data Business AnalystEpworthRichmond, AUOn-site$15,900 per year
- Data Business AnalystSoftware MindWarsaw, PLRemote
- Data Business AnalystPwC Technology Consulting Services PCAthensOn-site
- Data Business AnalystDXC Technology India Pvt LtdBangalore, INOn-site
- Data Business AnalystDIAC SAParisOn-site
Third-party content disclaimer
Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.
LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.
LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.
If you prefer, you may apply directly via the original listing for transparency.