ETL Developer

Position Details :

Job Title : ETL Developer / Data Engineer

Location : White Plains, NY (Hybrid)

Duration : 12 months (With possible extension) W2 contract role

Project Overview

• ETL Development : Analyze the ETL mapping sheet of customer data and create a hierarchy for Organizations, Facilities, Accounts, and Meters.
• Data Quality Improvement : Analyze the existing hierarchy and propose changes to improve the overall data quality.
• Documentation : Create detailed design documents for the development team on new or existing customer integrations.
• Task Prioritization : Update DevOps tasks and assist the business in prioritizing tasks during sprints.
• Testing : Develop test cases and test the data in the QA environment.
• Data Ingestion : Develop ETL flows to ingest data into the NYEM platform by extracting, transforming, and loading data from Energy Cap, BSNY, SAP, and other sources.

Job Functions & Responsibilities

Design, build, and maintain efficient ETL workflows to process and integrate solar, interval, and other data from multiple sources.

Collaborate with data providers and stakeholders to ensure accurate data ingestion and transformation.

Implement robust data validation and cleansing techniques.

Work closely with the business and analysts.

Document ETL processes, workflows, and best practices.

Skills

Proficiency in ETL tools such as Pentaho / Microsoft ADF.

Familiarity with energy management systems or renewable energy analytics.

Strong problem-solving skills and attention to detail.

Education & Certifications

Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.

5 years of experience as a Data Engineer or ETL Developer.