> Markdown version of [/jobs/ext/4771439-data-engineer-ii](https://www.wearedevelopers.com/jobs/ext/4771439-data-engineer-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer II - **Company:** Yes Energy, LLC - **Location:** Chicago, IL, United States - **Experience:** Experienced - **Salary:** $90,000 - $136,000 - **Contract:** Permanent contract - **Skills:** Agile Methodology, Artificial Intelligence, Airflow, Amazon Web Services, Cloud Computing, Configuration Management, Code Generation, Data Validation, Information Engineering, Data Transformation, Programming Tools, Python (Programming Language), Oracle SQL Developer, Performance Tuning, Process Driven Development, Shell Script, SQL Databases, Systems Integration, S3 Bucket, Data Processing, Snowflake, AWS Lambda, AI Coding Agents, Agentic-AI, Kubernetes, Data Management, Software Coding, Data Pipelines - **Published:** November 18, 2026 - **Apply:** https://startup.jobs/data-engineer-ii-data-core-yes-energy-10805398 ## About the Role * 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.), * 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) ## Description 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., * 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