At a Glance
- Tasks: Join us to support a major data transformation and enhance our insurance services.
- Company: Tesco Insurance Money Services is reshaping its organization for better data capabilities.
- Benefits: Gain hands-on experience with cutting-edge tools like Microsoft Fabric and Power BI.
- Why this job: Be part of a dynamic team driving impactful change in financial services.
- Qualifications: Strong background in data analysis, ETL design, and stakeholder management required.
- Other info: Opportunity to work on exciting projects and collaborate with diverse teams.
The predicted salary is between 36000 - 60000 £ per year.
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.
-
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 lifecycle, 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).
Technical Business Data Analyst - ETL and Replatforming employer: AMS LTD
Contact Detail:
AMS LTD Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Technical Business Data Analyst - ETL and Replatforming
✨Tip Number 1
Familiarize yourself with the specific tools and technologies mentioned in the job description, such as Microsoft Fabric and Power BI. Having hands-on experience or even a solid understanding of these platforms will give you an edge during discussions with our team.
✨Tip Number 2
Brush up on your ETL pipeline design skills and be prepared to discuss your previous experiences in optimizing data flows. We value candidates who can demonstrate their ability to enhance data capabilities effectively.
✨Tip Number 3
Showcase your stakeholder management skills by preparing examples of how you've successfully collaborated with both business and technical teams in the past. This will highlight your ability to bridge gaps and ensure successful project implementations.
✨Tip Number 4
Be ready to discuss your approach to quality assurance and testing processes. Understanding how to maintain high standards during data migration and deployment is crucial for this role, so having relevant examples will strengthen your application.
We think you need these skills to ace Technical Business Data Analyst - ETL and Replatforming
Some tips for your application 🫡
Understand the Role: Take the time to thoroughly read the job description for the Technical Business/Data Analyst position. Understand the key responsibilities, required skills, and the technologies mentioned, such as ETL pipelines, Microsoft Fabric, and Power BI.
Tailor Your CV: Customize your CV to highlight relevant experience in data analysis, ETL pipeline design, and any work with financial services or insurance. Make sure to include specific examples of past projects that align with the responsibilities outlined in the job description.
Craft a Compelling Cover Letter: Write a cover letter that connects your background and skills to the requirements of the role. Emphasize your experience with data migration, stakeholder management, and any familiarity with tools like Confluence, SharePoint, and Jira.
Showcase Your Technical Skills: In your application, clearly demonstrate your technical skills related to data integration, reporting, and analysis. Mention any hands-on experience you have with Power BI and data modelling, as these are crucial for the role.
How to prepare for a job interview at AMS LTD
✨Showcase Your ETL Expertise
Be prepared to discuss your experience with ETL pipeline design and data integration. Highlight specific projects where you successfully developed and optimized ETL processes, ensuring smooth data flow and transformation.
✨Demonstrate Business Analysis Skills
Illustrate your ability to gather and translate business requirements into functional specifications. Use examples from previous roles to show how you've bridged the gap between business needs and technical solutions.
✨Prepare for Technical Questions
Expect questions related to data analysis, data modeling, and system transformations. Brush up on your knowledge of Microsoft Fabric and Power BI, as well as your familiarity with deployment processes and quality assurance methodologies.
✨Highlight Stakeholder Management Experience
Communicate your strong stakeholder management and communication skills. Share instances where you influenced business and technical teams to ensure successful implementation of data solutions.