Business Analyst - Data Analysis

Overview

We are seeking an experienced Business Analyst to lead data migration activities from a legacy Order Management System. This system contains critical data sets including Quotes, Orders, and Financial information, all essential to ensuring customers receive their vehicles as ordered and priced.

Responsibilities

• Stakeholder Engagement: Collaborate effectively with business stakeholders and programme teams to align migration activities with business needs.
• End-to-End Data Understanding: Analyse and interpret data across the full data lifecycle from extraction and transformation to validation and load, defining transformation rules and mapping to ensure accuracy, and completeness from source to target systems. Document data models, lineage and dependencies to support transparency and traceability.
• Data Analysis & Quality Assurance: Work with large datasets to perform detailed profiling, cleansing, and validation of large datasets to identify anomalies, gaps, and inconsistencies. Develop and execute reconciliation approaches to verify data accuracy post-migration. Produce metrics and dashboards to monitor data quality and migration progress.
• Documentation & Artefact Management: Maintain clear and comprehensive documentation of migration requirements, logic, transformation rules, and reconciliation methods.
• ETL Tools Proficiency: Utilize tools such as Excel, Access DB, and Power BI for data extraction, transformation, and loading. Support the creation of automated validation and reconciliation scripts or queries where possible.
• Collaboration Platforms: Confidently use JIRA, Confluence, SharePoint, and Teams to manage progress tracking and documentation.
• Workshop Facilitation: Lead workshops and communicate effectively with both business and technical teams to gather requirements and share insights.

Qualifications

• The ideal candidate for this role will have the BCS Business Analysis International Diploma (or equivalent), or be working towards it, extensive experience of business analysis.

Essential Skills

• Ability to engage and manage business stakeholders across departments.
• Ability to define and document data transformation and mapping rules.
• Experience working with large datasets.
• Skilled in identifying data anomalies, gaps, and inconsistencies.
• Strong understanding of data reconciliation methods.
• Proficient in creating clear and structured documentation for migration logic and requirements.
• Hands-on experience with tools such as Excel, Access DB, and Power BI for data processing and analysis.
• Familiarity with JIRA, Confluence, SharePoint, and Microsoft Teams for project tracking and documentation.

Experience

• Proven experience leading or supporting data migration initiatives, particularly involving complex legacy systems.
• Experience leading workshops and engaging with both business and technical stakeholders to gather requirements and communicate solutions.
• Extensive experience as a Business Analyst within data migration, data quality, or system transformation projects.
• Proven ability to work with large, complex datasets and draw meaningful insights to support decision-making.
• Strong understanding of data modelling, data governance, and data quality principles.
• Familiarity with SQL querying or scripting to support analysis and validation activities

Benefits

• Collaborative working environment – we stand shoulder to shoulder with our clients and ours peers through good times and challenges
• We empower all passionate technology loving professionals by allowing them to expand their skills and take part in inspiring projects
• Expleo academy - enables you to acquire and develop the right skills by delivering a suite of accredited training courses
• Competitive company benefits such as medical and dental insurance, pension, life assurance, employee wellbeing programme, sports and social events, birthday hampers and much more
• 25 days annual leave (increased to 27 after 2 years of service)Always working as one team, our people are not afraid to think big and challenge the status quo
• Access to discounts and offers through my Expleo benefitsEnhanced maternity and paternity, adoption and shared parental leave package
• Flexible, blended working model 

“We are an equal opportunities employer and welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation or age”.