Senior Business Intelligence Analyst - Team Lead

E2 Consulting Engineers•Las Vegas, NV

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 for a portfolio of electric utility projects. The role works with stakeholders across the organization and with clients to understand business processes, identify improvement opportunities, translate requirements into technical solutions, and deliver scalable, reliable reporting and analytics. The position provides technical guidance and day-to-day leadership to BI team members, manages BI solutions through their full lifecycle, and develops dashboards, reports, data models, integrations, automations, and analytical tools. It supports project and portfolio performance reporting, data quality and governance, recurring management reviews, and continuous improvement. The role also defines scope and implementation plans with stakeholders and prepares documentation and presentations to support solution adoption.

Requirements

Experience with data visualization and developing 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 within 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, quality assurance, user acceptance testing, release management, production, documentation, maintenance, and enhancement.
Manage 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.
Translate business requirements and process flows into scalable dashboards, reports, data models, automated workflows, and analytical tools.
Develop dashboards and reports tracking project controls metrics, including schedule, budget and cost performance, forecasts, milestones, progress, risks, and other KPIs.
Examine existing systems and 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.
Work with Oracle databases, Oracle Unifier, Primavera P6, financial systems, operational applications, and structured and semi-structured sources such as Excel and CSV files.
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.
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.