LiftmyCVLiftmyCV
ST

Data Business Analyst

StationOn-siteLondon, GB
AI job summary

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
AI match explained

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 in

More at Station

Similar jobs from this company

None listed.

Across the market

Similar jobs from other companies

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.