Junior Data Engineer

Summary

Join Energy Solutions, a growing company focused on market-based solutions for energy and water savings, as a Junior Data Engineer I. This full-time role, part of the Information Systems team, contributes to critical projects like IRIS and the new ERP system. You will collaborate on data-driven solutions, design and implement data pipelines, develop and maintain a data warehouse, and support the Data Science Center of Excellence. Energy Solutions offers a remote-friendly work environment with offices in several states. The position offers a competitive salary and a comprehensive benefits package.

Requirements

• 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

Responsibilities

• 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

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

Benefits

• Remote-friendly work environment
• Compensation to commensurate with experience with the pay band of $90k - $110k/Annually
• Generous retirement package
• Medical, dental and vision insurance
• Other pre-tax contribution plans
• Employee Stock Ownership Plan (ESOP)