Technical Business Data Analyst - ETL and Replatforming

We are AMS. We are a global total workforce solutions firm; we enable organisations to thrive in an age of constant change by building, re-shaping, and optimising workforces. Our Contingent Workforce Solutions (CWS) service partner with Tesco IMS to support contingent recruitment hiring.

On behalf of Tesco IMS, AMS are now looking for x2 Technical Business/Data Analysts for initial 6-month contracts based in the Edinburgh office on a hybrid working model (initially 2 days/week in office).

Tesco IMS deal in the personal - from pet insurance for your best friend, and home insurance for peace of mind, to motor insurance for your dream car or travel money for that trip you've worked hard for. And that means they always work with heart. Whether they're helping their customers or looking after their people, you'll find there's a warmth and friendliness to everything they do.

Key Responsibilities:

Tesco Insurance Money Services (IMS) is undergoing a major transformation programme to reshape its organisation. As part of this initiative, they are seeking two Technical Business/Data Analysts to support the data programme, focusing on re-platforming data capabilities and divesting from the existing banking estate while maintaining and enhancing insurance and money services data functionality.

You will:

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

Skills and Qualifications:

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

Why Tesco Insurance and Money Services?

Seeing your impact all around you: there's no better feeling.

Lucky for us, we get to feel it all the time. Because whatever our role, we're helping our colleagues and serving our customers, communities and planet a little better every day.

We deal in the personal - from pet insurance for your best friend, and home insurance for peace of mind, to motor insurance for your dream car or travel money for that trip you've worked hard for.

Everything we do is about making things better. Not just for others, but for you too. It's why you'll get bags of choice and plenty of development. It's why you'll always be heard and find balance that works for you. It's why you'll feel totally at home in a place where everyone's welcome.

Next steps:

If you are interested in applying for this position and meet the criteria outlined above, please click the link to apply and we will contact you with an update in due course.

Our client will only accept workers operating via an Umbrella or PAYE engagement model.

Please note that for the duration of this assignment you will be working as an external resource engaged by AMS.