Search Jobs

ETL Developer

White Plains, NY 10607

Posted: 01/14/2025 Industry: IT Job Number: 42506317 Pay Rate: $45-55 / hour

Job Description

Lighthouse Professional Services, a division of Staffing 360 Solutions group, is proud to be a “Best in Staffing 2023” award winner. We have over 50 years of experience placing people with small and global companies. Our offices in New York, Connecticut, and Massachusetts serve clients nationwide.  We are seeking a ETL Developer to work a hybrid schedule in White Plains, NY.  Details:Location: White Plains, NY12 month+ contract Pay rate: $45.00hr - $55.00hr depending on experienceSchedule: Monday-Friday hybrid working (3) days onsite and (2) days from home Project Overview:
  • The details of the different ETL development that will be enabled over the duration of the project are outlined below. 
  • Analyze the ETL mapping sheet of customer data and create hierarchy for Organizations, Facilities, Accounts and meters 
  • Analyze the existing hierarchy and propose changes to improve the overall data quality. 
  • Create detailed design documents for development team use on new or existing customer integrations 
  • Update the DevOps tasks and assist business in prioritizing the tasks in sprints 
  • Develop test cases and test the data in QA environment 
  • Develop ETL flows to ingest data into NYEM platform by extracting, transforming, loading from Energy Cap, BSNY, SAP and other etc.
Job Functions & Responsibilities:
  • ETL Development: - Design, build, and maintain efficient ETL workflows to process and integrate solar, Interval, etc., data from multiple sources. 
  • Optimize ETL processes for performance and scalability.
  • Data Integration: - Collaborate with data providers and stakeholders to ensure accurate data ingestion and transformation. - Develop mechanisms for real-time and batch solar data processing. 
  • Data Quality & Validation: - Implement robust data validation and cleansing techniques. - Ensure data accuracy and consistency. 
  • Collaboration: - Work closely with the business, and analysts. - Coordinate with IT teams to deploy ETL pipelines in production environments. 
  • Documentation: - Document ETL processes, workflows, and best practices. 
  • Maintain clear and concise technical documentation for stakeholders.
 Skills:
  • Proficiency in ETL tools such as Pentaho/Microsoft ADF. 
  • Strong SQL and database management skills (e.g., SQL Server). 
  • Experience with cloud platforms (e.g., AWS, GCP, Azure). 
  • Knowledge of Python, Spark, or other programming languages for data processing. 
  • Preferred Skills: 
    • Familiarity with energy management systems or renewable energy analytics. 
    • Experience with REST APIs and integrating IoT data, timeseries and Utility Data. 
  • Soft Skills: 
    • Strong problem-solving skills and attention to detail. 
    • Excellent communication and teamwork abilities.
 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. 
  • Proven experience in integrating energy, interval data, is preferred.
 #LP360

Meet Your Recruiter

Tony Ventresca
Sr. Staffing Specialist

I have 20 years of Technology Recruitment experience. I am a results-focused technology recruiting professional with a proven ability to help achieve organizational goals.

Apply Online

Send an email reminder to:

Related Jobs:

Login to save this search and get notified of similar positions.

About White Plains, NY

Ready to kickstart your career in the vibrant city of White Plains, New York? Nestled in the heart of Westchester County, this bustling metropolis offers a perfect blend of urban opportunities and suburban charm. Known for its diverse job market, top-notch schools, and easy access to New York City, White Plains boasts a thriving business scene, renowned art galleries like ArtsWestchester, top-notch dining options ranging from classic American fare to international cuisine, and popular attractions like the Westchester County Center and Kensico Dam Plaza. With a rich cultural heritage, excellent quality of life, and a plethora of parks and outdoor activities, White Plains is calling for talented individuals to join its dynamic workforce. Explore our job listings today and take your career to new heights in this exciting region!