Back to jobs

Data Engineer II

Boston, Massachusetts, United States, Boulder, Colorado, United States, Chicago, Illinois, United States

Actively hiring, first seen by us 4 days ago
Pay
$90,000–136,000/yearAnnual period assumed — pay source
Position Details Salary range: $90,000 - $136,000 Full-time
Read the full posting
Work setting
Hybrid — work setting source
Full-time Hybrid Location: Boulder, CO, Dedham, MA, or Chicago, IL
Read the full posting
Employment
Full-time — employment source
Salary range: $90,000 - $136,000 Full-time Hybrid
Read the full posting

What you’ll work on

Full posting

As a Data Engineer on the Data Engineering team, you will focus on data transformation and integration: taking messy, disparate datasets that were never designed to work together and turning them into unified, well-modeled data in Snowflake through scalable and reliable processes.

This position offers candidates an opportunity to develop greater knowledge of energy markets, cloud-based software products, and SaaS businesses, while applying and developing technical, research, and customer-facing skills with one of the most creative and hard-working staff in the industry.

  • Design and build Snowflake transformation layers that combine multiple data sources

  • Ingest, clean, normalize, and reconcile messy data with differing schemas and identifiers

  • Build tested data pipelines with monitoring, alerting, and data quality checks

  • Design data models, shared keys, and cross-reference mappings so datasets can be joined

  • Provide off-hours support for the data pipelines you build, including nights and weekends

From the employer’s posting
As a Data Engineer on the Data Engineering team, you will focus on data transformation and integration: taking messy, disparate datasets that were never designed to work together and turning them into unified, well-modeled data in Snowflake through scalable and reliable processes. The Data Engineering team serves an important role for all participants in the energy markets, collecting new data and creating derivative, value-added datasets that help our clients solve problems. Your design solutions will be built to ensure the highest level of data completeness, correctness, and timeliness for large, complex time series data.
This position offers candidates an opportunity to develop greater knowledge of energy markets, cloud-based software products, and SaaS businesses, while applying and developing technical, research, and customer-facing skills with one of the most creative and hard-working staff in the industry. AI is at the center of how we build: we make heavy use of AI-assisted and agentic development, including coding agents and the harnesses that orchestrate them, alongside Snowflake, Spring, Kafka, and Oracle PL/SQL.
Design and build transformation layers in Snowflake that combine data from multiple internal and external sources into unified, well-modeled datasets
Ingest, profile, clean, normalize, and reconcile messy, disparate data sources with differing schemas, granularity, identifiers, and update cadences
Build scalable, reliable, well-tested data pipelines with monitoring, alerting, and data quality checks built in from the start
Design data models, shared keys, and cross-reference mappings that allow datasets from different systems to be joined and trusted
Provide off-hours support for the data pipelines you build, including nights & weekends as needed

Before you apply

Employer’s visa record
5 H-1B petitions approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.

What you’ll bring

All qualifications

Core experience

  • 3+ years of SQL experience
  • Ability to apply a testing mindset to own code
  • Demonstrated experience integrating and transforming messy data from multiple disparate sources into unified, production-grade datasets
  • Ability to work effectively with AI agents and harnesses: writing clear specifications, critically reviewing AI-generated code, and building tests and guardrails around it
  • Hands-on experience using AI coding assistants or agentic development tools in day-to-day engineering work
  • Ability to embrace a customer service mindset

Preferred experience

  • AWS preferred w S3 buckets, Lambdas, Kinesis, etc.
  • Experience working with large-scale time series data
  • Experience unifying data across multiple systems or business domains
  • Experience with data transformation and orchestration frameworks (e.g., dbt, Airflow)
Qualification wording
3+ years of SQL experience
Ability to apply a testing mindset to own code
Demonstrated experience integrating and transforming messy data from multiple disparate sources into unified, production-grade datasets
Ability to work effectively with AI agents and harnesses: writing clear specifications, critically reviewing AI-generated code, and building tests and guardrails around it
Hands-on experience using AI coding assistants or agentic development tools in day-to-day engineering work
Ability to embrace a customer service mindset
Experience in a Cloud Environment (AWS preferred w S3 buckets, Lambdas, Kinesis, etc.)
Experience working with large-scale time series data
Experience unifying data across multiple systems or business domains
Experience with data transformation and orchestration frameworks (e.g., dbt, Airflow)

Benefits in the posting

Full benefits wording
  • We offer highly competitive salaries and real bonuses that are achievable and that you can impact. Our benefits package is also very competitive, including medical insurance, a 401 (k) Plan with matching, flexible vacation, and flexible work schedules. Yes Energy encourages and funds investment in both formal and informal professional development.
  • At Yes Energy, we are dedicated to building a diverse, inclusive, and authentic workplace. If you’re excited about this role but your experience doesn’t perfectly align with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.

From the employer’s posting.

About Yes Energy

We think about customers as business partners, and when we help them be more successful … we are more successful, too.

In the employer’s words · Read in context

Apply at Yes Energy

Posting record

Report an error

Actively hiringFirst seen by us 4 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 17, 20264 days ago
Recorded sightings
5
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

Lower than most similar jobs

$90K–$136K against $127K–$189K, the middle half of what similar US postings state.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 4

Early. Similar jobs usually come down between day 6 and day 56.

From 14,770 similar postings that came down. Coming down is not always a hire.

Yes Energy is hiring

4 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring is picking up
  • Its jobs tend to stay up a long time
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • PL/SQL
  • Python
  • SQL
  • AWS
  • dbt
  • Kafka
  • Oracle
  • S3
  • Snowflake
  • Airflow
Where the posting names them
As a Data Engineer on the Data Engineering team, you will focus on data transformation and integration: taking messy, disparate datasets that were never designed to work together and turning them into unified, well-modeled data in Snowflake through scalable and reliable processes. The Data Engineering team serves an important role for all participants in the energy markets, collecting new data and creating derivative, value-added datasets that help our clients solve problems. Your design solutions will be built to ensure the highest level of data completeness, correctness, and timeliness for large, complex time series data. This position offers candidates an opportunity to develop greater knowledge of energy markets, cloud-based software products, and SaaS businesses, while applying and developing technical, research, and customer-facing skills with one of the most creative and hard-working staff in the industry. AI is at the center of how we build: we make heavy use of AI-assisted and agentic development, including coding agents and the harnesses that orchestrate them, alongside Snowflake, Spring, Kafka, and Oracle PL/SQL. Position Details
- Energy Markets experience is preferred - Oracle PL/SQL experience - Experience working with large-scale time series data
- Strong communication, interpersonal, influence, collaboration and leadership skills - Proficiency in Python for data processing and pipeline development; shell scripting - Familiarity with agile development methodologies
- At least 3 years of related data engineering experience - 3+ years of SQL experience - Hands-on production experience with Snowflake, including data modeling and performance tuning
- Familiarity with agile development methodologies - Experience in a Cloud Environment (AWS preferred w S3 buckets, Lambdas, Kinesis, etc.) Preferred Qualifications
- Experience unifying data across multiple systems or business domains - Experience with data transformation and orchestration frameworks (e.g., dbt, Airflow) At Yes Energy, we value connecting directly with candidates. We kindly ask that third-party recruiters and agencies not submit resumes, as we are not open to external recruiting partnerships.
Position Summary As a Data Engineer on the Data Engineering team, you will focus on data transformation and integration: taking messy, disparate datasets that were never designed to work together and turning them into unified, well-modeled data in Snowflake through scalable and reliable processes. The Data Engineering team serves an important role for all participants in the energy markets, collecting new data and creating derivative, value-added datasets that help our clients solve problems. Your design solutions will be built to ensure the highest level of data completeness, correctness, and timeliness for large, complex time series data. This position offers candidates an opportunity to develop greater knowledge of energy markets, cloud-based software products, and SaaS businesses, while applying and developing technical, research, and customer-facing skills with one of the most creative and hard-working staff in the industry. AI is at the center of how we build: we make heavy use of AI-assisted and agentic development, including coding agents and the harnesses that orchestrate them, alongside Snowflake, Spring, Kafka, and Oracle PL/SQL.
Primary Responsibilities - Design and build transformation layers in Snowflake that combine data from multiple internal and external sources into unified, well-modeled datasets - Ingest, profile, clean, normalize, and reconcile messy, disparate data sources with differing schemas, granularity, identifiers, and update cadences
- Create and maintain runbooks and technical documentation that allow the broader team to support your pipelines - Ensure Snowflake performance and cost efficiency through proactive review, analysis, and tuning - Plan and coordinate data migrations and integrations between systems
- 3+ years of SQL experience - Hands-on production experience with Snowflake, including data modeling and performance tuning - Demonstrated experience integrating and transforming messy data from multiple disparate sources into unified, production-grade datasets

