Senior Business Intelligence Analyst - Team Lead
- Compensation
- Not disclosed
- Location
- Las Vegas, NV, US
- Work setup
- Not specified
- Seniority
- Lead
- Employment
- Contract
- Experience
- 5+ years
- Category
- Data analytics
- Posted
Skills
Must have
- Experience with data visualization, developing dashboards, reports, and analytical tools using Power BI, Tableau, and/or Oracle.
- Experience with Oracle (analytics, custom BI publisher reports, databases, user-defined reports, and 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.
Nice to have
- 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.
Full description
About the Organization
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.
Overview
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.
Responsibilities
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.