Data Engineer II

Yes Energy•Chicago, MA
•Hybrid

About The Position

Yes Energy provides electric power trading analytics and real-time visibility into data generated by the North American electrical grid. The Data Engineering team collects data and creates derivative datasets that help energy-market participants solve problems. As a Data Engineer, you will transform and integrate messy, disparate datasets into unified, well-modeled Snowflake data using scalable and reliable processes. You will build solutions that support completeness, correctness, and timeliness for large, complex time-series data. The role also offers opportunities to develop knowledge of energy markets, cloud-based software products, and SaaS businesses while applying technical, research, and customer-facing skills. The team makes extensive use of AI-assisted and agentic development, including coding agents and the harnesses that orchestrate them, alongside Snowflake, Spring, Kafka, and Oracle PL/SQL. The position is full-time and hybrid, based in Boulder, Colorado; Dedham, Massachusetts; or Chicago, Illinois. Minimal travel may be required, up to 10 days per year. The position reports to the Manager of Data Collections.

Requirements

  • At least 3 years of related data engineering experience.
  • At least 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.
  • Proficiency in Python for data processing and pipeline development, and shell scripting.
  • Ability to steward data quality problems and solutions, with a passion for data quality.
  • Creative problem-solving skills and comfort bringing structure to ambiguous, early-stage problems.
  • Analytical and troubleshooting skills.
  • Ability to apply a testing mindset to one's own code.
  • Ability to work effectively with AI agents and harnesses, including writing clear specifications, critically reviewing AI-generated code, and building tests and guardrails.
  • Ability to embrace a customer service mindset.
  • Strong communication, interpersonal, influence, collaboration, and leadership skills.
  • Familiarity with agile development methodologies.
  • Experience in a cloud environment; AWS is preferred, including services such as S3 buckets, Lambdas, and Kinesis.

Nice To Haves

  • Energy markets experience.
  • 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 such as dbt or Airflow.

Responsibilities

  • Design and build Snowflake transformation layers that combine internal and external data sources into unified, well-modeled datasets.
  • Ingest, profile, clean, normalize, and reconcile disparate data sources with different schemas, levels of granularity, identifiers, and update cadences.
  • Build scalable, reliable, well-tested data pipelines with monitoring, alerting, and data quality checks.
  • Design data models, shared keys, and cross-reference mappings that allow datasets from different systems to be joined and trusted.
  • Ensure the completeness, timeliness, quality, and integrity of Yes Energy data.
  • Partner with product management to prototype and validate 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 the team's use of these tools.
  • Provide off-hours support for built data pipelines, including nights and weekends as needed.
  • Create and maintain runbooks and technical documentation so the broader team can support pipelines.
  • Review, analyze, and tune Snowflake performance and cost efficiency.
  • Plan and coordinate data migrations and integrations between systems.
  • Contribute to departmental technical standards, including change control, configuration management, development methodology, and coding standards.
  • Support customers and internal teams with data-related questions.
  • Participate in product release testing.

Benefits

  • Competitive salaries and achievable bonuses.
  • Medical insurance.
  • 401(k) plan with matching.
  • Flexible vacation.
  • Flexible work schedules.
  • Funding for formal and informal professional development.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service