Data Analyst - hybrid - 40 hours per week

To apply for this Data Analyst role, applicants must submit a personally written CV and cover letter. We kindly ask that you do not use AI writing tools (e.g., ChatGPT, Gemini, etc.) to generate or assist with your application materials. We are looking to understand your authentic voice, experience, and motivation, and value genuine, individual expression over polished, generic responses. Applications that appear AI-generated may not be considered.

Working for CET is many things - exciting, challenging, rewarding, occasionally frustrating - but it's never dull. You'll work with a diverse mix of people in a buzzing atmosphere and be part of a welcoming, inclusive community.

The Package

Annual Salary: Offering a competitive salary of circa £40K, dependent on experience, with eligibility for a discretionary annual bonus scheme and an excellent benefits package.

Location: Walsall

Hybrid Working Pattern: Monday to Friday, 40 hours per week, with start and finish times to be agreed, at least 3 days in the office and 2 days remote.

Annual Leave: 25 days plus public/bank holidays

Job Purpose

You will prepare and analyze data to generate actionable insights for business decisions. The role combines data engineering and analytical responsibilities, with a focus on stakeholder engagement, report automation, and monitoring business performance.

Key Responsibilities

Data Engineering & Automation

• Develop, test, and maintain ETL pipelines; experience with Python and Azure Functions is advantageous.
• Design, build, and manage robust data models to support reporting needs.
• Automate and streamline manual reporting processes using tools such as Power BI.
• Ensure all data handling adheres to CET's data security protocols and complies with the Data Protection Act (DPA).

Reporting & Analysis

• Generate, verify, and distribute client MI reports in Power BI and Excel, ensuring accuracy and timely delivery.
• Maintain and update forecast data within Excel models and lookup tables.
• Provide clear analysis to stakeholders, highlighting trends and variances.
• Respond to ad-hoc data requests with insightful outputs.

Stakeholder Engagement

• Collaborate with internal teams to gather requirements, validate outputs, and refine reports.
• Lead performance reviews and present insights to management.
• Maintain documentation of reporting processes for knowledge transfer and audit purposes.

Financial & KPI Reporting

• Support month-end financial reporting, including budgets, forecasts, and KPIs.
• Own weekly KPI tracking and reporting processes.
• Assist in reforecasting and automation opportunities.
• Provide pricing and performance modeling support for HE client accounts.
• Deliver ad-hoc financial analysis as needed.

Required Skills & Experience

• Proficiency with Microsoft Power BI.
• Experience with Power BI Report Builder (Paginated Reports) and Power Automate is desirable.
• Data engineering experience in Python and Azure Functions is desirable.
• VBA proficiency in Excel, with strong analytical skills.
• Excellent communication skills, both written and verbal.
• Attention to detail, accuracy, and process documentation skills.
• Ability to work independently and collaboratively.

Desirable Qualifications

• Degree in Mathematics, Data Science, Economics, Engineering, or similar.
• Experience in finance, operations, or client reporting environments.

Diversity, Inclusion & Accessibility at CET

We are committed to an inclusive workplace and welcome applications from individuals of diverse backgrounds and abilities. We are proud to be a Disability Confident Committed Employer. Please inform us if you require accommodations during the application process.