Data Engineer I

Data Engineer I

Yes Energy, LLC

Join the Market Leader in Electric Power Trading Solutions

The electrical grid is the largest and most complicated machine ever built. Yes Energy’s industry leading electric power trading analytics software provides real time visibility into the massive amount of data that is generated by the North American electrical grid every day. Our unique and innovative view of the data informs real time trading decisions that keep utility prices low and the grid up and running. It’s both challenging work and work with a purpose.

Be a part of our successful, growing business.

We are seeking to fill one full time Data Engineer I position immediately in our Chicago, IL office.

Impact Statement

As a Data Engineer I, in the Data Engineering team, you will apply your design and coding skills in several areas including: database development for data collections, client and internal support, and software testing. The Data Engineering team serves an important role for all participants in the energy markets. This team is tasked with collecting new data and creating derivative, value-added datasets from that data to help our clients solve problems. Your design solutions are built to ensure the highest level of data completeness, correctness, and timeliness for real time data streams of large, complex time series data.

This position offers candidates an opportunity to develop greater knowledge of energy markets, cloud-based software products, and SaaS businesses, while applying and developing technical, research, and customer-facing skills with one of the most creative and hard-working staff in the industry. We encourage you to build our products with exciting technologies including Oracle PL/SQL, Amazon Web Services and Snowflake.

You would be a great fit if you…

• Want to design and implement complex, yet intuitive, ways to process, ingest, and transform large data sets – We love our customers and we love to give them a high-quality user experience

• Enjoy working with engineers across experience levels using leadership, mentorship, and followership skills – We have a culture of learning and constantly invest in each other’s growth

• Have a testing mindset and want to help promote and lead our ongoing journey towards continuous testing – We believe in building quality in from the beginning

• Are a curious person who likes to learn new things and dive into challenging problems – We can get pretty nerdy about our industry, and it is constantly evolving!

• Are seeking a collaborative, cross-functional team who uses agile software development methodologies – We believe that comradery and collaboration make us better

What you will do with us…

• Ingest, clean, normalize, and combine non-uniform data sources through scraping websites, consuming data APIs, consuming FTP feeds, etc.

• Ensure highest possible completeness, timeliness, quality and integrity of Yes Energy Data

• Create/design new data structures which provide optimized value to customers and their changing reporting needs.

• Maintain database packages, procedures, views, functions, Oracle types for internal systems, metadata systems and related internal tools and tools.

• Support customers with data-related questions

• Ensure database performance through proactive review and analysis

• Participate in weekly rotation of data on-call shifts, including nights & weekends

• Plan and coordinate data migrations between systems

• Contribute to technical departmental standards in such areas as change control, configuration management, development methodology, and coding standards

• Ensure all database systems meet business and performance requirements

• Creation and maintenance of technical documentation

• Participate in product release testing

We do ask that you have…

• 1-2+ years of relevant experience (depending upon education).

• 1+ years experience with SQL. Experience with PL/SQL is a plus.

• Familiarity with data integration and ETL tools.

• Basic python, shell scripting, or OOP languages knowledge are nice to have.

• Passion for optimizing system performance and scalability.

• Stewardship of data quality problems and solutions; passion for data quality

• Creative problem solving abilities

• Analytic and troubleshooting skills

• Ability to apply a testing mindset to own code

• Ability to embrace a customer service mindset

• Strong communication, interpersonnel, influence, collaboration and leadership skills

• Familiarity with agile development methodologies

You will stand out if you have…

• Have experience with TDD and/or continuous testing

• Have a desire to learn the energy industry

About Yes Energy

Overview

Yes Energy delivers real-time market data and electric power trading decision solutions. Over 1,000 market participants use Yes Energy solutions daily. The business is a leader in all aspects of information content collection and management, as well as in developing and delivering data and market analytics solutions. 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 just over 100 amazing professionals located in Boulder, CO (HQ), Boston, MA and Chicago, IL.

Culture

At Yes Energy we care about saying “Yes” to customers. We like to listen and learn, and develop our solutions in line with our customers’ needs. We think about customers as business partners and when we help them to 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-- in an ethic that is consistent across the company;

• We’re team-focused with a flat hierarchy-- we work in small teams on well-defined projects that directly impact the success of the business;

• We play to the strengths and experience of each person, while each of us also works along a continuum of roles adjacent to our focus area. This presents a challenge of maintaining a broad set of skills as well as an opportunity to learn and contribute in many ways;

• We are constantly growing. Professional development happens every day and every year.

Compensation and Benefits

We offer strongly competitive salaries and real bonuses that are achievable and that you can impact. Our benefits package is also very competitive and it includes medical insurance, 401K Plan with matching, flexible vacation and flexible work schedules. Investment in both formal and informal professional development is encouraged and funded by Yes Energy.

Base Compensation Range: $85,000 - $115,00 depending on experience and location.