Business Intelligence Analyst

Pay Range: $50-60 per hr while on contract and 100-115K if converted. Pay DOE

Benefits: Medical, Dental, and Vision insurance, 401k, sick leave, and employee assistance program. Depending on your package selection, Averro offers PTO, paid holidays, and legal insurance.

Our advanced nuclear client is seeking to add a Contract Administrator to the team!

The Project Controls BI Analyst is responsible for developing, maintaining, and optimizing business intelligence reporting solutions that support Project Controls, PMO, Engineering, and Program Management teams. This role serves as the technical reporting expert for project planning, scheduling, cost tracking, forecasting, estimating, and performance analytics across complex programs and projects.

The ideal candidate combines strong technical expertise in Power BI, Power Query, and advanced Excel with an understanding of project controls and scheduling data. This role focuses heavily on transforming data from multiple disconnected systems into meaningful dashboards, reports, and actionable insights that support program and project leadership decision-making.

This position is highly data-centric and operates as a backend analytics and reporting function supporting enterprise project execution.

• Design, develop, and maintain interactive dashboards and reporting solutions using Power BI.
• Build reporting models and visualizations that support project planning, scheduling, forecasting, cost management, estimating, and performance tracking.
• Create executive-level dashboards, KPI scorecards, and operational reporting for program and project leadership.
• Translate complex project controls data into actionable insights and meaningful analytics.

• Utilize Power Query extensively to collect, clean, transform, validate, and consolidate data from multiple sources.
• Integrate and normalize large datasets from scheduling systems, cost tools, spreadsheets, flat files, and other disconnected data sources.
• Support data governance, data quality validation, and reporting accuracy initiatives.
• Partner with IT and business stakeholders to improve reporting architecture and data accessibility.

• Support Project Controls and PMO teams with reporting related to schedules, cost performance, forecasting, estimating, trends, and resource planning.
• Work with scheduling data from tools such as Primavera P6 and/or Microsoft Project.
• Develop reporting structures and analytics that support project performance monitoring and decision-making.
• Assist in identifying trends, risks, variances, and performance issues through data analysis.

• Perform advanced data validation and reconciliation using Excel.
• Develop complex formulas, logic checks, and data quality controls to ensure reporting accuracy.
• Analyze large datasets and troubleshoot inconsistencies across multiple reporting systems.
• VBA or automation experience is beneficial but not required.

• Support reporting automation and process improvement initiatives.
• Contribute to scalable BI and data warehouse strategies.
• Collaborate on cloud-based data platform initiatives, including Snowflake or similar technologies.
• Explore and incorporate AI-enabled analytics and business intelligence capabilities where applicable.

• Bachelor’s degree in STEM, Business, Analytics, Information Systems, Engineering, or related field.
• 5+ years of Business Intelligence, Data Analytics, or Reporting Analyst experience supporting Project Management, PMO, or Project Controls organizations.
• Advanced experience with Power BI, Power Query, Microsoft Excel (advanced formulas, data analysis, validation)
• Strong experience transforming and analyzing large datasets from multiple sources.
• Experience working with project scheduling and/or project controls data.
• Strong analytical, problem-solving, and communication skills.
• Ability to work effectively in fast-paced, high-growth environments with evolving priorities.
• Must qualify as a U.S. Person.

• Experience supporting engineering, construction, infrastructure, energy, aerospace, or other technical project-based industries.
• Experience working with Primavera P6 and/or Microsoft Project scheduling data.
• Familiarity with project controls concepts, including Scheduling, Cost tracking, Forecasting, Earned value management, Estimating
• Experience with enterprise-scale datasets and data warehouse environments involving millions of rows.
• Knowledge of cloud-based data platforms such as Snowflake.
• Exposure to AI-enabled analytics or AI-assisted business intelligence tools.
• Experience working in organizations without fully integrated ERP systems.
• VBA, SQL, or other data automation experience is a plus.

The ideal candidate is a highly technical BI Analyst who understands how project teams use schedule, cost, and forecasting data to manage large-scale programs. They are…