Full-Time Junior Data Engineer

Interested in joining a growing company where you will work with talented colleagues, enhance a supportive and energetic culture, and be part of the climate solution?

At Energy Solutions, we focus on the big impacts. And we believe that market-based programs can be a powerful force to deliver large-scale energy, carbon, and water-use savings.

Since 1995, we’ve harnessed that power to offer proven, performance-based solutions for our utility, government, and institutional customers.

Energy Solutions (ES) is currently seeking a full-time Junior Data Engineer I.

Responsibilities include:

• Collaborate with stakeholders to understand data requirements and develop data-driven solutions that support business goals
• Analyze data sources and pipelines needed for the various data projects
• Design and implement scalable data pipelines, ETL processes, and data integration solutions for the IRIS project using Python, SQL, and AWS technologies
• Develop and maintain a data warehouse and optimize data storage, processing, and retrieval
• Build schema, populate the database, and automate reporting
• Document and maintain technical specifications, ETL processes, data mappings, and dictionaries
• Support the Data Science Center of Excellence (DSCOE) with other data engineering needs

Minimum Qualifications:

• BS/BA in Computer Science, Physics/Engineering, Business or Mathematics
• Experience in building ETL data pipelines, real-time pipelines are a plus
• Strong programming skills in Python and SQL
• Minimum 2 years of data warehouse development and strong fundamentals in dimensional data modeling
• Minimum 2 years of experience creating SQL queries and ETL design, implementation, and maintenance
• Minimum 2 years of experience developing data pipelines using Python
• Minimum 2 years of experience with AWS, AWS Redshift, AWS Data Engineering and ML Ops tools and services (i.e: S3, Redshift, RDS)
• Proven ability to aggregate, normalize, munge, analyze, and summarize value from disparate datasets
• Strong oral, written, and interpersonal communication skills
• High degree of accuracy and attention to detail
• Ability to establish priorities and work independently with minimum supervision

Preferred Qualifications:

• Ability to manage and communicate data warehouse plans to a non-technical audience
• Expertise in cloud services architecting and designing secure AWS environments
• Experience using BI tools like Tableau and Looker
• Experienced in analyzing and troubleshooting data quality issues
• Self-driven, highly motivated, and able to learn quickly
• Familiarity with large data sets, cloud-based development and deployment, open-source practices and frameworks, and intelligent applications is desirable
• Proven success in migrating data from legacy systems

Compensation:

Compensation commensurate with experience with the pay band of $90k - $110k/Annually

What is the last date for applying to the job?

Which countries are accepted for this remote job?