Senior Data Analyst

Mackie Myers are Partnering with London based Transport organisation, seeking a Senior Data Analyst. The role requires a highly capable Senior Data and Business Intelligence Analyst to join a growing, complex, Group Finance team.

Location: London (Hybrid, 3 days in the office per week)

This is a high-impact role focused on designing and delivering scalable, enterprise-grade Power BI reporting solutions that support strategic decision-making across the business.

This position is ideal for someone a strong Data Analyst back ground, confident with Power Automate, Python, or VBA, who enjoys solving complex problems, building robust data solutions from the ground up, and working in an environment where requirements are not always fully defined. You'll have the opportunity to influence how data is structured, automated, and leveraged across the organisation while collaborating with senior stakeholders.

While experience within finance or commercial environments is advantageous, we are primarily looking for someone with strong analytical, technical, and problem-solving capabilities.

Key Responsibilities

• Design and develop scalable data models, reporting solutions, and Power BI dashboards that support business decision-making.
• Own the end-to-end reporting lifecycle, from data acquisition and transformation through to dashboard delivery and maintenance.
• Build and optimise data pipelines using Excel, Power Query, and related tools.
• Develop DAX measures and reporting solutions that are efficient, reliable, and user-friendly.
• Identify opportunities to automate processes and improve reporting efficiency using tools such as Power Automate, Office Scripts, or Python.
• Translate complex business requirements into practical, data-driven solutions.
• Collaborate with stakeholders across the organisation to understand requirements and deliver actionable insights.
• Drive continuous improvement by adopting new technologies, automation techniques, and best practices.

Skills & ExperienceEssential

• Advanced Excel skills and experience working with complex datasets.
• Strong Power BI development experience, including DAX and dashboard design.
• Hands-on experience with Power Query (M).
• Proven track record of delivering end-to-end BI and reporting solutions.
• Strong analytical, problem-solving, and stakeholder management skills.

Desirable

• Experience with Power Automate, Office Scripts, Python, or VBA.
• Exposure to JavaScript or TypeScript.

About You

• Curious, hands-on, and passionate about data and technology.
• Comfortable working independently in a fast-paced environment.
• Strong communicator with the ability to engage technical and non-technical stakeholders.
• Motivated to learn, improve, and embrace emerging technologies, including AI and automation.

What You'll Gain

• Ownership of high-impact reporting and analytics solutions.
• Exposure to complex, business-critical challenges.
• Opportunities to influence reporting strategy and technology adoption.
• Direct engagement with senior stakeholders.
• A supportive environment focused on growth, innovation, and continuous improvement.