Renewable Data Engineer

Job description

DESCRIPTION

Do you love transforming raw data to business critical decisions? Are you excited to be a part of a more renewable, sustainable future?

The AWS Renewable Energy Team is looking for a passionate, results-oriented Renewable Energy Data Engineer to build our renewable energy data platform. The candidate will help AWS march toward its goal of powering our global data center infrastructure with 100% renewable energy. This role will work with data on a scale unique to our business. Collaborating with our data scientists, the Data Engineer will turn this data into valuable business information. This information will drive solutions to problems regarding the optimization of data center power procurement and renewable energy projections.

A successful candidate will streamline data collection process, build automation tools, enhance the quality of the data, and develop the visual dash boarding to monitor our renewable energy portfolio performance and identify new financial opportunities. We obtain this information from multiple sources via APIs, SCADA systems, utility online portals, real estate and construction databases and documents, internal Redshift databases, accounting systems, invoices, and energy trading platforms. The ideal candidate will know how to design logical schemas that organize data in a meaningful, efficient way and understand how to build scalable and maintainable data pipelines. This candidate is an expert at data modeling, ETL design and business intelligence tools, and has hands-on knowledge of databases such as Redshift. The Data Engineer will partner closely with internal customers and research scientists to invent new technical solutions to highly complex energy data analytics problems.

Desired profile

BASIC QUALIFICATIONS

· Bachelor's degree in computer science, engineering, mathematics, or a related technical discipline
· 3+ years of relevant experience data engineering or business intelligence roles
· 2+ years of experience in scripting languages such as Python, Ruby, Perl, Bash
· 2+ years of database experience in database schema design, writing advanced SQL queries, data warehousing in Redshift, Oracle, MySQL, or other relational database systems
· 2+ years of experience with ETL and report automation
· 1+ years of experience creating visual data representations, such as Tableau, QuickSight, or other BI platforms