Data Analyst

The Business Connection; United Kingdom; On-site; GBP 80,000 - 100,000; Full time

Job summary

An established industry player is seeking a detail-oriented Data Analyst to collaborate with a team of analysts in extracting, compiling, and validating data for comprehensive reporting. This exciting role focuses on ensuring data integrity and accuracy while leveraging Business Intelligence tools like Power BI to create insightful reports. The ideal candidate will oversee audit processes, analyze trends, and proactively identify opportunities for process improvements. Join a forward-thinking organization that values data-driven decision-making and offers a dynamic environment where your contributions will make a significant impact on the business's success.

Qualifications

• Proficiency in Power BI for report and dashboard creation is essential.
• Advanced SQL skills for creating views and queries are required.

Responsibilities

• Oversee the audit process and analyze trends for demand planning.
• Identify and resolve data gaps in ERP and forecasting systems.

Skills

Data reconciliation

Analytical skills

Problem-solving

Organizational skills

Education

Power BI Desktop and Report Builder

SQL Database Skills

Advanced MS Excel

Tools

Power BI

SQL

MS Excel

Job description

Data Analyst

The role involves collaborating closely with fellow analysts to extract, compile, and validate data for inclusion in a wide range of reports, ensuring data accuracy and integrity throughout the process. This role involves auditing datasets to identify inconsistencies or errors before final inclusion in reports, as well as leveraging Business Intelligence (BI) software to create, maintain, and schedule reports. Additionally, it requires managing the entire reporting lifecycle, from data extraction and aggregation to the design and automation of recurring reports. The goal is to deliver reliable, insightful, and timely reports that support informed decision-making across the organisation.

Data Analyst's Key Responsibilities:

• Oversee the execution of the audit process.
• Analyse trends, review forecast exceptions, and develop a robust demand plan to optimise service and minimise costs.
• Provide critical data for formal improvement initiatives and proactively identify opportunities for process enhancements.
• Identify and resolve data gaps in the ERP and forecasting systems.
• Conduct periodic audits between the ERP system.
• Develop proficiency in PowerBI for report and dashboard creation.

Data Analyst's Education and Experience:

• Power BI Desktop and Report Builder (this is the central skill set of the role)
• SQL Database Skills (create views and queries)
• MS Excel Advanced (including charts, lookup tables, pivot tables, presentation / report formatting skills)
• Data reconciliation
• Ability to organise own workload based on priorities and deadlines
• Ability to work alone and as part of a team

We are an equal opportunities agency and welcome applicants from all backgrounds.