Program Reporting & Analytics Analyst

About the role

Maryland Energy Advisors (MDEA) is a rapidly growing energy management and consulting firm supporting utilities, businesses, commercial property owners, manufacturers, restaurants, and institutional customers throughout the Mid-Atlantic region and beyond. Our work helps utility customers reduce energy consumption, lower operating costs, and improve sustainability outcomes through innovative energy efficiency programs.

Responsibilities

• Reporting & Business Intelligence Design, build, and maintain the reporting infrastructure used to manage utility energy efficiency programs.
• Create 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.
• Data Analysis & Insights
• 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.
• Program Operations Support
• 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.
• Aid in 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.

Qualifications

• 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%.

Preferred Qualifications

• Experience supporting utility, energy efficiency, demand-side management (DSM), demand response, sustainability, or related programs.
• Experience working with program tracking systems, operational databases, CRM platforms, or large datasets.
• Background in operations analysis, program performance reporting, project coordination, or process improvement.
• Experience identifying trends, risks, and opportunities through business intelligence and analytics.
• Familiarity with utility program operations, contractor networks, field operations, or customer engagement programs.
• Interest in sustainability and energy efficiency.