Junior Data Engineer

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