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