Database Developer I (Pl/Sql)

Database Developer I (PL/SQL)

Yes Energy, LLC

Join the Market Leader in Electric Power Data and Analytics 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, and mid to long-term investment decisions that keep utility prices low, support the energy transition, 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 currently working in a hybrid environment and are seeking to fill one full time Database Developer II position immediately in Boston, MA and Boulder, CO.

About the team

At Yes Energy, we help our clients not just get through the day ahead, but win the day ahead. We do this by providing Better Data, Better Delivery, and Better Direction.

Our Market Data Operations (MDO) team is dedicated to not just data, but to delivering data excellence. We deliver better data everyday so customers can make informed decisions to ensure grid reliability, always. Our commitment to supplying better data is not just a statement; it’s our identity and our promise to customers. Like a control room operator who is constantly monitoring the grid and making adjustments to ensure stability, our team is constantly monitoring our data pipelines and making adjustments to ensure data accuracy and reliability.

Our team's passion drives our work, and we are wholeheartedly devoted to guiding clients through the intricate and ever-changing landscape of North American Energy Markets. We operate in a collaborative environment, where we constantly seek ways to enhance our processes to provide our clients with the finest quality data possible. That's the essence of "better data" at Yes Energy.

About you

• You have a passion for working with inherently messy data

• You believe that a deep understanding of the data leads to better solutions

• You have a competitive attitude, taking ownership and accountability of the work you produce

• You have strong problem-solving skills and a curious mindset

• Like to design, develop, analyze and troubleshoot code

What you will do

• Maintain our real-time data pipelines to ensure we provide reliable and accurate information to our clients

• Support clients by answering complex data questions, providing timely and effective solutions, so that we can empower our clients to make informed decisions

• Ensure highest possible quality and integrity of Yes Energy data; recommend and implement ways to improve data reliability, efficiency, and quality

• Ensure database performance through proactive review and analysis

• Plan and coordinate data migrations between systems

• Creation and maintenance of technical documentation

• Participate in weekly on-call rotations to help resolve critical data pipeline failures for our clients

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 ETL tools and complex data pipelines.

• Energy industry experience or experience in equities/commodities trading

• Experience with web scraping including HTML parsing, HTTP protocols and network logs

• Basic python and shell scripting knowledge is nice to have.

• Passion for optimizing system performance.

• 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

Position Details

• Full-time

• Reports to Data Operations team Lead

• Minimal travel may be required (up to 10 days per year)

Keywords:

Oracle, SQL, PL/SQL, REST API, Time Series Data, ETL, CLI tools.

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 over 200 amazing professionals located across the core offices in the USA, Europe and Asia.

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

Salary Range - 80,000 - $115,000

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.