Portfolio Data & Reporting Analyst

The Automobile Association; Basingstoke; On-site; GBP 50,000 - 75,000; Full time

Benefits offered by this job

25 days annual leave

Pension contribution

AA breakdown membership

GP and wellbeing support

Employee discounts

Job summary

The Automobile Association is seeking a Portfolio Data & Reporting Analyst to join our Transformation team in the UK. You will design and maintain portfolio reporting and Power BI dashboards, turning complex data into trusted insights that inform planning and prioritisation.

You will work with Jira, SQL and JQL to deliver self-serve analytics across portfolio levels. You will collaborate with Delivery, PMO and senior leaders to translate needs into meaningful dashboards and improve data quality

Qualifications

• Strong experience turning complex portfolio data into dashboards and insights.
• Hands-on Power BI dashboards development with data modelling and DAX.
• Ability to translate business requirements into clear metrics and dashboards.

Responsibilities

• Design, develop and maintain portfolio reporting and Power BI dashboards across portfolio, Value Stream, Lab and Squad levels.
• Create self-serve analytics to empower teams to explore delivery performance and capacity.
• Extract, transform and analyse data from Atlassian tools using SQL and JQL.
• Collaborate with Transformation, Technology and senior stakeholders to define reporting needs.

Skills

Stakeholder engagement

Analytical capability

Data governance

Transformation delivery

Portfolio reporting

Tools

Power BI

SQL

JQL

Jira

Atlassian tools

Job description

• Annual bonus opportunity
• Shape and embed The AA's critical data governance operating model across a large, complex organisation
• Build a meaningful Group wide capability with strong executive sponsorship and the opportunity to influence how data is governed from an early stage
• Play a key role in ensuring trusted, high-quality data supports better decision making, customer outcomes and our growing Data and AI ambitions
• For over a century, The AA has been keeping Britain moving. Today, millions of drivers trust us to be there when it matters most, and we're equally committed to supporting the people who make that possible. With a 4.5-star Glassdoor rating, we've built a culture where colleagues are empowered to grow, collaborate and make a real impact for our customers on every journey. Which has been recognised by Sunday Times "Best Places to Work" for the last two years., We're looking for a Portfolio Data & Reporting Analyst to join our Transformation team, combining strong data and reporting capability with an understanding of complex Technology, Transformation and Agile delivery environments. Using Power BI, SQL and JQL, you'll turn complex portfolio and delivery data into trusted, actionable insight that supports better planning, prioritisation and decision making. You'll design and maintain reporting and self serve analytics across portfolio, Value Stream, Lab and Squad levels, providing clear visibility of delivery performance, resource capacity, demand and portfolio outcomes. Working closely with our Portfolio Management Office, Jira Product Owner, Resource Manager, Data & Analytics teams and Technology and Delivery leaders, you'll translate business and reporting requirements into meaningful dashboards, datasets and insight. You'll also play an important role in improving data quality, metric definitions and reporting governance, reducing reliance on manual reporting and enabling teams and leaders to make better use of self serve analytics.
• What You'll Do
• Design, develop and maintain portfolio reporting and Power BI dashboards that provide timely, accurate and actionable insight across portfolio, Value Stream, Lab and Squad levels.
• Create self serve analytics capabilities that enable teams and leaders to independently explore delivery performance, resource capacity and portfolio data.
• Use SQL and JQL to extract, transform and analyse data from Atlassian tools, building clear views of progress, flow, dependencies, risks, issues, outcomes and trends.
• Develop resource capacity and demand reporting to support effective planning, prioritisation and decision making, including migrating existing capacity views into Atlassian based reporting.
• Partner with Transformation and Technology leaders and wider delivery stakeholders to understand reporting requirements and translate them into meaningful dashboards, datasets and insight.
• Improve data quality, metric definitions and reporting governance, working closely with Data & Analytics and helping colleagues interpret and use reporting effectively.
• Strong experience working within a Portfolio, Transformation, Technology or Agile delivery environment, with a good understanding of how delivery operates across portfolios, programmes, Value Streams or cross functional teams.
• Strong hands on experience developing dashboards and self serve reporting in Power BI, including data modelling and DAX, with the ability to turn complex delivery data into clear and actionable insight.
• Practical experience using SQL to query, join and analyse complex datasets, alongside experience extracting and reporting on delivery data from Jira using JQL.
• Experience reporting across delivery performance, resource capacity, demand, forecasting, dependencies, risks and outcomes, with the ability to define meaningful metrics and KPIs that support planning and prioritisation.
• Experience improving data quality, reporting governance and self serve analytics, with strong attention to metric consistency, data accuracy, usability and visual clarity.
• Excellent stakeholder engagement and analytical capability, with experience working with Delivery, PMO, Product, Technology or senior leadership stakeholders to translate reporting needs into meaningful dashboards, insight and recommendations.
• At The AA, we value the unique perspectives, experiences and ideas that our people bring. We've nurtured a workplace where everyone feels valued, respected and empowered to do their best work.
• Through our employee communities and inclusion initiatives, we've created opportunities for people to connect, share experiences and influence positive change across the business. This is a place where your voice matters and where you can belong, grow and succeed. Driven by People, Rewarded by Benefits We believe in rewarding our people. That's why we offer a comprehensive benefits package including;
• 25 days' annual leave plus bank holidays, the option to buy additional holiday
• Up to 7% employer pension contribution
• Free AA breakdown membership from Day One with 50% discount for family and friends, discounts on AA products including car and home insurance
• 24/7 GP access and wellbeing support for you and your family
• A wide range of employee discounts, including our popular car salary sacrifice scheme