Technical Business Analyst - Data at Connells Limited, Milton Keynes, 6 Months, £Contract Rate

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.

** Please note that we are unfortunately unable to provide visa sponsorship for this position. Applicants must have the right to work in the UK.

Connells Group UK is an equal opportunities employer and positively encourages applications from suitably qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, transgender status, religion or belief, marital status, or pregnancy and maternity.