Junior Data Engineer ((Hybrid - Oakland, CA/Portland/Chicago/Boston)
Company: Energy Solutions
Location: Boston
Posted on: May 6, 2025
|
|
|
Job Description:
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. The Junior Data Engineer role is part of the
Information Systems team and will work on critical projects such as
IRIS and the new ERP system. The IRIS project is one of ES's
strategic goals to build and maintain a system that enables ES to
centralize, integrate, and analyze internal data from various
sources. The goal is to provide a single source of truth for ES
internal data and enable data-driven decision-making across the
organization.
This is a hybrid work opportunity. At ES, this means working onsite
at one of our offices a minimum of 1 day/week (currently
Wednesdays) with flexibility for the remainder of the days. ES has
offices in Oakland, CA, Orange, CA, Portland, OR, Chicago, IL, and
Boston, MA.
Responsibilities include but are not limited to:
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-technicalaudience
Expertise in cloud services architecting and designing secure
AWSenvironments
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 to commensurate with experience with the pay band of
$90k - $110k/Annually
Compensation is commensurate with experience and includes a
generous retirement package. Energy Solutions provides an excellent
benefits package including medical, dental and vision insurance,
other pre-tax contribution plans and an Employee Stock Ownership
Plan (ESOP).
Equal Opportunity Employer
Energy Solutions is an affirmative action-equal opportunity
employer and prohibits discrimination and harassment of any type.
We afford equal employment opportunities to employees and
applicants without regard to race, color, religion, sex, sexual
orientation, gender identity or expression, pregnancy, age,
national origin, disability status, genetic information, protected
veteran status, or any other characteristics protected by law.
Energy Solutions conforms to the spirit as well as to the letter of
all applicable laws and regulations.
Inclusion, Diversity, Equity, Accessibility
We live out our mission day in and day out by helping our clients
and communities generate clean energy solutions the world needs.
Our success is dependent on developing a team of creative thinkers,
innovators, and a workforce that reflects the diversity of our
world. To that end, we're committed to hiring, promoting, and
retaining a diversity of talent, and infusing inclusion, diversity,
equity, and accessibility (IDEA) throughout our business. We
encourage people from all backgrounds and all walks of life to
apply. Come grow with us at Energy Solutions!
Office Locations and a Remote Workforce
Energy Solutions operates as a predominantly remote workforce with
offices insix different locations. Employees who reside within 40
miles of an office (except New York) will be assigned to that
location, though in-office attendance requirements may vary by
team. At this time, we are not accepting applications from
candidates residing in the following states: Alaska, Delaware,
Kentucky, Mississippi, Montana, Nebraska, North Dakota, and
Wyoming.
Background Check Information
Information will be requested to perform the compulsory background
check. A drug screen and authorization to work in the U.S.
indefinitely are preconditions of employment. Energy Solutions is
an equal opportunity employer.
Reasonable Accommodations
Energy Solutions is committed to providing access and reasonable
accommodation for individuals with disabilities. If you require
accommodations in completing this application, interviewing, and/or
completing any pre-employment testing, or otherwise participating
in the employee selection process, please email .
Keywords: Energy Solutions, Nantucket , Junior Data Engineer ((Hybrid - Oakland, CA/Portland/Chicago/Boston), Engineering , Boston, Massachusetts
|
Click
here to apply!
|
