Analyst III

Socket.dev; Westwood (MA); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

401(k)

Dental insurance

Health insurance

Life insurance

Vision Insurance

Short- Term Disability

PTO

Job summary

Socket.dev is seeking a data analyst to support the Technical Solutions team with data analysis for energy efficiency and decarbonization programs serving residential and commercial sectors. You will analyze project data, validate data quality, and translate findings into actionable insights.

Responsibilities include collaborating with stakeholders, performing profiling and trend analyses, and ensuring analyses align with energy engineering principles.

Qualifications

• Develop data analysis objectives from business needs and translate into data requirements.
• Ensure data quality and reliability for energy efficiency project datasets.
• Collaborate with technical and non-technical stakeholders to define measures and outcomes.

Responsibilities

• Partner with team members to understand analysis objectives and translate to data requirements.
• Perform hands-on energy efficiency data analysis (profiling, trends/outliers, reconciliation).
• Troubleshoot data quality issues and ensure results align with building science principles.
• Use SQL, Power BI and Excel to validate data and produce repeatable analyses.
• Communicate findings clearly to technical and non-technical audiences.

Skills

Data analysis

SQL querying

Power BI

Excel

Stakeholder communication

Tools

SQL

Power BI

Excel

Job description

Role and Scope of Position:This position will support the data analysis needs of Technical Solutions team in the areas of innovation, technical sales assistance, and program support related to Eversource energy efficiency and decarbonization programs that serve the residential, multifamily and commercial and industrial sectors. Responsibilities will include evaluation of data related to performance of new technologies, analyzing energy efficiency and decarbonization offer data, reviewing and summarizing project information, and helping to improve energy efficiency and decarbonization program offerings and tools related to the energy efficiency programs in Connecticut, Massachusetts, and New Hampshire. This role works in an environment that often requires the performance of multiple simultaneous activities, where competing deadlines need to be met, and work is performed under pressure while involving significant business commitments and results

Essential Functions:

• Partner with team members and relevant stakeholders to understand analysis objectives, processes, and decision needs; translate them into clear analytical and data requirements
• Perform hands-on energy efficiency and decarbonization project data analysis (profiling, trends/outliers, reconciliation) to support insights on energy efficiency production and market trends
• Troubleshoot and rectify energy efficiency project energy savings data quality issues ensuring results align with building science and energy engineering principles
• Triage energy efficiency project data analysis issues with technical evidence, isolate likely root cause, and help coordinate resolution with appropriate internal teams associated with energy efficiency offer.
• Use SQL (or equivalent querying), Power BI and Excel to validate data, reconcile results, and produce repeatable analysis for a project or measure portfolio
• Communicate findings clearly in written and verbal formats to technical and non-technical audiences;
• Help facilitate discussions to collaborate on energy efficiency/ decarbonization measure definitions, eligibility, engineering assumptions, and best practices to produce reasonable savings results
• Evaluate the data from field studies involving innovative energy efficiency and decarbonization technologies to influence their impact on programs offered by Eversource, both now and for future consideration

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Life insurance
• Vision Insurance
• Short- Term Disability
• PTO