Data Analyst - Energy Programs

AMERIT CONSULTING INC
New York, NY, United States
3 months ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Shift work
Job source

Tech stack

Microsoft Excel Artificial Intelligence Data Analysis Excel Formulas Python (Programming Language) Power BI Salesforce.Com Data Processing Microsoft Power Automate Powerapps

Job description

· Manage invoice processing for mass market energy efficiency programs. Review of technical program application and energy efficiency savings documentation.

· Process energy efficiency invoices in the Company’’s Demand Management Tracking System (DMTS), an application built in Salesforce. Report on Invoice processing performance and statuses at weekly team meetings.

· Perform Quality control review of invoices provided from implementation contractors that support the energy efficiency programs. Coordinate between various teams, such as DMTS, business planning and analysis, and program delivery teams to ensure deliverables are met.

· Prepare and review programs information and reports for accuracy and reconcile, as necessary.

· Monitor and track program budgets and expenditures.

· Manage customer eligibility data (Qualification Checks) to ensure compliance with program requirements.

· Document Processes and development process improvements if / when applicable.

· Leverage AI tools to automate workflows, accelerate data processing, and drive operational efficiency across program operations.

· Design, build, and maintain automated reporting solutions and dashboards using Power Platform (Power BI, Power Automate, Power Apps), Python, Excel, reducing manual effort and improving visibility into program metrics.

· Ensure data quality and integrity by regularly reviewing and updating dashboard information.

· Troubleshoot and resolve any issues related to dashboard functionality and data accuracy., Applicants, with criminal histories, are considered in a manner that is consistent with local, state and federal laws.

Requirements

· Must have at least a bachelor’s degree.

· Years of experience: 5+ years.

· Related Industry Background: Utility, engineering, full cycle recruiting in heavy volume, telecom experience

· Experience with Python, and advanced Excel functions to analyze, manipulate and present data effectively.

· Data Analysis and Reporting.

· Dashboard Development.

· Data Automation.

· Salesforce (DMTS).

· Process Improvement.

· Budget Tracking.

· Power Platform (PowerBI, Power Automate, Power Apps).

· AI Tools.

· Soft Skills: Team player; proved track record to meet strict goals and deadlines for deliverables; strong organizations skills; razor sharp attention to detail.

About the company

Our client, one of the largest Energy companies in US providing a wide range of Energy related products and services to its customers, seeks accomplished Data Analyst (Customer Clean Energy Programs)., Amerit Consulting is an extremely fast-growing staffing and consulting firm. Amerit Consulting was founded in 2002 to provide consulting, temporary staffing, direct hire, and payrolling services to Fortune 500 companies nationally; as well as small to mid-sized organizations on a local & regional level. Currently, Amerit has over 2,000 employees in 47 states. We develop and implement solutions that help our clients operate more efficiently, deliver greater customer satisfaction, and see a positive impact on their bottom line. We create value by bringing together the right people to achieve results. Our clients and employees say they choose to work with Amerit because of how we work with them - with service that exceeds their expectations and a personal commitment to their success. Our deep expertise in human capital management has fueled our expansion into direct hire placements, temporary staffing, contract placements, and additional staffing and consulting services that propel our clients’ businesses forward.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on dice.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella · WWC 2023

2:44 min

Integrating data analytics into the talent acquisition function

Kobi Kobi +1 · WWC 2025

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

1:36 min

Performing exploratory data analysis to uncover underlying patterns

Julian Joseph · LIVE

Videos

See all

Related articles

See all