Senior Business Intelligence Analyst - Team Lead

E2 Consulting Engineers, LP•Las Vegas, 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 full-cycle design, development, implementation, and ongoing enhancement of business intelligence, analytics, and project controls solutions supporting electric utility projects. The role works with organizational stakeholders in a client-facing capacity 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 initiatives from discovery and requirements gathering through solution design, development, data integration, quality assurance, user acceptance testing, release management, production support, documentation, maintenance, and enhancement. It provides technical guidance to BI team members and collaborates with technical and business partners. The role develops project controls reporting and analytics, integrates data across enterprise systems, supports portfolio and management reporting, and recommends improvements based on data-driven insights. The analyst partners with executive leadership, program and project managers, finance, project controls, operations, client personnel, and cross-functional teams. The role defines scope, deliverables, technical approaches, implementation plans, and acceptance criteria; communicates findings and recommendations; and prepares documentation and materials to support solution adoption. Travel is 10%, and the posting specifies local candidates only. Salary range is $100,000–$125,000, commensurate with skill, education, experience, and working environment.

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 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 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 design, development, integration, testing, release, production support, documentation, maintenance, and enhancement.
Manage troubleshooting, upgrades, maintenance, and enhancements to existing BI solutions as business needs and 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 dashboards, reports, data models, automated workflows, and analytical tools.
Develop dashboards and reports for project controls metrics, including schedule, budget, cost, 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, and implement improvements to data integrity, standardization, and governance.
Integrate and reconcile data from multiple enterprise sources to establish a consistent source of truth for electric utility project and portfolio reporting.
Recommend improvements to reporting methodologies, performance metrics, business processes, and management controls using data-driven insights.
Support recurring management reporting, portfolio reviews, ad hoc analyses, and special initiatives requiring data consolidation and analytical insights.
Build working 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.