Capital Programs Reporting & Visualization Lead

Consertus-US; Austin (TX); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Health coverage

Life and disability insurance

Pet insurance (optional)

Legal services

Supplemental health plans

401(k) with company match

Paid time off

Consertus Academy

Job summary

Consertus seeks a Reporting Visualization Lead to translate aviation capital program data into clear, actionable reports. You will bridge project controls, PM, and the digital team, delivering executive summaries and project-level detail from Austin.

The role emphasizes strong Excel skills, with Power BI as a plus, and requires on-site presence in Austin. Training and mentorship are available for the right candidate.

Qualifications

• Advanced Microsoft Excel skills: complex formulas, lookups, pivot tables, data cleanup, and analytical models.
• Demonstrated experience in project performance or data reporting within a project management or project delivery environment.
• Capital project delivery experience; aviation or public infrastructure experience is a plus.
• Working knowledge of project controls concepts: budgets, forecasting (EAC), change exposure, contingency, and schedule performance.
• Experience with project management systems such as Procore, Autodesk Construction Cloud, or Primavera P6.
• Power BI, Power Query, or DAX experience is a plus; aptitude and willingness to learn is required.
• Bachelor’s degree in construction management, engineering, business, data analytics, or a related field, or equivalent experience.

Responsibilities

• Develop and maintain program and project performance reporting on cost, schedule, change, risk, and delivery workflows.
• Translate project controls processes and leadership questions into meaningful metrics, KPIs, and exception-based reporting.
• Provide executive-level summaries and project-level detail for governance and leadership meetings.
• Lead the visual design of program reporting to ensure readability, consistency, and audience-fit.

Skills

Advanced Excel

Project performance reporting

Capital project delivery

Project controls

Procore/Primavera P6

Education

Bachelors in CM

Tools

Procore

Autodesk Construction Cloud

Primavera P6

Job description

Consertus seeks a Reporting Visualization Lead to translate aviation capital program data into clear, actionable reports. You will bridge project controls, PM, and the digital team, delivering executive summaries and project-level detail from Austin.

The role emphasizes strong Excel skills, with Power BI as a plus, and requires on-site presence in Austin. Training and mentorship are available for the right candidate.