What are the responsibilities and job description for the ETL Developer position at Eclaro?
ETL DeveloperJob Number : 25-03426Want to be part of the Energy Industry? ECLARO is looking for an ETL Developer for our client in White Plains, NY. ECLARO's Client is America's largest state power organization and is a national leader in energy efficiency and clean energy technology. If you’re up to the challenge, then take a chance at this rewarding opportunity!Position Overview : The details of the different ETL development that will be enable 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 Client platform by extracting, transforming, loading from Energy Cap, BSNY, SAP and other etc. 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, and Azure). Knowledge of Python, Spark, or other programming languages for data processing. Familiarity with energy management systems or renewable energy analytics, preferred. Experience with REST APIs and integrating IoT data, time series and Utility Data, preferred. Strong problem-solving skills and attention to detail, preferred. Excellent communication and teamwork abilities, preferred.If hired, you will enjoy the following ECLARO Benefits : 401k Retirement Savings Plan administered by Merrill Lynch Commuter Check Pretax Commuter Benefits Eligibility to purchase Medical, Dental & Vision Insurance through ECLAROIf interested, you may contact : Cedric Ceballocedric.ceballo@eclaro.com646-357-1237Cedric Ceballo | LinkedInEqual Opportunity Employer : ECLARO values diversity and does not discriminate based on Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
