Data Analyst

Pontoon Solutions; Warwick; Hybrid; GBP 35,000 - 55,000; Full time

Job summary

Pontoon Solutions in the United Kingdom is seeking a Data Analyst with strong reporting, dashboard development and stakeholder management skills to join a large, complex organisation delivering major infrastructure projects.

You will transform complex data into meaningful insights, develop Power BI dashboards, and support performance reporting across a substantial project portfolio while driving data quality improvements and governance.

Qualifications

• Proven experience as Data Analyst, Reporting Analyst, MI Analyst or BI professional.
• Advanced Excel skills demonstrated in reporting and data manipulation.
• Experience cleansing, transforming and presenting data to varied audiences.
• Strong stakeholder management and communication skills.
• Experience analyzing complex datasets and delivering value-added reports.

Responsibilities

• Develop and deliver project and portfolio reporting to support leadership decisions.
• Build dashboards, reports and analytical models providing business insights.
• Monitor data quality and drive improvements in reporting accuracy and integrity.
• Collaborate with stakeholders across functions to gather reporting requirements.
• Transform complex datasets into actionable insights for decision-making.
• Support workforce planning, forecasting and risk analysis activities.
• Create reporting tools, models and processes to improve efficiency.
• Coordinate with digital and systems teams to shape future reporting capabilities.
• Ensure reporting activities align with governance standards.

Skills

Advanced Excel

Stakeholder management

Data analysis

Attention to detail

Tools

Power BI

SQL

Power Query/Power Pivot

SAP

Microsoft Power Apps

Microsoft Copilot / AI tools

Job description

Hybrid Working | Typically 2 days per week in Warwick office

An excellent opportunity for a Data Analyst with strong reporting, dashboard development and stakeholder management skills to join a large, complex organisation delivering major infrastructure and portfolio programmes.

We're partnering with a leading organisation to recruit a Data Analyst to support the delivery of critical reporting, performance insights and data improvement initiatives across a substantial project portfolio.

This role would suit an experienced Data Analyst, Reporting Analyst, MI Analyst, Power BI Analyst or Business Intelligence professional who enjoys transforming complex data into meaningful insights that support strategic decision-making.

Why This Role is Exciting

You will be responsible for delivering high-quality reporting and analytics that support senior leadership teams in managing large-scale project portfolios. The role combines technical data expertise, stakeholder engagement, reporting development and continuous improvement, offering excellent exposure to business-critical decision-making.

You will also play a key role in improving data quality, shaping future reporting solutions and supporting ongoing digital transformation initiatives.

What You'll Be Doing

• Developing and delivering project and portfolio reporting to support leadership decision-making.
• Building dashboards, reports and analytical models that provide meaningful business insights.
• Monitoring data quality and leading initiatives to improve reporting accuracy and integrity.
• Working with stakeholders across multiple business functions to understand reporting requirements and drive data-led decision-making.
• Analysing complex datasets and transforming them into clear, actionable insights.
• Supporting workforce planning, future forecasting and risk analysis activities.
• Developing reporting tools, models and processes to improve efficiency and decision support.
• Collaborating with digital and systems teams to help shape future reporting capabilities and data solutions.
• Ensuring reporting and data management activities align with governance standards and best practice.

What We're Looking For

• Proven experience in a Data Analyst, Reporting Analyst, MI Analyst or Business Intelligence role.
• Advanced Microsoft Excel skills.
• Experience cleansing, manipulating and presenting data to a variety of audiences.
• Strong stakeholder management and communication skills.
• Experience analysing complex datasets and creating value-added reporting solutions.
• Strong attention to detail and ability to meet tight deadlines.

Technical Skills

• Power BI
• SQL
• Data modelling and data structures
• Power Query and Power Pivot (highly advantageous)
• SAP
• Microsoft Power Apps
• Microsoft Copilot and AI-enabled reporting tools

Ideal Candidate

You’ll be:

• Naturally analytical and curious.
• Comfortable working with large and complex datasets.
• A confident communicator who can translate data into meaningful business insights.
• Proactive in identifying opportunities for process improvement.
• Skilled at building strong relationships with stakeholders at all levels.
• Passionate about data quality, governance and continuous improvement

Pontoon is a disability-confident employer. It is important to us that we run an inclusive and accessible recruitment process to support candidates of all backgrounds and all abilities to apply. Pontoon is committed to building a supportive environment for you to explore the next steps in your career. If you require reasonable adjustments at any stage, please let us know and we will be happy to support you.

We use generative AI tools to support our candidate screening process. This helps us ensure a fair, consistent, and efficient experience for all applicants. Rest assured, all final decisions are made by our hiring team, and your application will be reviewed with care and attention.