Data Analyst

Keystone Property Finance Limited; West Malling; On-site; GBP 30,000 - 45,000; Full time

Job summary

A leading company in the UK mortgage market is seeking a Data Analyst to join their growing data analytics team. The candidate should have a strong numerical and analytical background, with skills in SQL and Python, and a proactive approach to problem-solving. The role involves data querying, cleansing, and preparation of analytical reports to support various teams within the company.

Qualifications

• Experience using SQL and Python is beneficial.
• Strong academic background preferred.
• Self-motivated and solution-oriented mindset.

Responsibilities

• Query and clean data using SQL and Excel.
• Prepare visual reports based on data analysis.
• Support data requirements across teams.

Skills

SQL

Python

Microsoft Excel

Analytical Thinking

Problem Solving

Education

Degree in a STEM subject

Job description

Keystone Property Finance is an established Buy-to-Let Lender with a strong brand identity and over 25 years’ experience in the UK mortgage market.

Keystone Property Finance are looking for a highly motivated individual with a numerical and analytical background to join our expanding data analytics team.

The ideal candidate will be proactive, keen to learn new skills, have an interest in coding, a self-motivated problem solver, analytically thinking, efficient, with strong inter-personal skills and a can-do attitude who is committed to meeting deadlines whilst producing high quality work.

Key Responsibilities

• Query data from the company database using Microsoft SQL Server Management studio.
• Clean data to remove any erroneous data points that could potentially impact the conclusions drawn from the data set.
• Perform initial analysis to assess the quality of data.
• Organise the data into a format that is readable and understandable for other teams within the company, using tools to visualise the data if required.
• Prepare reports based on analysis.
• Use an analytical mindset to carry out tasks which may not involve data analysis in other areas of the company when required.
• Assist and support the team with data requirements.
• Use coding language skills to collate and manipulate data i.e. Python.

KEY SKILLS/COMPETENCIES

Skills and Experience

• Experience using SQL.
• Strong academic background, ideally, educated to degree level in a STEM subject.
• Strong Microsoft Excel experience with the ability to organise and clean data using skills such as functions and pivot tables.
• Self-educating, curious and pragmatic, solution-oriented mind-set.
• Experience in a previous data analyst role and in Python would be beneficial.

Co-Operation and Teamwork

• Participates as a team member, creating effective and professional working relationships with colleagues across multiple teams.
• Co-operates openly and honestly with colleagues and participates in team activities, sharing experiences and ideas.
• Assists other team members when necessary.

Communication

• Communicates facts and concepts so they can be easily interpreted and understood by others
• Balances amount and level of information, conveys key issues in appropriate order to give an overall picture.
• Communicates in plain English, speaking clearly and fluently and using correct grammar in all written work.
• Listens to instructions and passes on information as directed.

Planning Own Work

• Has the ability to manage their workload accordingly and to prioritise projects in order of urgency.
• Strong attention to detail and accuracy

Keystone’s Values

Our Values help define who we are as Keystone Property Finance. They come from the beliefs we hold, the way we behave and how we want to work together for our customers.

• Respect
• Integrity
• Resilience
• Excellence

Our Values are unique to our brand, they give us purpose and focus. They are vital in helping us all ‘do the right thing’. If we are confident that we are true to our values, then we can be sure that we are doing the best for our customers.