The Analyst, External Reporting and Special Projects is a member of the Portfolio Management Office (PMO), supporting critical work streams and deliverables for project and stakeholder analysis and reporting. Their core responsibility is to support annual and ad hoc funder reporting and analysis needs as well as support data collection, analysis and valuation needs for new business development opportunities in energy efficiency and related areas.
The role works collaboratively with the Principal Portfolio Analyst and other analysts in the division to ensure that funders receive accurate and timely reporting on NEEA's work and supporting data integrity efforts. This includes providing funder-level analysis and related calculation structure and documentation, as well as preparing delivery messaging and materials. The Analyst will also provide key analytical support for emerging business areas.
We are looking for a detail-oriented and resourceful individual with strong analytical, organization and written communication skills, an ability to quickly learn the business and analytical structures, and a collaborative approach to supporting key divisional goals.
This position is based in the Portland, OR metro area, with a hybrid work location. We are looking for candidates who can meet the requirement of working at least 2 days per week onsite at NEEA’s office location. Finalists must have eligibility to work in the US as NEEA is not able to provide VISA sponsorship or have remote work outside of the US.
Salary range: $85,000 - $95,000, exempt
- Salary is based on the applicants Experience, Knowledge, Skills, and Abilities.
The Typical Day May Include…
- Align updates from key model assumptions with founder calculations and reforecast funder level estimates.
- Partner with Principal Portfolio Analyst to review key inputs needed to finalize funder level estimates and maintain action items and follow up with program analysts to ensure on time and accurate completion
- Review analytical and reporting frameworks and pull data from various sources (e.g., databases, tools) and populate funder reports.
- Audit calculation and reporting structures and verify the accuracy of report data, maintaining the integrity of funder reporting and related analyses. Design continuous improvements in data and tool structures to feed funder calculations.
- Create tools to provide visibility to forecast variances over time and gather corresponding variance explanations from program analysts.
- Coordinate inputs from the program analyst team to ensure data feeding the funder reports is ready. Document and follow up on outstanding action items
- Collaborate with corporate communications team to ensure messaging alignment.
- Compile data and memo components into a complete package for delivery to external stakeholders.
- Respond to ad hoc questions and requests from external stakeholders related to reporting and analysis.
- Organize and update the repository of reports on SharePoint and our Funder Portal, ensuring easy access and retrieval of historical and current funder reports.
- Participate in metrics development discussions for new business areas and support the data gathering to deliver on metrics reporting
- Assist with analytical tasks, data collection, and the development of tools to estimate energy system benefits and reporting for new opportunities.
Supervisory Responsibilities:
This position currently has no direct supervisory responsibilities.
What Are You Good At?
A top performer in the role of Analyst, External Reporting and Special Projects at NEEA would demonstrate exceptional proficiency in data organization, calculation structure and integrity, data analysis and detail orientation and documentation to ensure that all funder reports are accurate, timely, and tailored to meet the specific needs of NEEA's varied funding base. They would be adept at using advanced tools like MS Excel, Python, and Power BI to build and maintain robust analytical frameworks to support reporting needs, and would leverage their keen interpersonal skills to consistently partner cross functionally throughout the organization to uphold the quality of funder report content.
They would be highly organized, maintaining a well-structured repository of reports and documentation, and would be resourceful in adapting to new business requirements and special projects. Their ability to quickly learn and apply new business and analytical structures, combined with a collaborative approach, would make them an invaluable asset to the PMO and the broader NEEA team.
Your Experience, Education, and Skills:
- Bachelor's degree in Data Analytics, Energy Management, Economics, Business, Mathematics, Environmental Studies, or a related field.
- 3+ years of experience in a reporting or data analysis role, preferably in the energy efficiency sector, or comparable experience in an academic and/or professional setting.
- Experience in Demand Response or other Load Flexibility projects, or Building Performance Standards a plus
- Proficient in Microsoft tools: Microsoft Office Suite (Word, PowerPoint, SharePoint). - Advanced proficiency in MS Excel required.
- Experience with data analysis tools (such as Python, Power BI) and visualization tools (such as Tableau) a plus
- Strong communication skills, with focus on clear and effective report development and delivery to various levels of internal and external stakeholders
- Experience compiling and producing recurring reporting to external stakeholders, including adapting reports to meet the varied requirements of said stakeholders.
- Ability to source relevant data for these reports, compiling details from various sources and building cohesive analysis, documentation and deliverable.
- Ability to create and update clear documents, reflecting insights from reporting, stakeholder requests, etc. Additionally, exhibits exceptional organization strategies – maintaining documents in an orderly fashion and building methodologies to sort/filter to identify specific information quickly.
- Adaptability and flexibility to support teams with additional, ad hoc analytical needs as they arise.
- Bringing curiosity, resourcefulness, iterative and open approach to deliver clear and timely products.
- Adapting current business goals and reporting methods to new project requirements as needed.
Highlights of NEEA’s Benefits:
- 90% of medical/dental premiums paid by NEEA, including for dependents
- Employer funded Health Savings Account
- 136 hours of PTO/year
- Automatic 6% retirement contribution with an additional 2% matching
- Flexible work environment, including hybrid work location and 9/80 schedule options
- Professional development opportunities
About NEEA
The Northwest Energy Efficiency Alliance (NEEA) is an alliance of more than 140 electric and natural gas utilities and energy efficiency organizations working on behalf of Northwest energy consumers to increase the adoption of energy-efficient products services and practices. Since 1997, the region has achieved more than 959 average megawatts (aMW) of Co-Created electric energy savings – the equivalent of enough energy to power more than 700,000 Northwest homes each year.
NEEA welcomes individuals from all backgrounds and fields of expertise, with or without previous experience in the energy industry.
Follow this link to our website and learn more about the organization.
_
_
NEEA is an Equal Opportunity Employer