W2 - Data Analyst

Location: New Brunswick, NJ (Onsite - Hybrid - 3 days in a week)

Responsibilities:

Job Description:

Data Analyst is a detail-oriented technical analyst position that reports to the Operations Manager. The Data Analyst will be a team-player, responsible for compiling, analyzing, tracking program data, and reporting program information for all Programs. Other responsibilities will include developing and analyzing reports for energy efficiency measures and program performance, leading development and review of program documents and tools, tracking and analyzing key performance indicators (KPIs), supporting program evaluation, update of program planning tools and developing forecast and projection reports for the client.

Qualifications:

• Minimum 2 years of experience working in program design and/or implementation for utility or state-funded efficiency/renewable energy programs
• Bachelor’s Degree in technical discipline, like Engineering, Data Analytics, Physics, Mathematics, etc.
• Advanced proficiency with Microsoft Office Suite; expert with MS Excel
• Experience coding with Microsoft Visual Basic or similar programming languages
• Experience with relational database systems preferred
• Experience working with state and federal energy codes and regulations
• Experience with program evaluation processes and procedures
• Demonstrated strong written and verbal communication and interpersonal skills
• Demonstrated strategic thinking skills
• Experience working with and analyzing large datasets
• Ability to multitask, submit deliverables promptly, and be proactive
• Ability to manage multiple tasks and work closely with other project team members
• Desire to develop existing and new skill sets in a collaborative, fast-paced environment
• Ability to write procedures and develop corresponding flow charts. Experience in Visio is a plus

Experience &

Education:

• Minimum 2 years of experience working in program design and/or implementation for utility or state-funded efficiency/renewable energy programs
• Bachelor’s Degree in a technical discipline, like Engineering, Data Analytics, Physics, Mathematics, etc.

Responsibilities:

• Perform policy research on energy efficiency codes and standards at the state and federal levels for both current and future codes
• Perform a wide range of analyses, including analysis of program and portfolio performance, measure-level performance, project-level performance, and program-level impacts
• Perform benefit-cost analysis on prospective energy efficiency measures and programs in accordance with the New Jersey State Protocols, the New Jersey Coordinated Measure list, and other appropriate standards and guidelines
• Justify and document technical decisions related to research planning and data analysis
• Report and present findings, as well as actionable recommendations, to the internal technical services team and potentially the utility client
• Collaborate with program management staff and clients to meet program information and reporting needs
• Lead the development of program documents, including applications and energy savings models, and all other documents required for participants to engage energy efficiency programs;
  Perform document reviews
• Track and analyze internal key performance indicators (KPIs) and prepare back up documents for the monthly invoices for the client; KPIs will include, but are not limited to, the following: completed projects or rebate applications, enrollments, committed funding, spent funding, estimated savings, number of participating trade allies, QC inspections/results (pass or fail), reporting accruals, explaining variances, etc.
• Develop and document data collection and tracking procedures as changes are made
• Supporting program evaluation procedures
• Develop energy-based assumptions using regression or other data mining and modeling techniques