Senior Technical Specialist

Senior Technical SpecialistThe Senior Technical Specialist will support our demand-side management teams on the delivery of energy efficiency and electrification programs in Southern California. The Senior Technical Specialist will work closely with a cross-functional team including program implementation, operations, IT, engineering, and reporting personnel. This position will actively participate in client and management level reporting, including leading presentations to clients and management. The position also supports the more detailed CPUC reporting requirements as directed by program and/or engineering groups and is critical in assisting the administration of energy efficiency and electrification programs.What you will do:Develop common reporting templates that leverage varying data to create uniform results for regular and ad hoc reporting needsCollect energy efficiency / electrification reporting and KPI data from multiple stakeholders in varying formatsCompile data into common reporting templatesPresent formal reports to internal and client facing senior managementTrack and support recurring energy measure calculation updatesHelp maintain program databases, incorporating fixes and enhancements and performing periodic reviews for data consistency and accuracyReview reports and presentations by third partiesAssist with the interpretation and implementation of client and regulatory guidance related to reportingContribute to and coordinate responses to data requests from third-party evaluators and support internal data requestsWork with other stakeholders to support CPUC level reporting including compiling data, generating reports and submitting the reportsTravel Requirements: Minimal travel in the Los Angeles, CA metro area up to 10% of the time for meetings and eventsWhat we need you to have (minimum qualifications):Bachelor's Degree in Engineering, Physical Sciences, Computer Science, Statistics, Business Administration, Economics, Energy, Environmental Studies or related subjects (or applicants can substitute one year of related experience for one year of education)4+ years experience with program tracking, reporting and presenting KPI data to senior managementWhat we would like you to have (preferred skills):Master's Degree in Engineering, Physical Sciences, Computer Science, Statistics, MBA, Economics, Energy, Environmental Studies or related subjectsExperience in the utility or energy industry and knowledge of energy efficiency measures and technologyUnderstanding of programs promoting Demand Side Management, Energy Efficiency, Electrification and Demand ResponseKnowledge of sustainable building practices and technologiesDemonstrated familiarity with California deemed and custom project requirementsDemonstrated familiarity with CEDARS reporting systemDemonstrated familiarity developing and writing code with scripting and programming languages such as Python, VBA, R, and /or SQLFamiliarity with using the eTRM or other TRMsExperience creating Power BI dashboards and/or developing advanced MS Excel workbooks using macros, VBA code and complex data structures to generate reportsDemonstrated experience using relational databases such as SalesforceProfessional skills you will use:Microsoft certificate(s) including: Microsoft Office Specialist, Microsoft Excel Expert, Microsoft PowerPoint Associate, Microsoft PowerBI Certificate and/or Microsoft PowerBi Data Analyst CertificateStrong organizational skills with the ability to prioritize work and exercise independent judgmentExcellent problem-solving skills with the ability to analyze situations, identify existing or potential problems, and recommend solutionsExcellent written and oral communication skills with the ability to carry out oral and written instructions thoroughlyAbility to engage with multiple stakeholders in both public and private settings and negotiate outcomesSound business ethics, including the protection of proprietary and confidential informationInterpersonal skills including courtesy, professionalism, and a cooperative attitude ICF