Senior Business Intelligence Analyst - Team Lead

Summary

Senior Business Intelligence Analyst / Team LeadE2 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.ResponsibilitiesBusiness Intelligence Leadership & Solution DeliveryLead 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 & enhancementManage ongoing maintenance, troubleshooting, upgrades, and enhancements to existing BI solutions as business needs and underlying systems evolveProvide technical guidance and day-to-day leadership to BI team members and collaborate with cross-functional technical resources as neededTranslate business requirements and process flows into scalable technical solutions, including dashboards, reports, data models, automated workflows, and analytical tools.Data Integration, Architecture & AnalyticsDevelop 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 PerformanceRecommend 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 ImprovementBuild 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.QualificationsExperience with data visualization, developing dashboards, reports, and analytical tools using Power BI, Tableau, and/or Oracle.Experience with Oracle databases, 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.Education & ExperienceBachelor's degree in Information Systems, Computer Science, Engineering, Business Analytics, Data Analytics, Finance, or a related field, or equivalent relevant experience.5+ years of experience in business intelligence, data analytics, data engineering, or a related analytical or technical role.Preferred QualificationsExperience 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.BenefitsE2 Consulting Engineers, LP offers an excellent benefits package including health, dental, vision, and life insurance, 401(k) with employer match, paid time off.Wage Data Per State RequirementsSalary range for this position is $100,000 - $125,000. The starting salary will be commensurate with skill, education, experience, and working environment.Travel10%Local Candidates OnlyYesDrug Free WorkplaceE2 Consulting Engineers, LP is a Drug Free Workplace. After accepting an offer of employment, applicants may be required to undergo background checks, drug testing, and/or fit-for-duty physical examination. Drug screens will include, but not be limited to, Amphetamines, Cocaine Metabolites, Marijuana Metabolites (THC), Opiates, and Phencyclidine (PCP). As a federal contractor, E2 cannot permit employees in certain positions to use medical marijuana, even if prescribed by an authorized physician.SolicitationPlease no solicitation of any kind from agencies, staffing, or recruiting firms.EEO StatementAll qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Job Description

Senior Business Intelligence Analyst / Team LeadE2 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.ResponsibilitiesBusiness Intelligence Leadership & Solution DeliveryLead 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 & enhancementManage ongoing maintenance, troubleshooting, upgrades, and enhancements to existing BI solutions as business needs and underlying systems evolveProvide technical guidance and day-to-day leadership to BI team members and collaborate with cross-functional technical resources as neededTranslate business requirements and process flows into scalable technical solutions, including dashboards, reports, data models, automated workflows, and analytical tools.Data Integration, Architecture & AnalyticsDevelop 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 PerformanceRecommend 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 ImprovementBuild 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.QualificationsExperience with data visualization, developing dashboards, reports, and analytical tools using Power BI, Tableau, and/or Oracle.Experience with Oracle databases, 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.Education & ExperienceBachelor's degree in Information Systems, Computer Science, Engineering, Business Analytics, Data Analytics, Finance, or a related field, or equivalent relevant experience.5+ years of experience in business intelligence, data analytics, data engineering, or a related analytical or technical role.Preferred QualificationsExperience 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.BenefitsE2 Consulting Engineers, LP offers an excellent benefits package including health, dental, vision, and life insurance, 401(k) with employer match, paid time off.Wage Data Per State RequirementsSalary range for this position is $100,000 - $125,000. The starting salary will be commensurate with skill, education, experience, and working environment.Travel10%Local Candidates OnlyYesDrug Free WorkplaceE2 Consulting Engineers, LP is a Drug Free Workplace. After accepting an offer of employment, applicants may be required to undergo background checks, drug testing, and/or fit-for-duty physical examination. Drug screens will include, but not be limited to, Amphetamines, Cocaine Metabolites, Marijuana Metabolites (THC), Opiates, and Phencyclidine (PCP). As a federal contractor, E2 cannot permit employees in certain positions to use medical marijuana, even if prescribed by an authorized physician.SolicitationPlease no solicitation of any kind from agencies, staffing, or recruiting firms.EEO StatementAll qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.