Program Reporting & Analytics Analyst – MDEA

Responsibilities

• Design, build, and maintain the reporting infrastructure used to manage utility energy efficiency programs.
• Develop recurring dashboards, scorecards, KPI reports, and executive summaries that provide visibility into program performance.
• Create and maintain Power BI dashboards and reporting tools that support operational and strategic decision-making.
• Identify opportunities to improve reporting automation, efficiency, and usability.
• Document reporting methodologies, calculations, and data sources to ensure long-term sustainability.
• Consolidate and reconcile data from multiple sources, including program tracking systems, Excel-based databases, SharePoint, Power BI, and operational platforms.
• Analyze program performance data to identify trends, risks, bottlenecks, and improvement opportunities.
• Proactively communicate insights and recommendations to program leadership.
• Support forecasting, planning, and performance monitoring activities.
• Translate complex data into clear, actionable information for both technical and non-technical audiences.
• Partner with Program Managers, Operations Managers, and Engagement Managers to define reporting requirements and performance visibility needs.
• Support quality assurance and data validation efforts to ensure reporting accuracy.
• Assist with client reporting, regulatory reporting, and internal performance reviews.
• Contribute to process improvement initiatives through operational analysis and data-driven recommendations.
• Support special projects and strategic initiatives as assigned.

• Bachelor's degree in Business, Analytics, Engineering, Mathematics, Statistics, Information Systems, Finance, or a related field; equivalent experience may be considered.
• Must currently reside in New Jersey.
• 2–5 years of experience in reporting, analytics, business operations, program support, business intelligence, or a related analytical role.
• Demonstrated experience building dashboards, reports, scorecards, or performance-tracking tools used by business or operations teams.
• Advanced Microsoft Excel skills, including pivot tables, lookup functions, data validation, reconciliation, and reporting automation.
• Experience using Power BI or similar business intelligence and data visualization platforms.
• Strong analytical and problem-solving abilities with the ability to translate data into business insights.
• Ability to manage multiple priorities and work independently in a fast-paced environment.
• Strong written and verbal communication skills.
• High attention to detail and commitment to data accuracy and integrity.
• Valid driver's license and ability to travel up to 10%.

Demonstrates expertise in building and maintaining reporting infrastructures, with a strong focus on data analysis, dashboard creation, and performance monitoring. Proficient in translating complex data into actionable insights for diverse audiences while ensuring data accuracy and integrity.