Data Transformation Business Analyst

Nigel Franks International; United Kingdom; Hybrid; GBP 60,000 - 90,000; Full time

Job summary

A leading company in the UK seeks a Senior Business Analyst to merge strategic data architecture with operational analytics. The role requires extensive database expertise and an ability to lead data model refinement projects, providing significant contributions to the enterprise data strategy.

Benefits

Flexible working arrangements

Opportunity to work on cutting-edge projects

Direct impact on enterprise data strategy

Qualifications

• 8-12 years of Business Analysis experience with focus on database/data systems.
• Expertise in relational database design and data modelling principles.
• Experience with data transformation tools and ETL processes.

Responsibilities

• Lead impact assessments of data model structure changes.
• Analyze dependencies and conduct detailed data mapping.
• Gather and analyze requirements from the Data & Analytics team.

Skills

Database Design

Data Modelling

SQL Query Writing

Data Analysis

Stakeholder Management

Risk Assessment

Tools

SQL Server

Oracle

MySQL

PostgreSQL

Snowflake

ServiceNow

Job description

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