Data Analyst

We are seeking an enthusiastic Data Analyst to join our ever-growing IT Applications team!  

You will be part of the Data and Reporting team, helping to set and drive standards for data analysis in IT Applications. This is predominantly a project-focused role, and you will be performing analysis to support Data Engineering activities, so experience supporting data migration and working with complex data models is essential. 

This role offers a hybrid of office and home working (the option to work part of your week from home becomes available after completion of an initial training period). You will need to be located within a commutable distance from our Claverton Down, Bath office as being able to work collaboratively with our business stakeholders and project teams is key to this role

What you'll do 

• Provide clear documentation to support the development of databases/stores, data migration processes, and integration processes.
• Understand complex data structures and processes, identify potential issues, and recommend resolution.
• Help expand and evolve our cloud data storage and analytics platform.
• Responsible for the specification and documentation of data migrations and integrations.
• Lead in data mapping activities between incumbent and new systems.
• Provide gap analysis.
• Work with the data architect to interpret data models to produce data mapping for development purposes.
• Work alongside DBAs, BAs, Data Developers, and the Program team to support the efficient migration of data throughout the lifecycle of the project.
• Document all work by the agreed format and standards for subsequent review and sign-off.
• Identify risks and issues with suggested mitigating actions.
• Ensure that solution design and approach adhere to company security standards.

What you'll need 

• The ability to analyse, model, and interpret data.
• Experience working with large data sets and relational databases.
• Experience working on large/complex programmes involving multiple data migrations and integrations.
• Good communication skills.
• Good team skills working in collaboration at a highly technical level with colleagues, IT partners, and IT consultants.

Technical skills

• RDBMS used: Microsoft SQL Server 2016 and above.
• Transact-SQL: Complex queries, stored procedures, views and functions.
• Development Tools: Visual Studio.
• Source Control Azure Dev Ops and Team Foundation Server (legacy).
• Cloud: Azure SQL PaaS, Data Factories, Synapse, Stream Analytics, Data Explorer and Fabric.
• Languages: T-SQL (some exposure to Python and/or R would be advantageous).
• Microsoft Office.
• Experience with Microsoft Dynamics 365 Customer Experience and Finance Products is  preferable. 

What you'll receive

• A combined pension contribution of up to 20%.
• Career progression and professional development opportunities.
• 25 days' holiday rising to 28 with length of service.
• The opportunity to buy up to ten days' holiday and sell up to five every year.
• A healthcare package that allows you to claim back healthcare costs.
• Life assurance of up to eight times your salary.
• A new electric car in exchange for part of your gross salary, subject to conditions.
• Cashback and discounts from more than 3,000 retailers.
• One paid volunteering day each year.
• Enhanced family leave and pay arrangements.
• An interactive health and wellbeing platform.
• Support from mental health first aiders.
• A £1,000 referral fee if you recommend someone to work for us.

Who we are

YTL UK is part of the international YTL Group based in Kuala Lumpur. The UK companies include:

• Wessex Water – one of the top-performing water and sewerage companies in England and Wales, serving 2.9 million people across the South West.
• YTL Developments – a major UK developer currently redeveloping a 350 acre former airfield into an award winning, exciting mix of houses, apartments, schools, commercial space, restaurants and hotels, to make a truly sustainable new community.
• YTL Construction UK – a top 20 UK contractor providing fully integrated services to infrastructure, residential, commercial, industry, energy and environmental sectors.
• YTL Arena – the development and operation of an entertainment complex that includes a 19,000 capacity arena, conferencing and exhibition space.
• Plus a number of other retail, environmental and specialist businesses.

Our people tell us that YTL UK is a great place to work, which is why so many of them stay with us! You will have a unique opportunity to develop and progress your career within such a diverse group.

We are passionate about diversity and inclusion – with that in mind, all applicants are welcome. We are delighted to have signed the Armed Forces Covenant and are a Disability Confident Employer.  

If you require reasonable adjustments to be made during the recruitment process, please inform a member of our Recruitment team.