SoRI- Data & Program Analyst

Data & Program Analyst

Rhode Island Office of Energy Resources (OER) - Clean Transportation & Climate Programs

Position Summary

The Rhode Island Office of Energy Resources (OER) is seeking a highly motivated, detail
oriented, and tech-savvy Data & Program Analyst to support statewide clean energy andclean transportation initiatives.
The ideal candidate will be highly detail-oriented, tech-savvy, and comfortable balancing
technical data analysis responsibilities with customer-facing program support.
This position will play a critical role in supporting OER's rebate and incentive programs
through data analysis, dashboard development, application processing, reporting,
auditing, and applicant support. The candidate will possess strong technical and analytical
skills, advanced experience with Excel and Tableau, exceptional attention to detail, and the
ability to communicate effectively with both internal teams and program participants.
This role will support multiple programs across OER, including transportation
electrification, energy efficiency, and thermal energy initiatives.

Key Responsibilities

• Develop, maintain, and update dashboards and reporting tools for OER programs using Tableau, Excel, and other data visualization platforms.
• Analyze program performance metrics (KPIs) and prepare monthly, quarterly, and annual reports.
• Monitor program spending, funding allocations, and incentive utilization trends.
• Track and analyze participation data across multiple programs and demographic categories.
• Prepare reports, presentations, narratives, and briefing materials for internal leadership, external partners, and legislative reporting.
• Assist with data collection, validation, and quality assurance processes.
• Clean, organize, and maintain datasets from multiple internal and external sources.

Technical & Systems Support

• Serve as a cross-office resource for data analysis, dashboard development, workflow improvements, and administrative streamlining.
• Build and maintain advanced Excel spreadsheets, models, pivot tables, and reporting tools.
• Utilize Tableau and other visualization software to create user-friendly dashboards and analytics tools.
• Assist with automating repetitive reporting and data management tasks.
• Support data tracking and reporting requirements for federal and state-funded programs.
• Troubleshoot data inconsistencies and identify opportunities for operational improvements.

Program Operations & Rebate Support

• Process and review rebate and incentive program applications for completeness and accuracy.
• Communicate with applicants regarding approvals, denials, missing documentation, and general program inquiries.
• Provide customer support to program participants and address applicant concerns professionally and efficiently.
• Conduct regular auditing and compliance reviews of program applications and supporting documentation.
• Maintain accurate program records and ensure consistency across databases and reporting systems.
• Support implementation and administration of state and federally funded clean transportation and clean energy programs.

Collaboration & Coordination

• Participate in weekly and monthly meetings with program implementers, vendors, and external partners.
• Coordinate with internal OER staff and external stakeholders to support reporting, budgeting, and program implementation efforts.
• Assist with presentations, program materials, and public-facing communications when needed.

Desired Skills & Experience

• Advanced Microsoft Excel skills required, including:
  o Pivot tables and pivot charts
  o XLOOKUP, INDEX/MATCH, nested formulas
  o Data validation and large dataset management
  o Dashboard and report creation
• Experience with Tableau required.
• Strong analytical, auditing, and problem-solving skills.
• Exceptional attention to detail and organizational skills.
• Ability to manage multiple projects and deadlines simultaneously.
• Strong written and verbal communication skills.
• Ability to explain data and findings to non-technical audiences.
• Experience working with rebate, grant, or incentive programs preferred.
• Experience with customer service or applicant communications preferred.
• Experience with data automation, reporting tools, or workflow optimization is a plus.

Required Qualifications

• Bachelor's degree in Data Analytics, Statistics, Business, Finance, Public Administration, Information Systems, or a related field.
• 2-5 years of experience in data analytics, program administration, reporting, or a related role.
• Demonstrated experience working with data visualization and reporting tools.
• Strong proficiency in Microsoft Office Suite, particularly Excel.
• Experience handling sensitive or high-volume data with accuracy and confidentiality.