Energy Specialist

Job Title: Energy Specialist

Location: Orange CT

Work type: Office

The salary range for this position is dependent upon experience ranging from $87600 to $109500.

What We Offer:

• Competitive benefits and growth opportunities

• Generous performancebased bonuses

• 12% 401(k) match

• Comprehensive health dental and vision insurance

• Tuition reimbursement

• Professional development and clear careeradvancement pathways

For more information please visit: Benefits - Avangrid

Job Summary

The Energy Specialist position is an operational and support role in the Conservation and Load Management (C&LM) department. C&LM delivers high quality and cost-effective energy efficiency programs to natural gas and electricity customers in NY CT and MA. This position will be responsible for complex data analyses and business systems support. It will also support program data data analysis and information requests; regulatory filings support; advanced technical reporting; energy efficiency programs tracking tool (eTRACK); and develop and implement reports and dashboards leveraging available analytical tools.

The Energy Specialist role provides customers with money-saving solutions to help improve comfort and reduce energy bills. The incumbent will join our experienced team is implementing some of the most innovative energy efficiency programs in the United States. This role will be responsible for working in specialized business systems organizing very large and complex caches of data and data analysis. This includes being expected to run combine and/or disaggregate our available data to generate reports for various departments as well as externally to meet regulatory requirements.

The Energy Specialist will be responsible for refining our databases and reporting capabilities to function more efficiently. This includes supporting the implementation team by offering insights into how to best organize and format their databases. This position will also work on special projects requiring data entry cleaning and preparing data sets (usually in instances of unplanned data requests tight deadlines or periods where multiple project assignments overlap.

The Energy Specialist will be envisioned to help bolster the technical capabilities of the Conservation and Load Management team that works collaboratively to implement energy efficiency programs and community outreach supported by finance and procurement/functions. This role will support these various business groups in preparing reports and/or assistance with preparing and organizing data.

Responsibilities:

• Strong knowledge experience and demonstrated ability in data analysis including sourcing compiling and interpreting data performing data analysis on an advanced level and communicating and directing analysis output.

• Solicit review and analyze business data requirements tied to compliance and performance reporting.

• Compile large datasets clean and prepare data for analysis and reporting (e.g. identify missing data identify and correct data entry errors).

• Deliver intelligence & insights to end-users and key stakeholders through execution of the data visualization lifecycle.

• Create repeatable scalable processes for future source onboarding for data acquisition.

• Validate data model and asset solution with data owners and consumers

• Ensuring requests for accessing data meets the defined privacy security and compliance needs as set by data owners and based on regulatory and contractual requirements.

• Collaborate and communicate with business stakeholders to understand business needs pertaining to data data acquisition and data lifecycle database management and performance reporting and translate requirements into rational and logical data model needs.

• Promote and engage in a hard-working team culture including demonstrating a profound commitment towards reducing energy usage.

• Collaborate with business stakeholders and source system subject matter experts to identify and document source system attributes and map attributes to a common model.

• Demonstrate experience with IT project management concepts including identifying business objectives requirement gathering and experience with working in a project role on IT implementation and/or software project implementation.

• Provide operational support and system administration.

• Must be customer driven display initiative accept responsibility hold others accountable participate in and facilitate team effectiveness and think and act analytically.

• Use strong analytical skills to QAQC other peoples work and flag for errors anomalies etc.

• Troubleshoot issues within existing worksheets and databases.

Required Qualifications:

• Bachelors degree in Business IT Statistics Economics Mathematics or a related field of study and a minimum of five (5) plus years of relevant experience. An equivalent combination of education and experience may be considered.

• Relevant experience includes working Demand Side Management (DSM) systems and/or Customer Relationship Management (CRM) software.

• Proficiency with Microsoft Suite with advanced level skills in Excel.

• Strong knowledge experience and demonstrated ability in data analysis and database management.

• Experience with data collection and screening; Analyzing visualizing and reporting data; Attention to detail and proven analytical and problem-solving skills; Creating reports and dashboards for review.

• Effective interpersonal written and verbal communication and presentation skills.

Preferred Qualifications:

• Demonstrated ability to simultaneously manage multiple tasks while providing excellent customer service.

• Ability to maximize effectiveness by using time management territory management prioritization of work and effective utilization of all resources.

• Knowledge of energy efficiency engineering concepts related to measures and measure calculations (i.e. energy engineering formulas to calculate savings from measures that impact end uses such as lighting heating cooling refrigeration motors process).

• Technical experience in SAP Business Warehouse (BW) data pulling; using Structured Query Language (SQL); using Power BI Tableau or other data analytics/visualization software; and developing Microsoft Excel spreadsheets running queries in various systems and data gathering.

Competencies:

• Growth & Continuous Improvement

• Initiative & Change

• Focused on Results

• Customer Centric (internal and/or External)

• Communication

• Collaboration

• Leadership (people managers/leaders)

#LI-NB1
#LI-office

Company:

Mobility Information

Please note that any applicant who is not a citizen of the country of the vacancy will be subject to compliance with the applicable immigration requirements to legally work in that country.

At Avangrid we provide fair and equal employment and advancement opportunities for all employees and candidates regardless of race color religion national origin gender sexual orientation age marital status disability protected veteran status or any other status protected by federal state or local law.
If you are an individual with a disability or a disabled veteran who is unable to use our online tool to search for or to apply for jobs you may request a reasonable accommodation by contacting our People and Organization department at .

Avangrid employees may be assigned a system emergency role and in the event of a system emergency may be required to work outside of their regular schedule/job duties. This is applicable to employees that will work in Connecticut Maine Massachusetts and New York within Avangrid Network and Corporate functions. This does not include those that will work for Avangrid Power.

Avangrid employees may also be assigned a NERC Reliability Standards compliance role supporting Critical Infrastructure Protection (CIP) and/or Operations and Planning (O&P) responsibilities. This is applicable to employees that will work in electric transmission operations and cyber security business areas in Connecticut Maine Massachusetts and New York within Avangrid Network and Corporate business areas. NERC Reliability Standards compliance roles and responsibilities may include additional access protections training audit engagement and required evidence retention and will be communicated by the employees management.

Job Posting End Date: