Data Analyst

ACS Performance; City of Edinburgh; On-site; GBP 30,000 - 45,000; Full time

Job summary

A leading data analytics firm in Edinburgh is seeking a Data Analyst to support their Business Intelligence function. The role involves producing regular business reports and building dashboards using Power BI. The ideal candidate has strong skills in Power BI, SQL, and Excel, with an attention to detail and a strong analytical background. This hands-on position is key to driving performance across departments.

Qualifications

• Strong skills in Power BI Desktop and Report Builder.
• Confident in building SQL queries and views.
• Advanced Excel skills including pivot tables and VLOOKUPs.
• Excellent attention to detail required.
• Comfortable working independently and as part of a team.
• Prior exposure to financial or manufacturing data environments is beneficial.
• Experience with ERP systems, ideally Syspro.
• Background in auditing or compliance is a plus.

Responsibilities

• Produce and maintain regular reports for internal departments.
• Schedule and deliver monthly, year-end and ad hoc reporting.
• Build dashboards and data models using Power BI.
• Assist with software upgrades and implementations.
• Maintain Excel trackers and performance logs.
• Complete official statistical surveys.
• Support internal audit processes and data reconciliation.

Skills

Power BI Report Builder

SQL queries

Advanced Excel

Attention to detail

Time management

Teamwork

Financial data environment experience

ERP systems experience

Auditing background

Tools

Power BI

Excel

SQL

ERP systems

Job description

We're working with a company seeking a data-savvy analyst to support their Business Intelligence function. This is a hands-on reporting role, ideal for someone who enjoys turning data into meaningful insights to drive performance across departments.

You'll work alongside a small team to build, maintain, and schedule business reports using tools like Power BI, Excel, and SQL, contributing to everything from monthly reporting to audit support.

Key Responsibilities:

• Produce and maintain regular reports for internal departments
• Schedule and deliver monthly, year-end, and ad hoc reporting
• Build dashboards and data models using Power BI
• Assist with software upgrades and implementations
• Maintain Excel-based trackers and performance logs
• Complete official statistical surveys (ONS)
• Support internal audit processes and data reconciliation

Key Skills & Experience Required:

• Strong Power BI Desktop and Report Builder skills
• Confident with SQL - building queries and views
• Advanced Excel - pivot tables, charts, VLOOKUPs, formatting
• Excellent attention to detail and time management
• Comfortable working independently and as part of a team
• Prior exposure to financial or manufacturing data environments
• Experience with ERP systems (e.g. Syspro)
• Background in auditing or compliance

This is a great opportunity for someone who thrives on accuracy, enjoys working with business data, and wants to be part of a team that plays a critical role in business decision-making.

ACS are recruiting for a Data Analyst. If you feel that you have the skills and experience required in this advertisement to be a Data Analyst submit your CV including an outline of your experience as a Data Analyst. It is always a good idea to include a covering letter outlining your experience as a Data Analyst with your application as this will enhance your chances of selection and improve your prospects of landing the Data Analyst role you desire.