Job Description


We are seeking an experienced Technical Business Analyst to support a large-scale CRM data migration programme as part of Project Prometheus on a 6-month contract. The primary focus of the role is to analyse, document, and map legacy ("heritage") CRM system and associated reporting, in order to support the replication and recreation of the target-state operational and analytical reporting suite.


This role sits at the intersection of data engineering, architecture, and business delivery, and requires strong data analysis capability alongside the ability to work effectively with engineers, business SMEs, and data architects.


Key Responsibilities
Legacy System & Reporting Analysis
*Analyse and document existing heritage CRM reporting systems with a focus on data structures, business logic, and reporting outputs.
*Discover, decompose, and document legacy reporting and MI processes (including SQL-based routines, ETL processes, and SSRS reports).
*Work with DBAs and engineers to understand undocumented or complex logic embedded in legacy systems.


Data & Reporting Requirements
*Identify and catalogue existing KPIs, metrics, and reporting outputs, including calculation logic and data dependencies.
*Support definition of future-state reporting requirements, working closely with business stakeholders and the wider programme.
*Map legacy reporting outputs to target-state data models and reporting solutions (CRM-native and data-platform-derived).


Stakeholder & Delivery Support
*Act as a bridge between business SMEs, data engineers, and data architects, ensuring shared understanding and accurate translation of requirements.
*Support validation and sign-off of documented logic and requirements with business and BAT stakeholders.
*Contribute to impact analysis, dependency mapping, and delivery planning for the data migration workstream.


Essential Skills & Experience
*Proven experience as a Technical Business Analyst on data-heavy or enterprise migration programmes.
*Strong data analysis skills, including understanding of: *Relational databases and SQL
*Data models and schemas
*ETL and reporting processes

*Experience analysing legacy CRM systems and complex reporting logic.
*Strong understanding of operational and analytical reporting, including KPIs, MI, and reconciliation.
*Ability to work effectively with: *Data Engineers
*Database Administrators
Data Architects
*Business SMEs

*Excellent documentation skills, producing clear, structured, and auditable artefacts.


Desirable Experience
*Experience supporting CRM migrations or major system replacements.
Exposure to modern data platforms (e.g. Microsoft Fabric, Azure, cloud data platforms).
*Experience with SSRS or similar enterprise reporting tools.
*Familiarity with Common Data Models, master data, or "single view" concepts.
*Experience working in regulated or complex enterprise environments.


Personal Attributes


Highly analytical, detail-oriented, and methodical.
Comfortable operating in ambiguity and working with incomplete documentation.
Strong communicator, able to engage both technical and non-technical stakeholders.
Pragmatic and delivery-focused, with an understanding of trade-offs in legacy replacement programmes.


CF00825