Retail Finance Benchmarking - Database Analyst

Who we are:

At CACI we do amazing things with data. We are experts in all things consumer and location, bringing together cutting-edge analytical techniques, creative thinking, and diverse perspectives to drive growth for our clients. We build some of the most highly regarded, innovative datasets in the market and our people are the best at manipulating that data to provide insight to our clients. As part of the wider Consumer & Market Intelligence division, you will be joining a 275-strong team working in over 50 markets globally.

 

Our people are what really make us different. We are a growing and dynamic group of analysts, data scientists and commercially savvy business development consultants who also provide thought leadership and creative thinking. We are passionate, progressive, and unafraid of challenge; our mission is to use data-driven insight to make a commercial difference.

 

CACI’s Retail Finance Benchmarking Group maintains a number of member-subscribed, data pooling services for a large proportion of the UK’s banks, building societies and fintech retail finance providers. Each member provides data on a regular, periodic basis. CACI processes and aggregates this data and publishes the output for each member to a secure portal, comprising a series of views of the member’s performance, and of a pooled, anonymised rest of market.

 

The services enable members to:

• Form an objective view of their performance
• Take more informed decisions around product, channel, acquisition, and retention
• Ascertain market reactions to those decisions
• Identify shifts in market sentiment

 

Here are some of the specific challenges we help our clients solve:

 

• Which demographic groups have the greatest change in behaviour for my products?
• How has my market share changed over the last 12 months, and how does that differ between types of products, or region?
• Where are there opportunities for our business to launch new products?
• How many of my customers are due to mature in the next 12 months and how does that compare with our competitors?
• How has a recent market event impacted the market for our products?

How does our market share vary in places where we have a branch, and why?

What you’ll be doing:

 

Reporting to the Data Processing Manager, the database analyst will be responsible for reviewing, managing, and publishing our weekly and monthly data cycles. Key responsibilities will include:

 

• Managing the collection and processing of our client’s data files in a timely manner.
• Regularly verifying the quality of our client’s data to ensure accuracy. This requires highlighting irregularities, analysing trends, and seeking context behind interesting data observations.
• Interrogating and supporting both our terabyte-scale SQL (T-SQL) server back-end and our Tableau/Liferay front-end.
• Guaranteeing client confidentiality is always protected.

• Ensuring the wider team has visibility during the collection, processing, and publication stages of a data cycle. This involves updating our processing logs, and effectively communicating cycle affairs via Microsoft Teams.
• Working closely with our clients to resolve outstanding data issues, escalate service publication delays, and improve standards of data delivery over the long term.  
• Collaborating with senior stakeholders on projects to enhance the quality of our data checking processes with the aim of improving accuracy.

 

Due to the sensitivity of the client data, the candidate will be expected to have a keen eye for detail and follow our checking procedures to ensure the accuracy of the services we deliver to our clients.

The role is a critical part of the overall objective of the team, to ensure that UK retail finance providers can take informed decisions based on prompt, consistent, and accurate data. 

 

Who you are:

Core Skills:

• Analytically and numerically minded – applies attention to detail by being able to spot anomalies and patterns in the data.
• Possesses strong verbal and written communication skills.
• Problem solver, who is keen to find the root cause of a data issue and is proactive in finding a solution.
• Team player with a growth mindset, who enjoys working in a collaborative environment.
• Highly personable and able to develop strong working relationships with our clients.
• Experience in using data visualisation tools such as Tableau, Qlikview or Power BI advantageous but not essential.
• Retail Finance experience preferable but not essential.

 

Technical Skills

• Experience in (or willingness to learn) writing and understanding SQL queries for data analysis, manipulation, and processing.
• Well-developed skills with Microsoft Office products, particularly Microsoft Excel.
• Previous exposure to relational databases, data warehouse architecture and standard design concepts are a bonus.
• Desire to learn Python, but this is not essential.

Candidates possessing the above technical skills are preferred but this is not essential as training will be provided.

What we can offer you:

We don’t settle for people that can just do the job, we look for people that are constantly trying to push the boundaries and improve what we do. This is what makes CACI a great team to be a part of.

Innovation is hugely important to us, and we guarantee everybody in the business gets to spend 5% of their time innovating and training. If you are an innovative thinker and like to challenge the norm, coming up with new ways of doing things, then you will be surrounded by likeminded people at CACI.

The Retail Finance Benchmarking team’s goal is to be the primary source of market insight in our field, providing top quality insights and using cutting edge innovative analytical techniques for the UK’s biggest financial services brands. As a key member of our team, you will play a highly influential role in driving us to achieve this goal.

Progression:

We understand that your career progression is important to you.  At CACI people get promoted on merit when they are ready. This means that your career is completely in your own hands and there is never a ceiling for your progress.

Everyone’s career path is different. We welcome people exploring different areas and trying out new skillsets. Just because you start off down one path doesn’t mean you are committed to it indefinitely. At CACI you have the freedom to carve your own career path.

Flexibility:

The key to our success is our teamwork and collaboration and that tends to work best when we are all in the office working together. While our office is open and available all week, the position involves being in the office with the team for 2 or 3 days per week and working from home outside of these times.

Development:

Your development is key and is a top priority for the team. We offer 3 types of training: externally run consulting courses, externally run bespoke courses and internal courses. Everyone has different training requirements which means everyone has their own training plan. A bespoke training plan will be created for you when you join.

Benefits:

We have a range of benefits on offer to support you. We have a comprehensive list of schemes ranging from pension plans to health and wellness policies, in addition you can opt into a selection of flexible benefits to meet your personal needs.

• Competitive salary
• Bonus scheme
• Pension contributions up to 5% (matched by employee and employer)
• Private Health Insurance from 2nd anniversary
• Sickness & Disability income protection from 3rd anniversary
• On site gym membership