Data Engineer II, Data Core

Yes Energy•Boston, MA
•$90,000 - $136,000•Hybrid

About The Position

Yes Energy is hiring a Data Engineer II for its Data Engineering team. The role focuses on transforming and integrating messy, disparate datasets into unified, well-modeled data in Snowflake through scalable and reliable processes. The team collects data and creates derivative, value-added datasets for participants in energy markets. The engineer will design solutions for large, complex time-series data, emphasizing completeness, correctness, and timeliness. The position offers opportunities to deepen knowledge of energy markets, cloud-based software products, and SaaS businesses while developing technical, research, and customer-facing skills. AI-assisted and agentic development are central to the team's approach, alongside technologies including Snowflake, Spring, Kafka, and Oracle PL/SQL. This is a full-time, hybrid position based in Boulder, Colorado; Dedham, Massachusetts; or Chicago, Illinois. Minimal travel may be required, up to 10 days per year. The salary range is $90,000–$136,000. The position reports to the Manager of Data Collections and includes off-hours support for pipelines, including nights and weekends as needed.

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.
  • Experience in a cloud environment; AWS is preferred, including services such as S3, Lambda, and Kinesis.
  • 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.

Nice To Haves

  • Experience in energy markets.
  • 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 sources into unified, well-modeled datasets.
  • Ingest, profile, clean, normalize, and reconcile 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.
  • Design data models, shared keys, and cross-reference mappings to enable 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 and turn ideas into datasets that demonstrate customer value.
  • Use AI-assisted and agentic development tools to accelerate development, testing, documentation, and data validation, and help refine their application within the team.
  • 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 for 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

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