Hybrid Business Analyst – Data Analysis

at Expleo Group

• Job title: Business Analyst – Data Analysis
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: ETL, SQL
• Location requirements: Hybrid, Derby, United Kingdom

About the role

• Business Analyst leading data migration activities from a legacy Order Management System. Collaborating with stakeholders to ensure data accuracy and project success.

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.

Requirements

• 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.
• 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 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 benefits
• Enhanced maternity and paternity, adoption and shared parental leave package
• Flexible, blended working model