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 strategy

Data & 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 changes

Cross-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 decisions

Essential 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 initiatives

Business 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 expertise

What 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 arrangements

Reporting 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