Excel Data Analyst

Kelly; Cheltenham; On-site; GBP 30,000 - 35,000; Full time

Job summary

A growing service-based SME in Cheltenham is seeking an Excel Data Analyst to manage and interpret data effectively. The role involves creating and maintaining complex spreadsheets, performing data cleansing, and presenting insights to management. The ideal candidate will have advanced proficiency in Excel, including formulas and pivot tables, and a proven ability to analyze large datasets. This position offers a competitive salary within the range of £30,000-£35,000 and excellent benefits, including health care and parking.

Benefits

Private health care

Optical care

Dental care

Free parking

Qualifications

• Proven analytical experience with complex data spreadsheets.
• Advanced knowledge of IF formulas, pivot tables, and VLOOKUP in Excel.

Responsibilities

• Collect and interpret data from various sources.
• Create and maintain complex Excel spreadsheets.
• Help develop and automate Excel-based reporting tools.
• Perform data cleansing and validation for accuracy.
• Analyse trends and patterns in datasets.
• Present findings and recommendations to senior management.

Skills

Advanced proficiency in Microsoft Excel

Data analysis

Data cleansing

Effective communication

Job description

Excel Data Analyst

Cheltenham

£30,000-£35,000

Permanent

Working in a growing service-based SME in Cheltenham. An opportunity to take on a newly created Excel Data Analyst position. In a relatively short space of time, our client has grown its turnover to c.£5m. They operate in an interesting sector and are led by a management team of real pedigree.

The office is based in the heart of town and offer free parking along with some excellent benefits such as private health, optical and dental care.

Key responsibilities for the role include:

• Collect and interpret data from various sources such as SAGE 50 for example – ensuring data integrity and accuracy.
• Create and maintain complex Excel spreadsheets, including IF formulas, pivot tables, charts and to analyse data and generate reports.
• Help with the development and automation of Excel- based reporting tools and dashboards to facilitate data-driven decision-making.
• Perform data cleansing and validation to ensure data quality.
• Analyse trends, patterns, and correlations in large datasets to identify opportunities and provide insights.
• Present findings and recommendations to the SMT through clear and concise reports
• Ad-hoc duties as required.

We are looking for a candidate with proven analytical experience, manipulating complex data spreadsheets and advanced proficiency in Microsoft Excel – including IF formulas / pivot tables / VLOOKUP. You will have a keen eye for detail and the capability to communicate effectively with the friendly close-knit team.

As an Equal Opportunities employer we welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion / belief, sexual orientation or age.