Data Transformation Analyst

Location: Home based

Salary: £42,000 per annum plus benefits

Schedule: Monday–Friday, 37.5 hours per week

Ready to impact a better future?

As a Data Transformation Analyst in our Asylum Accommodation and Support Contract (AASC) team, you’ll help strengthen our data quality, analytics capability and overall data governance maturity. You’ll use your technical expertise to bring dashboards, reports and processes to life, helping colleagues make better decisions and improving the accuracy and reliability of data that supports essential public services.

This is meaningful work that contributes to safer, more reliable and more efficient services for vulnerable people. You’ll play a vital role in identifying problems, improving data quality and supporting a culture of innovation across our operations—helping us create impactful solutions that support communities and enable a better future.

You’ll Be Entrusted To

What you’ll do as a Data Transformation Analyst

• Maintain the Data Quality Issue Log, ensuring new issues, updates and follow‑up information are captured according to DAMA DMBOK standard.
• Conduct follow‑up calls with issue reporters and support the DQ Manager in drafting requirements for fixes that require developer input.
• Track progress of all open and resolved data quality issues, ensuring visibility across the contract.
• Assist in building prototype dashboards to highlight and quantify data errors, initially in Excel and progressing towards Power BI.
• Create practical “What Good Looks Like” guides to support operational teams in improving data quality.
• Support outreach campaigns, gather insights and help present data quality findings to operational colleagues.
• Support on major API quality validation projects and production of subsequent monitoring tools / syntax models.

Does this sound like you?

You’ll be a great fit for this role if you have:

• Strong understanding of data structures, data design principles and analytics principles.
• Solid Power BI skills, including data modelling (schemas, relationships, filter direction), DAX and diagnosing modelling or context errors.
• Good Power Query (M) capability, with knowledge of transformations such as Unpivot, Merge/Join and Group By.
• Strong Excel skills, including building dashboards and familiarity with aggregation, string manipulation and arrays.
• Ability to manage challenging conversations, balance competing priorities and navigate change confidently.

Vetting And Checks

This role requires Baseline Personnel Security Standard (BPSS) clearance, which involves verifying your identity, employment history, nationality, and criminal record to meet government security standards. In addition, depending on the nature of the role, you may need to obtain formal Security Clearance (such as CTC or SC), which includes more detailed background checks on employment, criminal record, and financial history to ensure suitability for working in secure environments. Please note that UK residency requirements may apply for certain levels of clearance. You will also complete an Occupational Health Questionnaire so we can identify and provide any support you may need to undertake the role effectively.

Discover all you need to keep growing

We’re one of the top 1% of international employers, so you can have confidence you’ll be part of a highly supportive culture with leaders you can count on to help you achieve your goals. From mentoring and training to our focus on internal progression, we’re proud to offer clear development opportunities – and the support and tools to help you seize them.

What We Offer

• Holidays: 25 days plus bank holidays (and the option to buy up to five additional leave days each year)
• Pension: Up to 6% contributory pension scheme
• Training and development: Over 1,100 internal courses available, funding for qualifications and apprenticeships, mentoring opportunities, and a focus on internal progression
• Health and wellbeing: Employee Assistance Programme, Bupa Anytime HealthLine, wellbeing app, 30% off at Serco‑managed leisure centres and 24/7 access to a virtual GP service
• Discounts: Discounts across around 1,000 retailers, from food and clothing to days out, entertainment and travel
• Charity: Paid volunteering day, tax‑free charitable giving through Payroll Giving Scheme, donate your pennies from your monthly pay to the Serco People Fund Charity
• Employee networks: Our networks support inclusion and connection by providing spaces for collaboration, learning and belonging, representing groups such as LGBTQIA+ colleagues, parents and carers, disabled colleagues, veterans and culturally diverse communities

Let’s impact a better future, together. Apply today.

#aasccareers

About Serco

At Serco, not only is the nature of the work we do important, everyone has an important role to play, from caring for vulnerable people to managing complex public services. We are a team of 50,000 people responsible for delivering essential public services around the world in areas including defence, transport, justice, immigration, healthcare and citizen services. We are innovators, committed to redesigning and improving public services for the benefit of everyone.

By joining Serco you will have unlimited access to our Global Employee Networks – SercoInspire (Gender), SercoEmbrace (Multicultural), SercoUnlimited (Disability) and In@Serco (LGBT & Networks). Serco Employee Networks, led by colleagues who are passionate about diversity, inclusion and belonging.

Apply

Please click on the apply button to complete your application. Occasionally we receive a large volume of applications for our roles and when that happens we sometimes bring the closing date forward, so please apply promptly to avoid disappointment.

At Serco, we see people first and foremost for their performance and potential. We are committed to building a diverse and inclusive organisation that supports the needs of all. As such we will make reasonable adjustments at interview through to employment for our candidates and strongly encourage applications from a diverse candidate pool. We are open to discussions around flexibility and flexible working. We operate a hybrid work structure in many of our business areas. We are proudly Disability Confident Leader employers and holder of the Gold Inclusive Employer Standard. Disabled applicants who meet the minimum criteria for the job will be given the opportunity to demonstrate their abilities at an interview. For help with your application please contact 0345 010 4000.

At Serco we support fair access to employment for those with unspent criminal convictions through the ‘Ban the Box’ pledge (some may be exempt due to the nature of the role and the security clearance required). Please contact our recruitment team directly on 0345 010 4000 to discuss.