Data Analyst – W2 Only | Hybrid Role | C2C Not Accepted

Overview:

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.

*** Candidate must be authorized to work in USA without requiring sponsorship ***

**********************************************************

*** Location: New York, NY 10003

*** Duration: 6 months contract w/ possibility of extensions

Notes:

• Work Schedule: Hybrid - anticipated 3 days onsite in office.
• Interview Process: In-person interview will be required.
• Target Start Date: End of September.

Description:

• The Digital Products team supports company’s clean energy initiatives through data products and advanced analytics.
• The team works across customer, GIS, utility, and other large-scale datasets to create insights that support clean energy planning, grid performance, and technology integration.
• The Data Analyst will primarily work with existing datasets and multiple data repositories, bringing information together through queries and complex joins, validating data, identifying data quality issues and outliers, performing analysis, and developing visualizations/reports that can be used by project teams and stakeholders.
• The team is fully operational today and is looking to expand its ability to turn existing data into repeatable, actionable insights.
• By the end of 2026, the team would like to develop approximately 2–5 insight tools/products, including standalone analytical tools and repeatable reports/dashboards in Power BI.
• Reviewing, validating, and analyzing large and complex datasets.
• Working across multiple data repositories and source systems.
• Combining datasets using SQL, including complex joins and data transformations.
• Identifying data quality issues, anomalies, trends, and outliers.
• Determining whether data is appropriate and sufficient for a particular analysis.
• Translating data into meaningful business/operational insights.
• Building reports, dashboards, visualizations, and/or other analytical products.
• Developing repeatable reporting and analytical processes.
• Supporting testing and validation of analytical tools and methodologies.
• Troubleshooting data issues and performing root-cause analysis.
• Communicating findings and escalating data issues appropriately.
• Working collaboratively with engineers, clean energy program managers, and subject matter experts.
• Helping refine data aggregations, such as rolling customer account-level information into building-level profiles.

Qualifications:

• Bachelor’s Degree required.
• The hiring team specifically wants someone who can understand the context behind the data and make intelligent decisions about what they are seeing.
• Utility experience is a strong differentiator, but we will consider candidates from other industries if they have demonstrated experience working with complex, large-scale datasets and can demonstrate the analytical judgment described above.
• 2+ years of professional data analysis experience.
• Strong SQL experience.
• Experience analyzing large and/or complex datasets.
• Experience working with data from multiple source systems.
• Strong attention to detail and ability to follow defined processes.
• Ability to identify anomalies, inconsistencies, and data quality issues rather than simply reporting what the data says.
• Strong written and verbal communication skills.
• Ability to investigate, track, communicate, and escalate issues with appropriate urgency.
• Ability to manage multiple workflows and priorities in a fast-paced environment.

A brief summary highlighting most relevant experience, particularly:

• Utility/customer usage data:
• Large/complex datasets:
• SQL and complex joins:
• Python:
• Databricks:
• Power BI/data visualization:
• Data quality/root-cause analysis:
• Data integration/pipelines:
• Clean energy/utility experience:
• Product/application development:

Preferred Skills:

• Utility industry experience – highly preferred but not required.
• Experience with electric utility/customer usage data.
• Exposure to AMI, GIS, or real-time operational datasets.
• Clean energy experience, including EVs, batteries, electrification, or grid-related initiatives.
• Python.
• Databricks.
• Other querying/data technologies.
• Database management.
• Data integration and/or data pipeline management.
• Data engineering experience.
• Experience working with very large datasets and complicated data relationships/joins.
• Power BI or other data visualization tools.
• Bulk data testing and development/execution of testing and verification plans.
• Data pipeline troubleshooting and root-cause analysis.
• Product, application, or analytical tool development experience.

************************************************************

I'd love to talk to you if you think this position is right up your alley, and assure a prompt communication, whichever direction. If you're looking for rewarding employment and a company that puts its employees first, we'd like to work with you.

Satwinder “Sat” Singh

Lead Technical Recruiter

Company Overview:

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.

Amerit Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Applicants, with criminal histories, are considered in a manner that is consistent with local, state and federal laws.