Program Reporting & Analytics Analyst – MDEA

Jobtailor; Newark (NJ); On-site; USD 70,000 - 100,000; Full time

Job summary

Jobtailor in Newark, NJ is seeking a reporting and BI analyst to design, build, and maintain the reporting infrastructure for utility energy efficiency programs, and to develop dashboards and KPI reports for leadership.

You will translate complex data into actionable insights, collaborate with Program, Operations, and Engagement Managers, and help automate reporting while ensuring accuracy and governance.

Qualifications

• Bachelor's degree or equivalent experience in a related field.
• 2–5 years in reporting, analytics, business operations or BI.
• Experience building dashboards, reports, and scorecards.
• Advanced Excel skills including pivot tables, lookups, data validation.
• Experience with Power BI or similar BI platforms.
• Strong analytical and problem-solving abilities with data insights.
• Ability to manage multiple priorities and work independently.
• Strong written and verbal communication skills.
• Valid driver's license and ability to travel up to 10%.

Responsibilities

• Design, build, and maintain reporting infrastructure for utility energy programs.
• Develop recurring dashboards, KPI reports, and executive summaries.
• Create and maintain Power BI dashboards and reporting tools.
• Identify opportunities to improve reporting automation and usability.
• Document methodologies, calculations, and data sources for sustainability.
• Consolidate data from multiple sources including Excel, SharePoint, and BI platforms.
• Analyze performance data to identify trends, risks, and improvements.
• Communicate insights and recommendations to program leadership.
• Support forecasting, planning, and performance monitoring.
• Translate complex data into actionable information for technical and non-technical audiences.
• Partner with Program, Operations, and Engagement Managers to define requirements.
• Support QA and data validation to ensure accuracy.
• Assist with client, regulatory, and internal performance reporting.
• Contribute to process improvements with data-driven recommendations.
• Support special projects and strategic initiatives.

Skills

Power BI

Excel

Data analysis

Data visualization

Communication

Education

Bachelor's degree in Business, Analytics, Engineering, Mathematics, Statistics, Information Systems, Finance, or related field

Tools

Power BI

SharePoint

Excel

Job description

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.