What are the responsibilities and job description for the Business Intelligence Analyst position at Averro?
Location: Rockville, MD (Onsite)
Employment Type: Contract to Hire
Pay Range: $50-60 per hr while on contract and 100-115K if converted. Pay DOE (No C2C, No Sub-Vendors)
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.
*** Must be US Citizen or Green Card Holder
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.
Key Responsibilities
Business Intelligence & Reporting
1. Design, develop, and maintain interactive dashboards and reporting solutions using Power BI.
2. Build reporting models and visualizations that support project planning, scheduling, forecasting, cost management, estimating, and performance tracking.
3. Create executive-level dashboards, KPI scorecards, and operational reporting for program and project leadership.
4. Translate complex project controls data into actionable insights and meaningful analytics.
Data Transformation & Integration
- 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.
Project Controls & Scheduling Support
1. Support Project Controls and PMO teams with reporting related to schedules, cost performance, forecasting, estimating, trends, and resource planning.
2. Work with scheduling data from tools such as Primavera P6 and/or Microsoft Project.
3. Develop reporting structures and analytics that support project performance monitoring and decision-making.
4. Assist in identifying trends, risks, variances, and performance issues through data analysis.
Advanced Excel & Data Validation
1. Perform advanced data validation and reconciliation using Excel.
2. Develop complex formulas, logic checks, and data quality controls to ensure reporting accuracy.
3. Analyze large datasets and troubleshoot inconsistencies across multiple reporting systems.
4. VBA or automation experience is beneficial but not required.
Continuous Improvement & Innovation
1. Support reporting automation and process improvement initiatives.
2. Contribute to scalable BI and data warehouse strategies.
3. Collaborate on cloud-based data platform initiatives, including Snowflake or similar technologies.
4. Explore and incorporate AI-enabled analytics and business intelligence capabilities where applicable.
Minimum Qualifications
1. Bachelor’s degree in STEM, Business, Analytics, Information Systems, Engineering, or related field.
2. 5 years of Business Intelligence, Data Analytics, or Reporting Analyst experience supporting Project Management, PMO, or Project Controls organizations.
3. Advanced experience with Power BI, Power Query, Microsoft Excel (advanced formulas, data analysis, validation)
4. Strong experience transforming and analyzing large datasets from multiple sources.
5. Experience working with project scheduling and/or project controls data.
6. Strong analytical, problem-solving, and communication skills.
7. Ability to work effectively in fast-paced, high-growth environments with evolving priorities.
8. Must qualify as a U.S. Person.
Preferred Qualifications
1. Experience supporting engineering, construction, infrastructure, energy, aerospace, or other technical project-based industries.
2. Experience working with Primavera P6 and/or Microsoft Project scheduling data.
3. Familiarity with project controls concepts, including Scheduling, Cost tracking, Forecasting, Earned value management, Estimating
4. Experience with enterprise-scale datasets and data warehouse environments involving millions of rows.
5. Knowledge of cloud-based data platforms such as Snowflake.
6. Exposure to AI-enabled analytics or AI-assisted business intelligence tools.
7. Experience working in organizations without fully integrated ERP systems.
8. VBA, SQL, or other data automation experience is a plus.
WHY AVERRO?
Averro is a veteran-owned staffing and solutions firm connecting top talent with cutting-edge companies. With 20 years of experience and industry-specialized recruiters in your corner, we're here to propel your career forward.
Averro is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
View our privacy policy here: https://www.averro.com/legal/privacy-policy
Salary : $50 - $60