Your next step

Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

Has Yes Energy posted this job before?

Yes. We’ve followed one other Data Engineer II job there since June 2026. It is still up.

  1. BoulderStill up after 147 days, first seen Jun 27
  2. This jobUp 4 days so far, first seen Nov 17

Job description

View original posting ↗

Join the Market Leader in Electric Power Data and Analytics Solutions

The electrical grid is the largest and most complicated machine ever built. Yes Energy’s industry-leading electric power trading analytics software provides real-time visibility into the massive amount of data generated by the North American electrical grid daily. Our unique and innovative view of the data informs real-time trading decisions and mid-to-long-term investment decisions that keep utility prices low, support the energy transition, and keep the grid running. It’s both challenging work and work with a purpose.

Be a part of our successful, growing business during international transformation.

Position Summary

As a Data Engineer on the Data Engineering team, you will focus on data transformation and integration: taking messy, disparate datasets that were never designed to work together and turning them into unified, well-modeled data in Snowflake through scalable and reliable processes. The Data Engineering team serves an important role for all participants in the energy markets, collecting new data and creating derivative, value-added datasets that help our clients solve problems. Your design solutions will be built to ensure the highest level of data completeness, correctness, and timeliness for large, complex time series data.

This position offers candidates an opportunity to develop greater knowledge of energy markets, cloud-based software products, and SaaS businesses, while applying and developing technical, research, and customer-facing skills with one of the most creative and hard-working staff in the industry. AI is at the center of how we build: we make heavy use of AI-assisted and agentic development, including coding agents and the harnesses that orchestrate them, alongside Snowflake, Spring, Kafka, and Oracle PL/SQL.

Position Details 

  • Salary range: $90,000 - $136,000
  • Full-time
  • Hybrid
  • Location: Boulder, CO, Dedham, MA, or Chicago, IL 
  • Reports to: Manager of Data Collections
  • Travel requirements: Minimal travel may be required (up to 10 days per year)

Primary Responsibilities

  • Design and build transformation layers in Snowflake that combine data from multiple internal and external sources into unified, well-modeled datasets
  • Ingest, profile, clean, normalize, and reconcile messy, disparate data sources with differing schemas, granularity, identifiers, and update cadences
  • Build scalable, reliable, well-tested data pipelines with monitoring, alerting, and data quality checks built in from the start
  • Design data models, shared keys, and cross-reference mappings that allow datasets from different systems to be joined and trusted
  • Ensure the highest possible completeness, timeliness, quality, and integrity of Yes Energy data
  • Partner with product management to prototype and validate new use cases, turning ideas into datasets that demonstrate customer value
  • Use AI-assisted and agentic development tools and harnesses to accelerate development, testing, documentation, and data validation, and help refine how the team applies them
  • Provide off-hours support for the data pipelines you build, including nights & weekends as needed
  • Create and maintain runbooks and technical documentation that allow the broader team to support your pipelines
  • Ensure Snowflake performance and cost efficiency through proactive review, analysis, and tuning
  • Plan and coordinate data migrations and integrations between systems
  • Contribute to technical departmental standards in such areas as change control, configuration management, development methodology, and coding standards
  • Support customers and internal teams with data-related questions
  • Participate in product release testing

