View Jobs Description

Data Pipeline Engineer I

Join the Market Leader in Electric Power Trading Solutions

Our unique and innovative view of the data informs real-time financial and operational decisions that keep utility prices low and the grid reliable. This drives innovation in this critical infrastructure. It’s challenging work with a purpose.

Be a part of our successful, growing business during national transformation.

Position Summary

We are a company that collects and distributes tens of millions of data points a day and we are professionals that pride ourselves on delivering this data on time everytime.

We are a team of tech nerds fiercely dedicated to enabling success across Yes Energy.

• Full-Time
• Hybrid
• Reports to: VP, Technology
• Location Preference: Boston, MA (preferred), Richmond, VA, or Boulder, CO
• Salary range: $80,000 - $90000

Primary Responsibilities:

• Data Engineering / Modeling
• Assist in the design, development, and maintenance of Extract, Transform, Load (ETL), and Change Data Capture (CDC) Replication tools and processes to ensure efficient and accurate data flow across systems
• Collaborate with senior team members to develop and maintain data models that support analysis and reporting across the organization
• Write and optimize complex SQL queries to extract, transform, and load data as required
• Develop scripts to automate data processing and analytic tasks, ensuring data accuracy and timeliness
• Work closely with data analysts, data scientists, and other stakeholders to understand data needs and deliver high-quality solutions
• Maintain clear and comprehensive documentation of data processes, models, and systems
• Data Quality
• Ensure the accuracy and reliability of data through validation, monitoring, and troubleshooting processes
• Connect with data stakeholders to understand company reporting initiatives, helping to translate them into actionable projects
• Participate in code reviews and contribute to improving data engineering practices and processes within the team
• Staying current with industry best practices and tools, continually improving data pipelines and analytics workflows

• Bachelor’s degree in Information Systems, Business, Computer Science or a related field
• Proficient in SQL and experience with relational and non-relational database query techniques
• Experience a relational database solution (e.g., Snowflake, Oracle, MSSql, My SQL)
• Familiar with data modeling tools and practices.
• Experience working with server operating systems (e.g., Windows Server, Linux)
• Familiar with database replication tools or techniques
• Familiar with or desire to learn about data infrastructure technologies such as Scripting, JBDC, ODBC, etc.

• Experience working in agile data teams.

• Enthusiastic about enabling data and analytics across a wide variety of stakeholders (both technical and non-technical)
• Ability to troubleshoot and resolve data-related issues effectively in both team-based and individual settings
• Strong verbal and written communication skills, with the ability to collaborate effectively with team members and stakeholders
• Capable of supporting various data engineering, modeling, architecture, and reporting tasks
• Eager to grow their skills and contribute to a quickly growing business
• Ability to work well within a team environment, contributing to shared goals

Keywords

Data Science, ETL, SQL, Analytics, CDC, Replication, Airbyte, DBT, Kafka, Sigma, Power BI, Reporting, Data Quality, Python, Snowflake, Data Warehousing, RDBMS

About Yes Energy

Overview

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 over 300 amazing professionals across the United States, Europe, and Asia.

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 solutions that align 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- with a consistent ethic across the company.
• We’re team-focused with a flat hierarchy. We work in small teams on well-defined projects directly impacting the business's success.
• We play to each person's strengths and experience 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 and an opportunity to learn and contribute in many ways.
• We are constantly growing. Professional development happens every day and every year.

You may be just the right candidate for this or other roles.

Compensation and Benefits

Yes Energy encourages and funds investment in both formal and informal professional development.

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.

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.