Data Transformation Business Analyst

Senior Business Analyst - Data & Systems Architecture

Location: Hybrid, UK

Experience Level: 8-12 years

Contract Type: Contract

About the Role

We are seeking an experienced Senior Business Analyst with strong database and data modelling expertise to join our Change and Transformation team. This role combines strategic data architecture work with operational analytics support, requiring deep technical knowledge of database systems and data impact assessment capabilities.

You will split your time between leading critical data model refinement projects (80% of role) and supporting our Data & Analytics team with system enhancement requirements (20% of role).

Key Responsibilities

Data Model Architecture & Impact Assessment (80% - 4 days/week)

Lead comprehensive impact assessments of proposed data model structure changes across our complex systems landscape
Analyse dependencies and relationships between proprietary custom-built systems and external platforms (ServiceNow, etc.)
Conduct detailed data mapping and dependency analysis to identify downstream effects of model changes
Collaborate with technical architects to design optimal data model structures that minimise system disruption
Document and communicate impact findings to technical and business stakeholders with clear risk assessments
Develop migration strategies and implementation roadmaps for approved data model changes
Work closely with Data Architecture team to ensure proposed models align with enterprise data strategyData & Analytics Team Support (20% - 1 day/week)

Gather and analyse requirements from Data & Analytics team for internal system improvements and reporting enhancements
Translate analytical requirements into detailed technical specifications for development teams
Design and document database schema changes required for new reporting capabilities
Conduct feasibility assessments for proposed analytics and reporting solutions
Coordinate with development teams to ensure accurate implementation of data and reporting requirements
Support UAT activities for data and analytics system enhancements
Create and maintain technical documentation for all data and analytics system changesCross-functional Collaboration

Bridge the gap between data architects, developers, and business stakeholders
Facilitate technical workshops and requirements gathering sessions
Provide expertise on database design best practices and data governance
Support data quality initiatives and system optimisation projects
Contribute to enterprise data strategy and architecture decisionsEssential Requirements

Database & Technical Experience

8-12 years of Business Analysis experience with minimum 5 years focused on database/data systems
Expert knowledge of relational database design, normalisation, and data modelling principles
Hands-on experience with SQL query writing, database performance optimisation, and data analysis
Proven track record of conducting complex systems impact assessments
Experience with ETL processes, data warehousing concepts, and reporting system design
Knowledge of database platforms (SQL Server, Oracle, MySQLPostgreSQL, or similar) and ideally warehouse solutions (Snowflake)
Experience working with data transformation tools, including setting test parameters for quality.Systems Integration & Architecture

Deep understanding of enterprise system architectures and data flow dependencies
Experience with both proprietary custom-built systems and commercial platforms (ServiceNow preferred)
Strong knowledge of API integrations, data synchronisation, and system interfaces
Cloud Based architecture awareness, ideally with Azure.
Understanding of data governance, data quality, and master data management principles
Experience with data migration projects and system consolidation initiativesBusiness Analysis Skills

Advanced requirements gathering and stakeholder management capabilities
Proven ability to translate complex technical concepts for business audiences
Experience with agile methodologies and working with development teams
Strong documentation and process mapping skills, including UI wireframe creation
Risk assessment and impact analysis expertiseWhat We Offer

Opportunity to work on cutting-edge data architecture projects
Direct impact on enterprise data strategy and system architecture
Collaboration with Data Architecture and Analytics teams
Flexible working arrangementsReporting Structure

This role reports to the Director of Strategic Programs and will work closely with:

Data Architecture team
Data & Analytics team
Development teams and technical architects
Senior business stakeholders across all divisions
External system vendors and integration partners