Sr. Reporting & Visualization Lead

consertus; Austin (TX); Presencial; USD 120.000 - 150.000; Jornada completa

Descripción de la vacante

Consertus in Austin, TX is seeking a Reporting Visualization Lead who translates project and program data into clear, accurate reporting to support executives on a large aviation capital program. The role bridges project management, project controls, and the digital team, requiring on-site support in Austin and a strong Excel background.

Power BI experience is a plus, and mentorship is available for right candidate.

Formación

• Advanced Excel skills with complex formulas, lookups, pivots, and modeling.
• Experience in project performance or data reporting within a PM delivery environment.
• Capital project delivery experience; aviation or public infrastructure a plus.
• Familiarity with project controls concepts: budgets, forecasting, change exposure, and schedule performance.

Responsabilidades

• Develop and maintain program and project performance reporting on cost, schedule, risk and delivery workflows.
• Design, build, and improve dashboards and reports in Excel and Power BI with branding.
• Validate reported data against source systems (Procore, Primavera P6) and investigate inconsistencies.
• Collaborate with program leaders and stakeholders to understand needs and drive data-driven decisions.

Conocimientos

Advanced Microsoft Excel skills

Project performance reporting

Capital project delivery experience

Data validation & governance

Power BI

Herramientas

Procore

Primavera P6

Power BI

Descripción del empleo

About Us:

Consertus is an AI-native global capital program management and advisory firm that combines deep industry expertise with advanced digital capabilities to deliver smarter, faster, and more sustainable outcomes. Headquartered in Miami, Florida, and supported by a team of more than 1,500 professionals, we help clients plan, deliver, and optimize complex capital programs across the full project lifecycle.

Our integrated capabilities span advisory, digital solutions, engineering and design, and program delivery, enabling organizations to navigate complexity, mitigate risk, and achieve strategic objectives. We serve a diverse range of industries, including aviation, transportation, transit, water, healthcare, energy, education, government, commercial real estate, life sciences, and technology.

At Consertus, we believe our people are our greatest strength. We foster a collaborative, flexible, and inclusive environment where individuals can grow, develop their skills, and make a meaningful impact. Together, we're transforming the way the world is planned, built, and delivered.

Learn more about how Consertus is creating lasting value for clients, communities, and our people at www.consertus.com .

About this Role:

The Reporting Visualization Lead turns project and program data into clear, accurate reporting that helps leaders make better decisions on a large aviation capital program. This person bridges project management, project controls, and the digital team, and works closely with program leaders, program directors, project managers (PMs), construction managers (CMs), and stakeholders to understand what they need to know and why. The role requires on-site support in Austin, Texas.

This is not a traditional data analyst role. We are looking for someone who understands how capital projects are delivered first, and data second: a person with strong Excel skills and a track record in project performance reporting. Power BI experience is a plus but not required; training and mentorship are available for the right candidate.

Key Responsibilities:

• Project Performance Reporting
  • 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.
  • Identify leading indicators of cost exposure, schedule delay, and process bottlenecks (for example, RFIs, submittals, change orders, and approvals).
  • Provide both executive-level summaries and project-level detail, so users can move from the program view down to individual items.
  • Question reporting requests when the proposed metric does not answer the underlying business question.
• Dashboards and Visualization
  • Design, build, and improve dashboards and reports in Excel and Power BI, applying consistent standards and program branding.
  • Lead the visual design of program reporting so information is easy to read, consistent, and fit for its audience.
  • Prioritize accuracy, usability, and decision value over report volume or visual complexity.
  • Prepare reporting content for governance, leadership, and stakeholder meetings.
• Data Validation and Digital Team Collaboration
  • Serve as the functional liaison between project teams and the digital and data teams.
  • Define business requirements for data sources, integration, and reporting structures.
  • Validate reported data against source systems (such as Procore, Primavera P6, and the owner's financial management system) and investigate inconsistencies.
  • Contribute to KPI definitions, data governance, and reporting standards.
  • Recommend improvements to source-system setup and data entry practices that improve reporting quality.
  • Dedicated digital resources support data integration and infrastructure; this role is not expected to build or maintain those on its own.
• Stakeholder Collaboration and Continuous Improvement
  • Work with program leaders, program directors, PMs, CMs, and stakeholders to understand how reporting is used and what decisions it supports.
  • Review existing reports for gaps, redundancies, and misleading metrics, and retire reports that no longer add value.
  • Anticipate reporting needs as projects move through their lifecycle and as priorities change.
  • Reduce manual reporting effort and build confidence in program data.
  • Champion data-driven decision-making across program and project teams.

Qualifications/Requirements:

• Advanced Microsoft Excel skills (essential): 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 (essential).
• Capital project delivery experience, whether with an owner capital program, a contractor, or a designer; aviation or public infrastructure experience is a plus.
• Working knowledge of project controls concepts: budgets, forecasting (EAC), change exposure, contingency, and schedule performance.
• E