
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