You will be given a breadth of opportunities to impact a key contract within the business and with the fact Capita is a 63,000 strong workforce business, there are always opportunities to progress in a wider team.

This role will be fully home based with flexible hours so you can work around a schedule to suit you!

What you will do:

• understanding data across the business and recommend changes in order to continuously improve process and systems
• driving changes in delivery and consumption of data across the account.
• maintaining and Improving the Datawarehouse.
• creating, maintaining and simplifying existing ETL processes.
• working to agreed Standards and Practice, including adhering to the development framework.
• identify customer reporting requirements, agree realistic timescales and communicate updates to meet their expectation.
• maintaining high standards of data quality and integrity within the BI Reporting Datawarehouse.

Your experience will include:

• Strong Working knowledge of Power BI & Office 365 suite of tools inc. Planner, Power Automate, etc.
• Expert in the use of SQL and some Azure SQL – Experience of SSMS/SSRS
• Proficient in SSIS
• Proficient in all aspects of Excel & Access functionality.
• Good Knowledge of database designs and understanding relational database concepts.  Familiarity of Kimball methodology a plus.
• Strong knowledge of developing measurement systems & Reports. Operational Dashboards with drill down from Top to Bottom of organisations. Must have good experience of rolling out these dashboards across a business to drive operational change.

About Capita Regulated Services

At Regulated Services, we’re transforming the world of life and pensions, and mortgage services. We’re delivering responsible and sustainable services, helping our clients to respond to changing market factors and adapt to the needs of their customers both now and in the future. Our teams work with clients across the UK and Worldwide, offering a range of services from end-to-end administration, digital technology and business support to lending, account and arrears management. Join us and discover better as you shape the future of regulated services. 

 What’s in it for you?

• A competitive basic salary.
• 23 days holiday (rising to 27) with the opportunity to buy extra leave 
• The opportunity to take a paid day out of the office, volunteering for our charity partners or a cause of your choice
• Company matched pension, life assurance, a cycle2work scheme, 15 weeks’ fully paid maternity, adoption and shared parental leave, paternity pay of two weeks…and plenty more  
• Voluntary benefits designed to suit your lifestyle – from discounts on retail and socialising, to health & wellbeing, travel and technology.
• Access to our Employee Network Groups, which represent every strand of diversity and allow colleagues to connect and learn from each other on an open, inclusive platform

You’ll get the chance to follow your chosen career path anywhere in Capita. You’ll be joining a network of 63,000 experienced, innovative and dedicated individuals across multiple disciplines and sectors. There are countless opportunities to learn new skills and develop in your career, and we’ll provide the support you need to do just that. Our purpose is to create a better outcome for you.  

What we hope you will do next

Choose ‘Apply now’ to fill out our short application, so that we can find out more about you.

Applications are open and will likely close soon with interviews following straight after, so get your application in ASAP!

To view our Covid-19 and process adjustments information, please visit the Capita Careers site.

Equal Opportunities

We’re an equal opportunity employer, which means we’ll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and their passion for creating better outcomes, and we’re committed to creating an inclusive environment for all employees. During the application process, you’ll be asked to share your personal characteristics and data with us. This helps us understand our audience so we can make sure we are doing everything we can to attract a diverse range of people and ensure our recruitment processes are fair and inclusive.