Log In
Sign Up
Database Developer I – Market Data Operations
Yes Energy is hiring for an early career Database Developer to join our team in our Boston office. As a Database Developer in the Data Operations Team, you will get to apply your analytical skills in a collaborative team environment to help build solutions which enable greater efficiency in the North American power markets. Our team manages the ingestion of over 120 million rows of energy market data per day which are critical for our customers’ real time decision making. In this role, you’ll perform operational work to maintain existing data collections streams and improve the completeness, correctness, and timeliness of 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.
Job Responsibilities
Ingest, clean, normalize, and combine non-uniform data sources through scraping websites, consuming data APIs, consuming FTR feeds, & more.
Build & utilize tools to ensure highest possible completeness, timeliness, quality and integrity of Yes Energy data
Maintain daily processes to monitor for data reliability, efficiency, and quality
Develop and maintain database stored procedures, views and functions for Yes Energy applications, both customer facing and internal
Participate in weekly rotation of data on-call shifts, including nights & weekends
Develop, implement, and maintain change control and testing processes for modifications to databases.
Creation and maintenance of technical documentation.
Knowledge Skills & Abilities
Experience writing Oracle PL/SQL, including: Procedures, Functions, Packages
Experience writing SQL queries, including: Common Table Expressions (CTEs), Single-row and Multi-row functions, complex joins, & more
Some python and shell scripting
Strong Communication Skills
Preferred Qualifications
Energy Markets Experience
Familiarity with agile development methodologies
Position Details
Full-time
Minimum travel may be required (up to 10 days per year)
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 85 amazing professionals located in Boulder, CO (HQ), Boston, MA and Chicago, IL.
Culture
Yes Energy has been named as 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 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: $65,000 – $75,000
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.
