Program Analytics & Reporting Specialist

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

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.