DATA INTEGRATION BUSINESS ANALYST

Company Description

Matrixx Solutions, based in Edinburgh, Scotland, is a consulting company specialising in M&A transitions and Operational Excellence. With a solution-oriented approach, the company focuses on collaborative partnerships and tailored solutions that support sustainable business transformation.

Learn more about our services and expertise at www.matrixxsolutions.com.

Role Description

We are seeking an experienced UK based Data Integration Business Analyst to support one of Matrixx Solutions' key clients with data integration, remediation and project delivery activity. The initial focus will be on analysing Salesforce fallout, exception and error data arising from integration activity, identifying data quality and process issues, and helping the business drive those issues through to resolution.

Salesforce is the immediate platform focus, but the role is intentionally broader. Over time, the successful candidate may work across other business systems, datasets and integration or change initiatives as client priorities evolve.

This is a hands-on analytical role with a strong delivery component. The successful candidate will be comfortable moving between detailed data investigation and broader workstream coordination: analysing data themselves, engaging business and technical stakeholders, maintaining momentum on actions and dependencies, and taking ownership of defined packages of work through to completion.

The role is therefore well suited to an experienced analyst who already has project or workstream delivery experience and is capable of taking on increasing project management responsibility as the programme develops.

Key Responsibilities

Data Integration, Analysis & Remediation

• Analyse Salesforce fallout, exception and error data to identify data quality issues, process failures, system discrepancies, root causes and associated business impacts.
• Extract, manipulate, cleanse and validate large datasets from Salesforce and other business systems to support investigation, reconciliation, assurance and decision-making.
• Perform detailed analysis using advanced Excel functionality, including Pivot Tables, XLOOKUP, VLOOKUP, INDEX/MATCH, conditional formatting, complex formulas and structured data comparison techniques.
• Carry out data reconciliation and comparison activities to identify discrepancies between source systems, target systems and reporting outputs.
• Work with business and technical SMEs to validate findings, understand root causes, define corrective actions and support resolution of identified issues.
• Support User Acceptance Testing (UAT), including preparation or analysis of test data, review of test outputs, identification of defects and exceptions, and tracking of data-related issues through to closure.
• Produce clear management information, dashboards and ad hoc reporting, using Power BI or other reporting tools where appropriate.
• Where appropriate, use or support deeper analysis through SQL queries, Python or other data analysis and automation tools

Project and Workstream Delivery

• Take ownership of defined data integration, remediation, testing or improvement workstreams from investigation through to agreed resolution and closure.
• Develop and maintain proportionate work plans, actions, risks, issues, dependencies and milestones for assigned activities.
• Coordinate stakeholders and SMEs to ensure actions progress, dependencies are understood and delivery commitments are met.
• Monitor progress, identify emerging delivery risks or blockers and escalate issues appropriately to project or programme leadership.
• Support project governance and PMO activities where required, including status reporting, action tracking, meeting preparation and follow-up.
• Contribute to broader project management activity and, where appropriate, lead smaller projects or work packages as experience and programme needs develop.

Stakeholder Engagement & Continuous Improvement

• Translate complex data findings into clear, practical and actionable recommendations for both technical and non-technical stakeholders.
• Build effective working relationships across business, technology, operational and project teams, including colleagues working across multiple countries and time zones.
• Identify recurring patterns, systemic issues and opportunities to improve data quality, controls, processes and ways of working.
• Support a collaborative, outcome-focused approach that combines analytical rigour with effective delivery and stakeholder management.

Essential Experience & Capabilities

• Strong experience in business data analysis, data integration, data migration, reconciliation, system remediation or a closely related field.
• Practical experience working with Salesforce data, including fallout, exception, error or data-quality reporting.
• Advanced Microsoft Excel capability, including Pivot Tables, lookups, formulas, conditional formatting and structured comparison of large datasets.
• Ability to extract, manipulate, cleanse, validate and reconcile data from multiple systems and identify inconsistencies, trends, gaps and anomalies.
• Experience supporting system integration, business change, UAT, migration or operational improvement activity.
• Demonstrable experience of owning actions, work packages or workstreams and driving activity through to completion.
• Good understanding of project delivery disciplines, including planning, risks, issues, dependencies, actions, milestones and stakeholder reporting.
• Strong written and verbal communication skills, with the ability to explain analytical findings clearly and influence stakeholders to act on them.
• Strong attention to detail combined with the ability to understand wider business impact and delivery priorities.
• Ability to work independently in a remote environment while collaborating effectively with global teams and stakeholders.

Desirable Skills & Experience

• Experience using Power BI to develop dashboards, reports and visualisations.
• Practical experience of SQL for data querying and investigation.
• Practical experience of Python for data analysis, reconciliation or automation.
• Experience working on post-acquisition integration, system consolidation or other complex business transformation programmes.
• Experience leading small projects, project workstreams or cross-functional delivery teams.
• Understanding of formal PMO or project governance processes.
• Experience of root cause analysis, continuous improvement, process improvement or assurance activity.
• Previous experience in a consulting, technology or large corporate environment.

Qualifications & Certifications

A degree, professional qualification or equivalent relevant experience in business analysis, data analytics, information systems, project management or a related discipline would be expected.

Relevant certifications are advantageous rather than mandatory, and may include:

• Business Analysis certification such as BCS, IIBA ECBA/CCBA/CBAP or similar.
• Salesforce Administrator or Salesforce reporting/data-related certification.
• Microsoft Power BI certification such as PL-300, or demonstrable advanced Power BI capability.
• Microsoft Excel, SQL, database querying or Python/data-analysis certification.
• Project management certification such as PRINCE2, APM, PMP or equivalent.
• ISTQB Foundation or other testing/UAT-related certification.
• Lean Six Sigma Yellow Belt or Green Belt, particularly where the role supports process improvement or root cause analysis.

Candidate Profile

The strongest candidate will combine hands-on analytical capability with delivery ownership.

They will be willing and able to get into the detail of the data, but will also have the confidence to coordinate stakeholders, manage a workstream, maintain momentum and communicate clearly with project and programme leadership.

The role offers scope to develop into broader project management responsibility as the client programme and future assignments evolve.

Salary/ Remuneration

Indicative salary range: £45,000-£55,000 per annum, depending on experience.

Candidates who combine strong Salesforce and data-integration experience with advanced analytical capability and proven project/workstream delivery experience would typically be considered toward the upper end of the range.

The role is offered as a 12-month fixed-term employee contract, with the potential to extend beyond the initial term. Standard company benefits include pension provision, holiday entitlement and sickness benefits.