Senior Business Intelligence Analyst - Team Lead

E2 Consulting Engineers, LP (E2) is a professional services firm established in 1988 specializing in a full spectrum of engineering services including, project engineering and design, federal base operations and infrastructure support services, gas pipeline construction and inspection services, environmental consulting and remediation, and information technology services. At E2, we value safety, innovation and collaboration, and we are dedicated to excellence.

E2 Consulting Engineers, LLP (E2) is seeking a Senior Business Intelligence Analyst / Team Lead to lead the full-cycle design, development, implementation, and ongoing enhancement of business intelligence, analytics, and project controls solutions supporting a portfolio of electric utility projects.

This individual will work closely with stakeholders across the organization to understand business processes, identify opportunities for improvement, translate business requirements into technical solutions, and deliver scalable, reliable, and actionable reporting and analytics capabilities, in a client facing capacity.

Business Intelligence Leadership & Solution Delivery

• Lead business intelligence and analytics initiatives from end to end, including initial discovery, and requirements gathering, through solution scoping and design, development, source control, data integration, QA/QC, user acceptance testing, release management, production, documentation, and ongoing maintenance & enhancement
• Manage ongoing maintenance, troubleshooting, upgrades, and enhancements to existing BI solutions as business needs and underlying systems evolve
• Provide technical guidance and day-to-day leadership to BI team members and collaborate with cross-functional technical resources as needed
• Translate business requirements and process flows into scalable technical solutions, including dashboards, reports, data models, automated workflows, and analytical tools.

Data Integration, Architecture & Analytics

• Develop dashboards and reports to monitor key project controls metrics, including schedule performance, budget and cost performance, forecasts, milestones, progress, risks, and other relevant key performance indicators (KPIs).
• Examine existing systems and develop scalable reporting processes; leveraging SQL queries, data extractions, models, transformations, validations, etc., integration processes, automations, and controls, to reduce manual reporting effort.
• Identify data quality issues, inconsistencies, gaps, and process inefficiencies; recommend and implement improvements to data integrity, standardization, and governance.
• Integrate and reconcile data from multiple enterprise sources to establish a centralized, consistent, and trusted source of truth for electric utility project and portfolio reporting.
• Work with Oracle databases, Oracle Unifier, Primavera P6, financial systems, operational applications, and structured and semi-structured data sources, including Excel and CSV files.

Project Controls & Portfolio Performance

• Recommend improvements to reporting methodologies, performance metrics, business processes, and management controls based on data-driven insights.
• Support recurring management reporting, portfolio reviews, ad hoc analyses, and special initiatives requiring data consolidation and analytical insights.

Stakeholder Engagement & Continuous Improvement

• Build working relationships with client personnel and cross-functional teams to clarify requirements, resolve issues, align solutions, promote collaboration, accountability, and continuous improvement.
• Communicate technical concepts, analytical findings, risks, and recommendations effectively to both technical and nontechnical audiences.
• Define project scope, deliverables, technical approaches, implementation plans, and acceptance criteria in collaboration with stakeholders.
• Monitor the effectiveness of deployed solutions and proactively identify opportunities for enhancements, automation, and improved user experience.
• Partner with cross-functional teams including: executive leadership, program and project managers, finance, project controls, and operations personnel to understand lifecycle processes, performance management practices, business objectives, existing workflows, reporting needs, and operational challenges.
• Prepare functional and technical documentation, process flows, data definitions, user guides, and presentations to support implementation and adoption.

• Experience with…