Reporting/Dashboard Analyst - Project Controls
-
IT/Tech
-
Business
Job Description & How to Apply Below
JOB DESCRIPTION
The Project Portfolio – Reporting / Dashboard Analyst is responsible for developing, maintaining, and improving project controls reporting, dashboards, and portfolio-level analytics for a portfolio of midstream owner/operator capital projects. This role supports accurate, timely, and actionable reporting across cost, schedule, commitments, forecasts, change management, cash flow, risks, and portfolio performance.
Primary PurposeJOB DESCRIPTIONThe Project Portfolio – Reporting / Dashboard Analyst is responsible for developing, maintaining, and improving project controls reporting, dashboards, and portfolio-level analytics for a portfolio of midstream owner/operator capital projects. This role supports accurate, timely, and actionable reporting across cost, schedule, commitments, forecasts, change management, cash flow, risks, and portfolio performance. The position serves as a key interface between Project Controls, Project Management, Engineering, Construction, Finance/AP, Supply Chain, Scheduling, Estimating, and leadership to ensure project data is collected, validated, organized, and presented in a clear format that supports business decisions.
The role will help improve reporting consistency, data quality, dashboard automation, and executive visibility across the capital projects portfolio.
- Develop, maintain, and enhance project controls reports, dashboards, and portfolio-level reporting tools.
- Prepare recurring project and portfolio reporting packages for project leadership, department leadership, and executive stakeholders.
- Support reporting across key project controls areas, including budgets, commitments, actuals, accruals, forecasts, cash flow, contingency, change orders, schedule milestones, risks, and project status.
- Collect, validate, and consolidate project data from multiple sources, including ERP systems, project cost systems, scheduling tools, estimating systems, spreadsheets, SharePoint/Teams, and other reporting platforms.
- Build and maintain dashboards using tools such as Power BI, Tableau, Excel, or similar business intelligence platforms.
- Translate complex project data into clear, concise, and actionable reporting outputs for management and executive review.
- Support development of standardized project controls KPIs, metrics, report templates, dashboard layouts, and data definitions across the project portfolio.
- Perform data quality checks and QA/QC reviews to ensure reporting accuracy, completeness, consistency, and alignment with source systems.
- Identify reporting gaps, data inconsistencies, process issues, and improvement opportunities; work with stakeholders to resolve issues and improve reporting reliability.
- Support monthly reporting cycles, including preparation of project summaries, variance explanations, performance dashboards, and portfolio scorecards.
- Partner with Cost Analysts to incorporate cost performance, forecast changes, commitments, actuals, accruals, open commitments, and contingency status into dashboards and reporting.
- Partner with Schedulers to incorporate milestone movement, schedule variance, critical path updates, baseline comparisons, and forecast completion dates into reporting tools.
- Partner with Estimating resources to incorporate estimate updates, development opportunities, budget assumptions, and estimate maturity into portfolio reporting.
- Partner with Change Order and Project Controls resources to report change logs, pending changes, approved changes, contingency drawdown, forecast exposure, and commercial risks.
- Maintain dashboard data models, calculations, formulas, data connections, report logic, and visualization standards.
- Develop ad hoc reports and analysis in response to leadership, project team, finance, commercial, or executive requests.
- Support portfolio governance by tracking project status, key milestones, financial performance, schedule performance, risks, issues, and decision items.
- Maintain reporting calendars, data submission timelines, version control, and documentation for recurring reports and dashboards.
- Assist in the development of automated reporting workflows to reduce manual effort and improve reporting cycle time.
- Support dashboard user testing, training, and adoption across project teams and leadership.
- Ensure reporting outputs are easy to understand, visually effective, and aligned with stakeholder needs.
- Support data governance by helping establish consistent data definitions, naming…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction