Business Analyst - Data Analysis

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.

• 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.

• 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.

• 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

• Collaborative working environment – we stand shoulder to shoulder with our clients and our 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!   
• Always working as one team, our people are not afraid to think big and challenge the status quo 

• As a Disability Confident Committed Employer we have committed to:
  • Ensure our recruitment process is inclusive and accessible
  • Communicating and promoting vacancies
  • Offering an interview to disabled people who meet the minimum criteria for the job
  • Anticipating and providing reasonable adjustments as required
  • Supporting any existing employee who acquires a disability or long term health condition, enabling them to stay in work at least one activity that will make a difference for disabled people
    

“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”. 

We treat everyone fairly and equitably across the organisation, including providing any additional support and adjustments needed for everyone to thrive