You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
Yes Energy

Data Engineer II

  • Hybrid
  • 3-6 years

Salary

$90,000 - 136,000/ year

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

The company sells real-time market data and electric power trading analytics software. More than 1,000 market participants use its solutions every day, and it has over 400 staff across offices in the US, the UK, New Zealand and Romania. It was founded in 2008 and serves power market analysts, traders and trade managers.

The electrical grid produces a huge volume of data each day. The company's analytics turn that North American grid data into information that supports real-time trading, longer-term investment decisions and lower utility prices.

As a Data Engineer II, you will join the Data Engineering team, which collects new data and builds value-added datasets for energy market participants. Your focus is transforming and integrating messy, disparate datasets that were never built to work together, and producing unified, well-modeled data in Snowflake. The team's work is built around the highest levels of completeness, correctness and timeliness for large, complex time series data.

The team uses AI-assisted and agentic development heavily, including coding agents and the harnesses that run them, alongside Snowflake, Spring, Kafka and Oracle PL/SQL. The role includes working with a team known for its creativity and hard work, and it lets you build knowledge of energy markets, cloud software products and SaaS businesses.

Responsibilities

  • Design and build Snowflake transformation layers that merge internal and external data into unified, well-modeled datasets.
  • Ingest, profile, clean, normalize and reconcile data sources that have different schemas, granularity, identifiers and update schedules.
  • Build scalable, reliable, well-tested pipelines with monitoring, alerting and data quality checks included from the start.
  • Design data models, shared keys and cross-reference mappings so that datasets from different systems can be joined and trusted.
  • Keep the company's data as complete, timely, accurate and consistent as possible.
  • Work with product management to prototype and validate new use cases, turning ideas into datasets that show customer value.
  • Use AI-assisted and agentic tools and harnesses to speed up development, testing, documentation and data validation, and help the team improve how it uses them.
  • Provide off-hours support for the pipelines you build, including nights and weekends when needed.
  • Write and maintain runbooks and technical documentation so the wider team can support your pipelines.
  • Review and tune Snowflake performance and cost proactively.
  • Plan and coordinate data migrations and integrations between systems.
  • Help set departmental standards for change control, configuration management, development methodology and coding.
  • Answer data questions from customers and internal teams.
  • Take part in product release testing.

Requirements

  • At least 3 years of data engineering experience.
  • 3+ years of SQL experience.
  • Hands-on production experience with Snowflake, including data modeling and performance tuning.
  • Proven experience turning messy data from several disparate sources into production-grade datasets.
  • Hands-on experience using AI coding assistants or agentic development tools in daily engineering work.
  • Care about data quality and take ownership of data quality problems and their fixes.
  • Creative problem solver who can bring structure to ambiguous, early-stage problems.
  • Strong analytical and troubleshooting skills.
  • Apply a testing mindset to your own code.
  • Work well with AI agents by writing clear specifications, reviewing generated code critically, and building tests and guardrails around it.
  • Bring a customer service mindset.
  • Strong communication, interpersonal, influence, collaboration and leadership skills.
  • Proficient in Python for data processing and pipeline work, and in shell scripting.
  • Familiar with agile development methods.
  • Experience in a cloud environment; AWS is preferred, including S3, Lambda and Kinesis.
  • Preferred: experience in energy markets.
  • Preferred: Oracle PL/SQL experience.
  • Preferred: experience with large-scale time series data.
  • Preferred: experience unifying data across multiple systems or business domains.
  • Preferred: experience with data transformation and orchestration frameworks such as dbt or Airflow.

Conditions

Full-time position with hybrid work.

Based in Boulder, CO, Dedham, MA, or Chicago, IL.

Reports to the Manager of Data Collections.

Minimal travel may be required, up to 10 days per year.

Salary range is $90,000 to $136,000.

Under Colorado law, this range is the company's reasonable estimate of base pay. The actual pay may be higher or lower based on non-discriminatory factors such as location, experience, knowledge, skills and abilities.

The company values a diverse, inclusive workplace and encourages you to apply even if your experience does not match every qualification.

Benefits

  • Competitive salaries and achievable bonuses that you can influence.
  • Medical insurance.
  • 401(k) plan with company matching.
  • Flexible vacation and flexible work schedules.
  • Funding for formal and informal professional development.

Where you’d work

Part of the week in the office

You can work from

  • United States

About the company

Yes Energy

Office in Boulder, United States

Also hiring in Bucharest, Romania

Your chances

Worth a look before you spend an evening tailoring a CV for it.

  • 21 checks run
  • 1 red flag

Still hiring?

14 checks

1 red flag

How crowded?

7 checks

No red flags

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details11 facts · Role, Location, Compensation, Employment
Tech stack
  • Python
  • SQL
  • AWS
  • dbt
  • Kafka
  • Snowflake
  • Airflow
Type
Full-time
Specialty
Data Engineering
Region
United States
Pay period
Annual
Show 6 more factsShow less

Role

Category
Data & Analytics
Specialty
Data Engineering
Experience
3+ years
Tech stack
  • Python
  • SQL
  • AWS
  • dbt
  • Kafka
  • Snowflake
  • Airflow

Location

Work model
Hybrid
Region
United States
Office
  • Boulder, United States
Remote from
  • United States

Compensation

Salary
$90,000 - 136,000 / year
Pay period
Annual

Employment

Type
Full-time

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason