Technical Business Data Analyst - ETL and Replatforming

Technical Business Data Analyst - ETL and Replatforming

Posted 2 weeks ago by Alexander Mann Solutions on JobServe

Negotiable
Inside
Hybrid
Edinburgh, Scotland, UK

Summary: The role of Technical Business/Data Analyst involves supporting Tesco Insurance Money Services in a significant transformation program focused on enhancing data capabilities and migrating from legacy systems. The position requires collaboration with various stakeholders to ensure successful implementation of data solutions while maintaining high-quality standards. The role is based in Edinburgh and operates on a hybrid working model. Candidates will engage in data analysis, ETL pipeline development, and user acceptance testing as part of their responsibilities.

Key Responsibilities:

  • Support the creation of a new data platform, ensuring seamless migration and provisioning of data from Legacy systems.
  • Gather and translate business requirements into functional specifications, supporting solution design and bridging the gap between business and technology.
  • Develop and optimise ETL pipelines, ensuring smooth data flow and transformation.
  • Conduct testing, create test cases, and uphold quality standards in the data migration and deployment process.
  • Perform detailed data analysis, data modelling, and data integration to support system transformations.
  • Support user acceptance testing (UAT) and ensure alignment with business objectives.
  • Collaborate with stakeholders across business and technical teams to ensure successful implementation of data solutions.
  • Document processes, workflows, and data-related decisions using Confluence, SharePoint, and Jira.
  • Work with Microsoft Fabric and Power BI for data integration and reporting.

Key Skills:

  • Strong experience in data analysis and business analysis within financial services or insurance.
  • Expertise in ETL pipeline design, data modelling, and data integration (APIs, SFTP).
  • Experience in software delivery life cycle, systems implementations, and data warehouse solutions.
  • Hands-on experience with data reporting and dashboard development using Power BI.
  • Ability to analyse data transformations and ensure accuracy in data exchange processes.
  • Familiarity with deployment processes and quality assurance methodologies (though not a DevOps role).
  • Strong stakeholder management and communication skills, with the ability to influence business and technical teams.
  • Proficiency in Confluence, SharePoint, Jira, and Visio.
  • Experience with Microsoft Fabric (highly desirable).

Salary (Rate): undetermined

City: Edinburgh

Country: UK

Working Arrangements: hybrid

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: IT