Sr. Reporting & Visualization Lead

Consertus, Inc.; Austin (TX); Hybrid; USD 90,000 - 140,000; Full time

Benefits offered by this job

Health coverage (medical, dental, and视

Life and disability insurance

Pet insurance

Legal services

401(k) with company match

PTO & holidays

Job summary

Consertus, Inc. is seeking a Sr. Reporting & Visualization Lead to translate project data into clear reporting for aviation capital programs. The role bridges project controls, PM delivery, and the digital team, requiring strong Excel skills and a track record in performance reporting.

The ideal candidate will design dashboards in Excel and Power BI, collaborate with program leadership, and ensure data accuracy from systems like Procore or Primavera P6. On-site in Austin, TX.

Qualifications

• Advanced Excel skills (complex formulas, lookups, pivots)
• Experience in project performance reporting within PM delivery
• Capital project delivery experience; aviation/public infrastructure a plus
• Knowledge of budgets, forecasting (EAC), change exposure, contingency
• Experience with Procore, Autodesk Construction Cloud or Primavera P6
• Power BI experience is a plus; willingness to learn
• Bachelor’s degree in CM/Engineering/Business/Data analytics or related field

Responsibilities

• Develop and maintain program and project performance reporting on cost, schedule, change, risk, and delivery workflows.
• Translate controls processes into metrics, KPIs, and exception-based reporting.
• Provide executive and project-level summaries and drill-down detail.
• Design and maintain dashboards and reports in Excel and Power BI with consistent branding.
• Collaborate with digital and data teams; validate data against source systems.”
• Guide KPI definitions, data governance, and reporting standards.

Skills

Excel advanced

Project reporting

Capital projects

Budget forecasting

Project controls

Power BI

Procore/Primavera

Education

Bachelor's degree

Tools

Procore

Autodesk Construction Cloud

Primavera P6

Job description

## Sr. Reporting & Visualization LeadApply: US-TX-Austin: US-TX-Austin Airport: Full time: Posted Today: JR1673**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.* 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. **Additional Requirements / Skills / Working Hours*** **On-site** support required in **Austin, Texas*** Project sense: recognizes when the numbers do not match what is happening on the project.* Analytical curiosity: investigates the why behind trends and discrepancies.* Proactive: anticipates the next question and builds the answer before it is asked.* Clear communication with executives, PMs, CMs, controls staff, and technical developers.* Ownership of reporting accuracy, relevance, and usefulness, with eagerness to keep learning.**What's In It For You:*** Comprehensive health coverage (medical, dental, and vision)* Company-paid life and disability insurance* Optional benefits like pet insurance, legal, and supplemental health plans* 401(k) with day-one eligibility, 3% safe harbor, plus up to 2.5% company match* Generous time off: 10 paid holidays and PTO starting at 15 days, growing up to 25* Access to Consertus Academy for continuous learning and development **Equal Employment Opportunity Statement:***Consertus is proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We welcome applicants from all backgrounds and identities, and we do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability, age, veteran status, or any other protected status.*