Minimum Qualifications 

  • At least 3 years of related data engineering experience
  • 3+ years of SQL experience
  • Hands-on production experience with Snowflake, including data modeling and performance tuning
  • Demonstrated experience integrating and transforming messy data from multiple disparate sources into unified, production-grade datasets
  • Hands-on experience using AI coding assistants or agentic development tools in day-to-day engineering work

Knowledge Skills & Abilities

  • Stewardship of data quality problems and solutions; passion for data quality
  • Creative problem solving abilities and comfort bringing structure to ambiguous, early-stage problems
  • Analytic and troubleshooting skills
  • Ability to apply a testing mindset to own code
  • Ability to work effectively with AI agents and harnesses: writing clear specifications, critically reviewing AI-generated code, and building tests and guardrails around it
  • Ability to embrace a customer service mindset
  • Strong communication, interpersonal, influence, collaboration and leadership skills
  • Proficiency in Python for data processing and pipeline development; shell scripting
  • Familiarity with agile development methodologies
  • Experience in a Cloud Environment (AWS preferred w S3 buckets, Lambdas, Kinesis, etc.)

Preferred Qualifications

  • Energy Markets experience is preferred
  • Oracle PL/SQL experience
  • Experience working with large-scale time series data
  • Experience unifying data across multiple systems or business domains
  • Experience with data transformation and orchestration frameworks (e.g., dbt, Airflow)

 

At Yes Energy, we value connecting directly with candidates. We kindly ask that third-party recruiters and agencies not submit resumes, as we are not open to external recruiting partnerships.

ABOUT YES ENERGY

Overview

Yes Energy delivers real-time market data and electric power trading decision solutions.  Over 1,000 market participants use Yes Energy solutions daily.  The business is a leader in all aspects of information content collection and management, developing and delivering data and market analytics solutions. Since its inception in 2008, Yes Energy has become a trusted and respected supplier of innovative and reliable solutions focused on the needs of power market analysts, traders, and trade managers.  Yes Energy has a team of 400+ amazing professionals in Boulder, CO (HQ); Boston, MA; Chicago, IL; Glendora, CA; Richmond, VA; London, United Kingdom; Auckland, New Zealand; and Bucharest, Romania.

Culture

Yes Energy has been named one of the Best Places to Work in Colorado, and we have the culture to prove it. At Yes Energy, we care about saying “Yes” to customers. We like to listen, learn, and develop our solutions in line with their needs. We think about customers as business partners, and when we help them be more successful … we are more successful, too.

Around the office, our culture is driven by some pretty fundamental values that we’re proud of:

  • We love innovation and solving tough challenges;
  • We are “high standards people” who combine passion and pride with hard work and rewards of all kinds-- in an ethic that is consistent across the company.
  • We’re team-focused with a flat hierarchy-- we work in small teams on well-defined projects that directly impact the success of the business;
  • We play to the strengths and experience of each person while each of us also works along a continuum of roles adjacent to our focus area.  This presents the challenge of maintaining a broad set of skills as well as an opportunity to learn and contribute in many ways. 
  • We are constantly growing. Professional development happens every day and every year.

Compensation and Benefits

We offer highly competitive salaries and real bonuses that are achievable and that you can impact. Our benefits package is also very competitive, including medical insurance, a 401 (k) Plan with matching, flexible vacation, and flexible work schedules. Yes Energy encourages and funds investment in both formal and informal professional development.

At Yes Energy, we are dedicated to building a diverse, inclusive, and authentic workplace. If you’re excited about this role but your experience doesn’t perfectly align with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.

In accordance with Colorado law, the range provided is Yes Energy’s reasonable estimate of the base compensation for this role. The actual amount may be higher or lower based on non-discriminatory factors such as location, experience, knowledge, skills, and abilities.

Yes Energy provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, Yes Energy complies with applicable state and local laws governing nondiscrimination in employment in every location where the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Position Details Salary range: $90,000 - $136,000 Full-time
Location & working pattern

Boston, Massachusetts, United States, Boulder, Colorado, United States, Chicago, Illinois, United States

- Full-time - Hybrid - Location: Boulder, CO, Dedham, MA, or Chicago, IL
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.