
Data Engineer II, Data Core
Yes Energy1 day ago
Boston, MA, USA +2 moreMid Level
H1B sponsor
Base Salary
$90k - $136k/yr
Responsibilities
- Design and build Snowflake transformation layers that unify data from internal and external sources.
- Ingest, profile, clean, normalize, reconcile, and model disparate datasets with varying schemas, identifiers, granularity, and update cadences.
- Build scalable, reliable, tested data pipelines with monitoring, alerting, and data quality checks.
- Create shared keys and cross-reference mappings to support trusted data integration across systems.
- Partner with product management to prototype datasets and validate customer use cases.
- Use AI-assisted and agentic development tools for development, testing, documentation, and data validation.
- Provide off-hours support for owned pipelines, including nights and weekends as needed.
- Create runbooks and technical documentation for broader team support.
- Review and tune Snowflake performance and cost efficiency.
- Plan and coordinate data migrations and system integrations.
- Contribute to departmental standards for change control, configuration management, development methodology, and coding standards.
- Support customers and internal teams with data-related questions and participate in product release testing.
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.
- 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, preferably AWS with S3, Lambda, and Kinesis.
- Strong data-quality stewardship, analytical, troubleshooting, communication, collaboration, influence, and leadership skills.
- Ability to write specifications, critically review AI-generated code, and build tests and guardrails around AI agents and harnesses.
- Preferred qualifications include energy-markets experience, Oracle PL/SQL, large-scale time-series data, cross-domain data unification, and dbt or Airflow experience.
Benefits
- Full-time hybrid role based in Boulder, CO, Dedham, MA, or Chicago, IL.
- Minimal travel may be required, up to 10 days per year.
- Medical insurance, a 401(k) plan with matching, flexible vacation, and flexible work schedules.
- Competitive salaries and achievable performance-based bonuses.
- Employer-funded formal and informal professional development.
Tech Stack
Categories
Data Engineering
About Yes Energy
Yes Energy builds SaaS platforms, data feeds, and APIs that aggregate and standardize power market data for traders, utilities, and asset developers. Its tools support analysis and decision-making across North American ISO/RTO nodal markets, with delivery options including an all‑in‑one UI, data lake, and cloud databases. Founded in 2008 and headquartered in Boulder, Colorado, the privately held company reports daily use by over 1,000 market participants.