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