Data and Reporting Analyst

Aureos Capital; Andover (MA); On-site; USD 65,000 - 90,000; Full time

Job summary

Aureos Capital seeks a Reporting Analyst to own programme and contract performance reporting across projects. You will develop and maintain Power BI dashboards, ensuring accurate management information for operational delivery and client needs.

The role emphasizes governance, data quality and actionable insights. Collaborating with PMO and project teams, you will streamline data flows, deliver period-end reporting, and provide executive-level insights to support decision-making and performance

Qualifications

• Advanced Power BI development with data transformation and modelling.
• Experience delivering reporting solutions in programme/portfolio or operational environments.
• Knowledge of Power BI governance and management information processes.

Responsibilities

• Deliver client and internal reporting in line with PMO standards and governance.
• Identify data inputs and define data flows for dashboards.
• Develop, maintain and enhance Power BI dashboards, reports and data models.
• Produce weekly, monthly and period-end reporting for performance monitoring.
• Analyze data to identify trends, risks and opportunities.

Skills

Advanced Power BI development

Data analysis

Stakeholder engagement

Report design

Communication skills

Problem-solving

Education

Qualifications in Data Analytics/BI

Tools

Power BI

Power Query

DAX

Data Modelling

Job description

If you are looking to work for a growing business who truly value and care for their employees, then look no further!

Role Purpose

The Reporting Analyst will own and manage the efficiency, quality and governance of programme and contract performance reporting. Working closely with project teams, PMO functions and stakeholders, you will be responsible for developing, maintaining and enhancing reporting solutions, with a strong focus on Power BI data visualisation, performance insights and reporting governance.

This role will provide a central point of ownership for programme reporting, ensuring accurate, timely and insightful management information is available to support operational delivery, client requirements and strategic decision-making.

Key Responsibilities

Reporting & Data Visualisation

• Work directly with project teams to deliver client and internal reporting in line with PMO reporting standards and governance requirements.
• Identify and document data inputs required to produce reporting outputs and dashboards.
• Collaborate with project teams and the PMO Reporting Lead to define reporting requirements and establish efficient data flows and datasets.
• Support the PMO in obtaining data from system owners through the provision of clear technical requirements and supporting documentation.
• Develop, maintain and enhance Power BI dashboards, reports and data models for both operational and executive reporting purposes.
• Produce flash, weekly, monthly and period-end reporting to support programme performance monitoring and assurance activities.
• Analyse data and provide meaningful insights, identifying trends, risks, opportunities and areas for improvement.

Stakeholder Management

• Distribute reporting outputs to both internal and external stakeholders.
• Highlight performance issues, data quality concerns and emerging risks to relevant teams and management.
• Build strong working relationships with project teams, PMO colleagues and clients to ensure reporting requirements are understood and delivered effectively.
• Support reporting reviews, governance meetings and assurance processes.

Reporting Governance & Continuous Improvement

• Develop and improve reporting procedures, processes, tools and governance frameworks.
• Establish and maintain a reporting request, issue and enhancement log, ensuring requests are reviewed, prioritised and managed effectively.
• Drive continuous improvement initiatives to increase reporting efficiency, accuracy and usability.
• Ensure reporting outputs remain aligned with client requirements and organisational standards.

Reporting Administration

• Manage report access, user permissions and audience roles across reporting platforms.
• Support data quality reviews and validation activities.
• Coordinate and manage ad hoc intensive reporting requirements during major programme events, disruptive possessions or critical delivery periods.

Additional Duties

• Support wider PMO, programme performance and governance activities as required.
• Undertake other duties that contribute to the effective delivery of programme controls and reporting objectives.

Desirable

• Power BI certifications or formal training.
• Relevant qualifications in Data Analytics, Information Management, Business Intelligence or a related discipline.

Knowledge

• Practical knowledge of Power BI, including data transformation, modelling and visualisation.
• Understanding of reporting governance and management information processes.
• Knowledge of construction, infrastructure, engineering or similarly regulated industries.
• Understanding of data management principles and reporting best practice.

Skills & Competencies

Essential

• Advanced Power BI development skills, including Power Query, DAX, data modelling and dashboard design.
• Strong analytical and problem-solving capabilities.
• Ability to interpret reporting requirements from contractual, programme and business documentation.
• Excellent communication skills, including written, verbal and visual presentation of information.
• Strong stakeholder engagement and relationship-building skills.
• Ability to influence, negotiate and collaborate across multiple teams.
• High attention to detail with a commitment to data accuracy and quality.
• Resilient, adaptable and driven to achieve desired outcomes.

Desirable

• Knowledge of project controls, programme management and PMO disciplines.
• Experience working with complex, multi-source datasets.

Experience

Essential

• Proven experience developing Power BI reports, dashboards and data models.
• Experience manipulating and analysing complex datasets from multiple sources.
• Experience managing reporting requests, issues and enhancement logs.
• Experience administering data access and permissions.
• Experience delivering reporting solutions in a programme, portfolio or operational environment.

Desirable

• Experience within the construction, energy, utilities or infrastructure sectors.
• Experience supporting large-scale programmes and projects.
• Experience working within PMO, project controls or programme governance environments.

Whether you are looking for progression in your new role or for your forever job, we will happily welcome your application.

Equal Opportunities

Aureos are an equal opportunities employer, and we are determined to ensure that no applicant or employee receives less favourable treatment on the grounds of gender, age, disability, religion, belief, sexual orientation, marital status or race, or is disadvantaged by conditions or requirements which cannot be shown to be justifiable.