[Hiring] Junior Data Engineer @Energy Solutions - USA

Energy Solutions - USA12 months ago
United States
Remote
Full-time
Junior Level (1-3 years)

Job Description

Position Overview

Energy Solutions is hiring a remote Junior Data Engineer to join the Information Systems team. In this full‐time role, you will work on strategic projects such as IRIS and a new ERP system to centralize, integrate, and analyze internal data—enabling data‐driven decision-making across the organization. Compensation: $90k - $110k/annually. This opportunity offers the flexibility of remote work while also providing access to offices in select states.

Key Responsibilities

  • Collaborate with stakeholders to understand data requirements and develop data-driven solutions that support business goals
  • Analyze data sources and pipelines for 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

Required 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 experience in data warehouse development with strong fundamentals in dimensional data modeling
  • Minimum 2 years of experience creating SQL queries and designing, implementing, and maintaining ETL processes
  • Minimum 2 years of experience developing data pipelines using Python
  • Minimum 2 years of experience with AWS services (including AWS Redshift, S3, RDS, and ML Ops tools)
  • Proven ability to aggregate, normalize, analyze, and summarize data 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 minimal supervision

Preferred Qualifications

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

Benefits & Perks

  • Generous retirement package
  • Excellent benefits package including medical, dental, and vision insurance
  • Other pre-tax contribution plans
  • Employee Stock Ownership Plan (ESOP)

Required Skills

Data Pipeline Architecture
Python
Data Integration
Data Warehouse Development
Dimensional Data Modeling
ETL Development
AWS (S3, Redshift, RDS)
SQL