Senior Business Intelligence Analyst - Team Lead

E2 Consulting Engineers, LP•Reno, NV

3d•$100,000 - $125,000

About The Position

E2 Consulting Engineers, LP is seeking a Senior Business Intelligence Analyst / Team Lead to lead the design, development, implementation, and ongoing enhancement of business intelligence, analytics, and project controls solutions supporting electric utility projects. The role works with organizational and client stakeholders to understand business processes, identify improvement opportunities, translate business requirements into technical solutions, and deliver scalable, reliable reporting and analytics capabilities. The position leads BI solutions through discovery, requirements gathering, scoping, design, development, data integration, quality assurance, user acceptance testing, release, documentation, production support, maintenance, and enhancement. It provides technical guidance and day-to-day leadership to BI team members, and supports project controls and portfolio reporting through dashboards, reports, data models, automated workflows, and analytical tools. The analyst integrates and reconciles data from enterprise systems and structured or semi-structured sources to establish trusted reporting data. Relevant systems include Oracle databases, Oracle Unifier, Primavera P6, financial systems, operational applications, Excel, and CSV files. The role also supports recurring management reporting, portfolio reviews, ad hoc analysis, stakeholder engagement, documentation, and continuous improvement. Travel is listed as 10%, and the posting specifies local candidates only.

Requirements

Experience developing data visualizations, dashboards, reports, and analytical tools using Power BI, Tableau, and/or Oracle.
Experience with Oracle databases and Oracle Unifier.
Experience with Primavera P6.
Experience working with structured and semi-structured data sources, including Excel and CSV files.
Experience gathering business requirements, defining technical solutions, conducting testing and quality control, and supporting production deployments.
Proficiency with Microsoft applications, including Microsoft Excel.
Bachelor’s degree in Information Systems, Computer Science, Engineering, Business Analytics, Data Analytics, Finance, or a related field, or equivalent relevant experience.
At least 5 years of experience in business intelligence, data analytics, data engineering, or a related analytical or technical role.

Nice To Haves

Experience in the electric utility, energy, construction, engineering, or capital project delivery industries.
Oracle Certified Professional (OCP) certification or other relevant Oracle certifications.
Experience integrating data from enterprise applications, project management systems, financial platforms, and flat-file sources.
Experience with ETL/ELT processes, data modeling, data validation, and data quality management.
Experience with Python or VBA.
Familiarity with project management and collaboration platforms such as Procore, SharePoint, or Smartsheet.

Responsibilities

Lead BI and analytics initiatives from discovery and requirements gathering through scoping, design, development, source control, data integration, QA/QC, user acceptance testing, release management, production, documentation, maintenance, and enhancement.
Maintain, troubleshoot, upgrade, and enhance 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.
Translate business requirements and process flows into scalable dashboards, reports, data models, automated workflows, and analytical tools.
Develop dashboards and reports for project controls metrics, including schedule, budget and cost performance, forecasts, milestones, progress, risks, and other KPIs.
Develop scalable reporting processes using SQL queries, data extractions, models, transformations, validations, integrations, 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 source of truth for electric utility project and portfolio reporting.
Recommend data-driven improvements to reporting methodologies, performance metrics, business processes, and management controls.
Support recurring management reporting, portfolio reviews, ad hoc analyses, and special initiatives requiring data consolidation and analytical insights.
Build relationships with client personnel and cross-functional teams to clarify requirements, resolve issues, align solutions, and promote collaboration, accountability, and continuous improvement.
Communicate technical concepts, analytical findings, risks, and recommendations to technical and nontechnical audiences.
Define project scope, deliverables, technical approaches, implementation plans, and acceptance criteria with stakeholders.
Monitor deployed solutions and identify opportunities for enhancements, automation, and improved user experience.
Partner with executive leadership, program and project managers, finance, project controls, and operations personnel to understand processes, objectives, workflows, reporting needs, and operational challenges.
Prepare functional and technical documentation, process flows, data definitions, user guides, and presentations to support implementation and adoption.