PRIMARY PURPOSE
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. 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.
Essential duties and responsibilities:
- 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 conventions, reporting hierarchies, project codes, and quality standards.
- Create and maintain documentation for report logic, dashboard design, data sources, refresh timing, and business rules.
- Support project closeout reporting, including final cost summaries, trend reporting, lessons learned, and historical data capture.
- Maintain dependable attendance and deliver consistent, high-quality work.
- Work non-traditional hours as required to meet deadlines, month-end close requirements, executive reporting cycles, or urgent leadership requests.
- Prioritize safety and adhere to company safety policies and procedures.
- Complete other project-specific tasks and duties as assigned.
Minimum requirements:
Education:
- Bachelor’s degree from an accredited institution in Accounting, Business Administration, Finance, Data Analytics, Information Systems, Construction Management, Engineering, or a related discipline; or equivalent relevant experience.
Experience/Specific Knowledge:
- 5–8+ years of relevant experience in project controls, reporting, dashboard development, business intelligence, cost control, financial analysis, data analytics, or portfolio reporting supporting capital projects.
- Experience developing management-level reports, dashboards, scorecards, and executive summaries.
- Demonstrated ability to consolidate and validate data from multiple systems and convert it into meaningful business insights.
- Experience with project controls reporting, including cost, schedule, forecast, commitments, actuals, accruals, change management, cash flow, and variance reporting.
- Experience with financial systems and tools such as Microsoft Office, Excel, Word, PowerPoint, Outlook, SharePoint/Teams, ERP systems, and project cost systems.
- Experience with reporting and visualization tools such as Power BI, Tableau, Looker, Excel Power Query, or similar platforms.
- Working knowledge of capital project execution, project controls, cost reporting, schedule reporting, and portfolio management.
Certifications, Licenses & Registrations:
- Must possess and maintain a valid driver’s license and a driving record satisfactory to the company and its insurers (for travel).
Competencies, Skills & Abilities:
- Strong reporting, dashboarding, data visualization, and analytical skills.
- Strong process orientation with excellent attention to detail and documentation discipline.
- Ability to validate, reconcile, and interpret large volumes of project data from multiple sources.
- Ability to translate complex cost, schedule, and project performance data into clear, concise, and actionable reporting.
- Intermediate-to-advanced Excel capability, including formulas, pivot tables, lookup functions, Power Query, charts, and ad hoc reporting.
- Working knowledge of Power BI, Tableau, or similar dashboard/reporting tools.
- Understanding of project controls fundamentals, including budgets, actuals, commitments, forecasts, change orders, contingency, cash flow, schedules, milestones, and variance analysis.
- Ability to develop effective visuals, charts, tables, scorecards, and executive-level dashboards.
- Strong communication skills and ability to collaborate cross-functionally with Project Controls, Project Management, Finance, Engineering, Construction, Supply Chain, Scheduling, Estimating, and leadership.
- Ability to clearly communicate reporting requirements, data issues, dashboard logic, and performance trends to stakeholders.
- Ability to organize and prioritize work under strict deadlines.
- Flexibility to adjust to changing priorities, urgent reporting requests, and multiple concurrent deadlines.
- Sound judgment and ability to handle sensitive project, commercial, contractual, and financial information.
- Strong problem-solving skills with the ability to identify data gaps, reporting issues, root causes, and improvement opportunities.
- Ability to work independently while maintaining alignment with project controls standards and leadership direction.
- Strong customer-service mindset with the ability to support report users and stakeholders.
- Ability to support reporting automation, process improvement, and data governance initiatives.
Physical Demands:
All of the physical requirements listed below are those that may be necessary for an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Sitting; standing; walking or moving throughout facility; driving; talking; seeing (specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus); hearing; feeling; bending or stooping; squatting or crouching; reaching; kneeling; pushing; pulling; lifting up to 25 lbs.
- Minimal safety hazards; general office working conditions.
- Must be able to sit for prolonged periods of time.
- The employee is regularly required to use hands to type, touch, handle, or feel. The employee is required to talk and hear. The employee is frequently required to stand and reach with hands and arms. The employee is occasionally required to walk and climb or balance. The employee must regularly lift and /or move up to 10 pounds and occasionally lift and/or move up to 25 pounds.
Working Conditions:
- May be required to carry a cell phone and be available to respond during working and non-working hours.
- The successful candidate will be required to clear a drug screen and a complete background check, including credit report for certain positions, after an offer has been extended and prior to being employed.
- Occasional overnight travel may be required
Supervisory Responsibility:
- No direct supervisory responsibility is anticipated; however, this role may provide guidance, coordination, QA/QC, and mentoring to project team members, junior analysts, and stakeholders involved in the change management process.
PREFERRED EDUCATION, EXPERIENCE, CERTIFICATIONS, COMPETENCIES, SKILLS, & ABILITIES:
Above the minimum requirements; not required but advantageous in this position:
- Advanced degree from an accredited institution in Accounting, Business Administration, Finance, Data Analytics, Information Systems, Construction Management, Engineering, or a related discipline.
- Advanced Microsoft Excel skills, including Power Query, Power Pivot, data modeling, complex formulas, macros, or VBA.
- Advanced Power BI, Tableau, or similar dashboard development experience.
- Familiarity with Oracle ERP, Oracle Projects module, Oracle Primavera Cloud, Unifier, EcoSys, SAP, or similar project controls / ERP platforms.
- Experience building project controls dashboards that integrate cost, schedule, forecast, change management, risk, and portfolio data.
- Proficiency in Primavera P6, Microsoft Project, Oracle Primavera Cloud, or similar scheduling software.
- Working knowledge of data modeling, data governance, database concepts, SQL, ETL processes, and automated reporting workflows.
- Experience supporting midstream, energy, pipeline, processing, industrial, infrastructure, or large capital projects.
- Knowledge of project controls lifecycle processes, including estimating, budgeting, cost control, scheduling, change management, forecasting, cash flow, closeout, and lessons learned.
- Experience developing executive-level presentations and portfolio performance summaries.
- Professional certifications are preferred but not required, including:
- Microsoft Power BI Data Analyst certification.
- Tableau certification.
- AACE certification.
- PMI Project Management Professional.
- Data analytics, business intelligence, or project controls-related certifications.
Other responsibilities:
The above statements describe the general nature and level of work being performed. This position may perform other duties as assigned.
Tallgrass was named one of the Top Workplaces USA and highlighted in Colorado's Top Workplaces for the past seven consecutive years. Tallgrass is a leading energy infrastructure company focused on safely, reliably, and sustainably delivering the energy and services that power our nation and enable our quality of life.
At Tallgrass, we value our teams and strive to create an environment where employees feel respected, and their contributions are valued. We aim to support employees' physical, mental, and financial well-being through a comprehensive Total Rewards Program.
- Industry competitive pay
- Health insurance package options that include Flexible Spending & Health Savings Accounts
- Infertility Coverage
- Parental Leave
- 401(k) with up to a 6% match that vests immediately plus an employer discretionary contribution of up to 4%
- Wellness Programs and Mental Health Resources
- Employer-paid life insurance, short-term disability, and long-term disability coverage
- Critical Illness & Accident Insurance
- Vacation, sick days, paid caregiver leave, volunteer and bereavement paid time off
- Identity theft protection
- Annual discretionary bonus
- Generous Tuition Reimbursement Program
- Company-paid holidays and floating holidays
- Company vehicle (if applicable)
- Employee discounts; vehicles, tires, cellular plans, and more
- Networking and employee engagement events
- Personal development to grow your career with us based on your strengths and interests
Application Deadline: Recruiting timelines vary by position; however, all Tallgrass positions accept applications for at least five business days from the posting date. This position is open and still accepting applications.
Compensation: Compensation ranges are provided in good faith based on what we anticipate when researching wages for this position at the state and national levels. We may ultimately pay more or less than the posted range. This salary range may also be modified in the future.
Notice to External Search Firms: Tallgrass does not accept unsolicited resumes from search firms or employment agencies. Unsolicited referrals and resumes are considered Tallgrass property; therefore, Tallgrass will not pay a fee for any placement resulting from the receipt of an unsolicited referral. Approved vendors may be invited to refer talent for specific positions at Tallgrass's request only. A fully executed agreement with Tallgrass must be in place and current in these cases.
EEO Statement: Tallgrass complies with all Equal Employment Opportunity (EEO) affirmative action laws and regulations. Tallgrass does not discriminate on the basis of age, race, religion, color, sex, national origin, marital status, genetic information, sexual orientation, gender Identity and expression, disability, veteran status, pregnancy status, or other status protected by law.
