Senior Technical Specialist

LearnETRM; Los Angeles, Northern (CA, KY); Hybrid; USD 81,000 - 138,000; Full time

Benefits offered by this job

Flexible work arrangements

Donation matching

Tuition reimbursement

401k matching

Employee stock purchase plan

Professional development

Job summary

ICF is seeking a Senior Technical Specialist to support demand-side management programs in California. You will collaborate with program implementation, operations, IT, engineering, and reporting teams to deliver regular and ad hoc KPI reporting and client-facing presentations.

Strong data reporting, Power BI, and Excel (VBA) skills are required, with experience in CPUC reporting and working knowledge of energy efficiency measures. Some travel within the LA metro area is expected.

Qualifications

• Bachelor’s Degree in Engineering or related field; 4+ years experience in program tracking, reporting and KPI presentation
• Knowledge of energy efficiency measures and demand-side management concepts
• Experience with data reporting to senior management and client-facing stakeholders
• Familiarity with California deemed and custom project requirements and regulatory reporting

Responsibilities

• Develop common reporting templates using varying data for regular and ad hoc reports
• Collect energy efficiency and electrification KPI data from multiple stakeholders
• Compile data into standard reporting templates and present to senior management
• Track and support recurring energy measure calculation updates
• Maintain program databases, perform data integrity checks and updates
• Assist with CPUC level reporting and third-party data requests
• Create Power BI dashboards and advanced Excel workbooks for reporting

Skills

Power BI dashboards

Excel (VBA)

SQL

Python

R

Data analysis

Stakeholder management

Report writing/presentation

Education

Bachelor’s Degree in Engineering or related field

Master’s Degree in Engineering or related field (preferred)

Tools

eTRM

TRMs

Salesforce

CEDARS

Power BI

MS Excel

Job description

**Senior Technical Specialist****Location – CA Remote (Los Angeles Metro Area)**The **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.**Why you will love working here:*** **Quality of life:** Flexible workplace arrangements, work-life balance* **Investment in the community:** Donation matching, volunteer opportunities* **Investment in you:** Tuition reimbursement, access to professional development resources, 401k matching, Employee Stock Purchase Plan* **And many, many more** (Ask your recruiter for more details!)**What you will do:*** Develop common reporting templates that leverage varying data to create uniform results for regular and ad hoc reporting needs* Collect energy efficiency / electrification reporting and KPI data from multiple stakeholders in varying formats* Compile data into common reporting templates* Present formal reports to internal and client facing senior management* Track and support recurring energy measure calculation updates* Help maintain program databases, incorporating fixes and enhancements and performing periodic reviews for data consistency and accuracy* Review reports and presentations by third parties* Assist with the interpretation and implementation of client and regulatory guidance related to reporting* Contribute to and coordinate responses to data requests from third-party evaluators and support internal data requests* Work with other stakeholders to support CPUC level reporting including compiling data, generating reports and submitting the reports* **Travel Requirements:** Minimal travel in the Los Angeles, CA metro area up to 10% of the time for meetings and events**What 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 management**What 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 subjects* Experience in the utility or energy industry and knowledge of energy efficiency measures and technology* Understanding of programs promoting Demand Side Management, Energy Efficiency, Electrification and Demand Response* Knowledge of sustainable building practices and technologies* Demonstrated familiarity with California deemed and custom project requirements* Demonstrated familiarity with CEDARS reporting system* Demonstrated familiarity developing and writing code with scripting and programming languages such as Python, VBA, R, and /or SQL* Familiarity with using the eTRM or other TRMs* Experience creating Power BI dashboards and/or developing advanced MS Excel workbooks using macros, VBA code and complex data structures to generate reports* Demonstrated experience using relational databases such as Salesforce**Professional 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 Certificate* Strong organizational skills with the ability to prioritize work and exercise independent judgment* Excellent problem-solving skills with the ability to analyze situations, identify existing or potential problems, and recommend solutions* Excellent written and oral communication skills with the ability to carry out oral and written instructions thoroughly* Ability to engage with multiple stakeholders in both public and private settings and negotiate outcomes* Sound business ethics, including the protection of proprietary and confidential information* Interpersonal skills including courtesy, professionalism, and a cooperative attitude**Bot and Third-Party Applications**Please note that this application must be submitted directly by the applicant for consideration. Failure to do so may result in the application being excluded for consideration. Applicants needing an accommodation for disability or religious purposes in connection with the application process should contact [e-mail] for assistance.**Working at ICF**ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future.We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO policy.We will consider for employment qualified applicants with arrest and conviction records.Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation, please email [e-mail] and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.Read more about workplace discrimination rights or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act.**Candidate AI Usage Policy**At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process.However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at [e-mail]. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.**Pay Range** - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position.The pay range for this position based on full-time employment is:$81,147.00 - $137,949.00California Remote Office (CA99)