W2 only - Data Analyst

New York Technology Partners; New Brunswick (NJ); Hybrid; USD 70,000 - 95,000; Full time

Job summary

New York Technology Partners in New Brunswick, NJ (Onsite - Hybrid - 3 days per week) seeks a Data Analyst to compile, analyze, track program data, and report information for all Programs. You will develop reports for energy efficiency measures, lead document/tool development, track KPIs, and support program evaluation.

The role involves updating planning tools, forecasting reports for the client, and collaborating with project teams in a fast-paced environment to deliver timely deliverables.

Qualifications

• Minimum 2 years experience in program design/implementation for utility or state-funded energy programs.
• Bachelor’s degree in engineering, data analytics, physics, mathematics, or similar.
• Advanced proficiency with Microsoft Office; expert in MS Excel.
• Experience coding with Visual Basic or similar languages.
• Experience with relational databases.
• Familiar with energy codes and regulations.
• Experience with program evaluation processes.
• Strong written and verbal communication and interpersonal skills.
• Demonstrated strategic thinking and ability to analyze large datasets.
• Ability to multitask and work with project teams; Visio is a plus.

Responsibilities

• Perform policy research on energy efficiency codes and standards at state/federal levels.
• Analyze program and portfolio performance, KPI impacts.
• Perform benefit-cost analyses per NJ protocols and guidelines.
• Justify and document technical decisions related to research planning and data analysis.
• Report findings and actionable recommendations to internal teams and clients.
• Collaborate with program management to meet reporting needs.
• Lead development of program documents and energy savings models; review documents.
• Track KPIs and prepare backup documents for monthly invoices.
• Develop data collection and tracking procedures; support evaluation procedures.
• Develop energy-based assumptions using regression or data mining techniques.

Skills

MS Excel

Microsoft Office Suite

Visual Basic

Relational databases

Data analysis

KPI tracking

Communication skills

Strategic thinking

Large datasets

Multitasking

Visio

Education

Bachelor's Degree in technical discipline

Tools

Microsoft Visual Basic

Visio

Job description

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