Data Engineer II

Yes Energy
Boston +2 more
Hybrid

Who this role is best for

Best suited to candidates with strong data modeling and transformation experience working in energy markets.

Best fit for

  • Candidates with 3+ years of SQL and Snowflake experience in energy markets
    — “At least 3 years of related data engineering experience”
  • Individuals who have successfully integrated and transformed messy data from multiple sources
    — “Demonstrated experience integrating and transforming messy data from multiple disparate sources into unified, production-grade datasets”
  • Proficient engineers comfortable with AI-assisted development and automation tools
    — “Use AI-assisted and agentic development tools and harnesses to accelerate development, testing, documentation, and data validation”

Things to consider

  • Off-hours support may be required, including nights and weekends
    — “Provide off-hours support for the data pipelines you build, including nights & weekends as needed”
  • Location flexibility is limited to Boulder, CO, Dedham, MA, or Chicago, IL
    — “Location: Boulder, CO, Dedham, MA, or Chicago, IL”

How to stand out

  • Emphasize experience with large-scale time series data in your resume and interviews
    — “Experience working with large-scale time series data”
  • Highlight your ability to build scalable, well-tested data pipelines with built-in monitoring
    — “Build scalable, reliable, well-tested data pipelines with monitoring, alerting, and data quality checks built in from the start”
  • Demonstrate your proficiency with AI-assisted development and your ability to review and refine its output
    — “Ability to work effectively with AI agents and harnesses: writing clear specifications, critically reviewing AI-generated code, and building tests and guardrails around it”
  • Showcase your ability to create unified data models and cross-reference mappings across systems
    — “Design data models, shared keys, and cross-reference mappings that allow datasets from different systems to be joined and trusted”
  • Include examples of your experience with data profiling, cleaning, and reconciliation across disparate schemas
    — “Ingest, profile, clean, normalize, and reconcile messy, disparate data sources with differing schemas, granularity, identifiers, and update cadences”
Pace · Fast PacedCollaboration · HighAutonomy · MediumDecision Impact · Team

Derived from job-description analysis by Serendipath's career intelligence engine.

What success looks like

  • Design and build transformation layers in Snowflake
  • Build scalable, reliable, well-tested data pipelines
  • Ensure the highest possible completeness, timeliness, quality, and integrity of Yes Energy data
  • Provide off-hours support for the data pipelines
Typical background
Data EngineeringData ScienceSoftware Engineering

Skills & requirements

Required

SnowflakeKafkaSpringOracle Pl/sqlData ModelingData IntegrationData PipelinesData QualityData TransformationData IngestionData CleansingData NormalizationData ReconciliationAi-assisted DevelopmentAgentic DevelopmentOff-hours SupportRunbooksTechnical DocumentationSnowflake Performance TuningData Migration

Preferred

PythonSQLETLData WarehousingBig DataTime Series Data

Stack & domain

SnowflakeSpringKafkaOracle Pl/sqlAi-assisted And Agentic DevelopmentLeadershipCommunicationProblem-solvingEnergy MarketsCloud-based Software ProductsSaas Businesses

About the role

Original posting from Yes Energy via Greenhouse

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.

Source: Yes Energy careers (Greenhouse)

Similar roles

More roles at Yes Energy