Reporting Analyst

Role overview

Responsibilities

• Develop, maintain, and enhance Power BI dashboards, reports, and visualizations for project performance reporting.
• Collect, validate, consolidate, and analyze data from project controls systems and other approved sources.
• Support weekly, bi-weekly, monthly, and ad hoc reporting for the project, project management team, and executive leadership.
• Conduct data quality checks, validation, and reconciliation to ensure reporting accuracy and consistency.
• Generate schedule, cost, risk, deliverable, resource, performance, and KPI reporting; produce dashboards and scorecards tracking project health, trends, forecasts, and milestones.
• Collaborate with project controls, planning, risk, engineering, and project management stakeholders to maintain reporting solutions.
• Maintain reporting templates, datasets, data models, calculation logic, documentation, governance standards, calendars, and procedures.
• Support automation and continuous improvement; analyze trends, anomalies, data gaps, risks, and items requiring management attention.
• Prepare executive presentations, management reports, project review materials, custom analyses, and reporting extracts.
• Support Earned Value Management, project controls, project reviews, and performance assessments through reporting and analytics.

Qualifications

• Bachelor's degree, college diploma, or equivalent combination of education and relevant experience.
• Two to five years of experience in project reporting, project controls, business intelligence, data analytics, or a related field.
• Experience using Power BI, Excel, Power Query, and related reporting or analytical tools; experience with large datasets and multiple data sources.
• Experience supporting engineering, construction, nuclear, infrastructure, or major capital projects is an asset.
• Knowledge of project controls principles, including schedule, cost, risk, progress, and performance reporting.
• Understanding of KPI development, dashboard design, data visualization, and reporting best practices.
• Familiarity with EcoSys, Primavera P6, Oracle, SAP, or similar project management systems is an asset.
• Strong analytical, problem-solving, organizational, and communication skills; able to translate complex project data into practical insights.

Preferred skills

• Power BI dashboard development and DAX.
• Data modeling, transformation, and analytics; advanced Excel and Power Query.
• Executive reporting and presentation development; project controls, schedule, risk, deliverable, and resource reporting.
• Data quality management, validation, and reconciliation; reporting automation and continuous improvement.

Rewards and benefits

• The employer describes competitive compensation, employee recognition, flexible benefits, training and professional development, a hybrid working culture, and time-off policies.

About AtkinsRéalis