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. Requirements 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%. Core Competencies 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. #J-18808-Ljbffr Jobtailor