Analyst, External Reporting and Special Projects

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 de