Job Description

Data Analyst – Data & Insight Transformation (Power BI Specialist)

Location: Essex (On-Site, 3 Days per Week)

Duration: 3 Months (ASAP Start) Likely extension

Clearance Required: No CTC clearance required for this role, but CTC clearance is recommended for future projects.

£400 – 500/day inside IR35

________________________________________

Role Overview

The Data & Insight team is undergoing a transformation to adopt automated and visual data reporting methods, transitioning from Excel and PowerPoint to Power BI. This role focuses on migrating asset maintenance reporting to Power BI, creating a comprehensive and interactive asset maintenance scorecard. The consultant will work closely with the Data & Insight and Assets teams to ensure actionable insights can be derived from the new system while upskilling in-house teams.

________________________________________

Key Responsibilities

1. Data Discovery & Audit:

• Identify and document data sources across finance, health and safety, and maintenance management systems.

• Conduct an audit of current platforms to capture relevant data points.

• Propose automation solutions and identify opportunities for future enhancements.

2. Data Engineering:

• Develop methods for data ingestion, cleansing, and validation.

• Create pipelines to automate data flows and ensure consistent, accurate reporting.

3. Data Visualisation:

• Build interactive Power BI dashboards tailored to asset maintenance performance.

• Provide solutions for trend analysis, root cause identification, and actionable insights.

• Design dashboards that allow interrogation on multiple levels and facilitate meaningful discussions.

4. Governance & Documentation:

• Create detailed process documentation, including methodologies, data sources, and calculations.

• Ensure processes align with MAG’s central Data and Strategic Analytics team guidelines.

5. Knowledge Transfer:

• Conduct training sessions for in-house performance analysts and other stakeholders.

• Ensure a smooth handover of the BI dashboard to the internal team, including ongoing support and development capabilities.

6. Stakeholder Engagement:

• Collaborate with key stakeholders, including the Head of Data & Insight and Director of Asset, to align the project with business goals.

• Attend monthly asset comms cell meetings, fortnightly team meetings, and twice-weekly stand-ups to provide updates on progress.

________________________________________

Essential Skills & Experience

• Data Visualisation: Strong experience in Power BI, including building interactive dashboards and reports.

• Data Management & Automation: Expertise in data engineering, including pipelining, automation, and data validation processes.

• Stakeholder Management: Proven ability to engage with senior stakeholders and present findings effectively.

• Documentation & Governance: Skilled in documenting technical processes and ensuring adherence to governance frameworks.

• Upskilling & Training: Experience in teaching or knowledge transfer to upskill internal teams.

________________________________________

Desired Skills & Experience

• Familiarity with asset maintenance, health and safety, and financial data.

• Experience working in operationally intensive environments.

• Understanding of testing methodologies and incorporating test data into reporting frameworks.

• Prior experience working in or with large organizations or the aviation sector.

________________________________________

Core Stakeholders

• Head of Data & Insight

• Director of Asset

• DASA Senior Data & Insight

• Performance Analysts and Asset Leads (TBC)

________________________________________

This role is ideal for a mid-level consultant with strong technical expertise, stakeholder engagement skills, and a proactive attitude to independently manage projects while aligning with organizational objectives