Job Title: Senior Data Engineer
Full-Time40 Hours/Week
Classification: exempt under FLSA
Location: 100% Remote
About
CleanChoice Energy, a national renewable energy company that empowers people and businesses to cut emissions and live cleaner, healthier lives, is seeking a Senior Data Engineer to join the Data Development department. This is a unique opportunity to join a mission driven organization transforming the U.S. electricity market by switching homes and businesses to 100% clean, pollution-free energy.
Job Description
Responsibilities
- Design, develop, optimize, and maintain data architecture and pipelines that adhere to ETL principles and business goals.
- Solve complex data problems to deliver insights that help the organization's business to achieve their goals.
- Create data products for analytics and data scientist team members to improve their productivity.
- Advise, consult, mentor and coach other data and analytic professionals on data standards and practices.
- Foster a culture of sharing, re-use, design for scale stability, and operational efficiency of data and analytical solutions.
- Lead the evaluation, implementation and deployment of emerging tools and process for analytic data engineering to improve the organization's productivity as a team
- Partner with business analysts and solutions architects to develop technical architectures for strategic enterprise projects and initiatives.
- Design, develop, and maintain data (warehouse) solutions
- Optimize and certify the database schema design so that data is highly available.
- Determine how the enterprise’s data will be stored and utilized to best provide actionable data to the end user.
- Test and support complex logical database designs for the data
- Improve system performance by conducting tests, troubleshooting, and integrating new elements.
- Perform identification and planning of future data (warehouse) concepts.
- Monitor database jobs and data loads to provide proactive resolution of issues to ensure maximum up-time and availability of databases for reporting.
- Develop, test, and improve database backup and recovery procedures and documentation.
- Approve, schedule, plan, coordinate, and perform the installation and testing of new data sources and code, and ensure version control is enforced.
Qualifications and Skills
- Excellent communication skills – oral, written, presenting, creation of report outs etc.
- 4-year degree in a technical discipline, or equivalent in related work experience.
- Experience building and testing a data warehouse or other enterprise solutions. As well as performing Data Warehouse implementation, deployment, operation, monitoring, and support.
- Experience installing, maintaining, and troubleshooting applications related to the Data Warehouse.
- Experience providing technical support to employees on database, application, and web server issues that will ensure maximum efficiency with minimal downtime.
- Knowledge of (energy) retail and/or power generation
- Experience with relational database management and data transformation (PostgreSQL, MsSQL, MySQL, etc.). Ability to work with AWS cloud based data platforms and columnar stores is a plus (Redshift, Snowflake, etc.)
- Experience with ETL/ELT design patterns and tools (SSIS, Matillion, Airflow, etc.)
- Knowledge of data types and data modeling practices, for structured and unstructured data
- Experience writing software or scripting is preferred (primarily Python or Javascript). Ability to work with web APIs and software SDKs is a plus
- AWS Certifications are highly desired (AWS Certified Data Engineer)
Travel
Compensation
This position offers compensation commensurate with experience and skills, and a robust benefits package.
www.cleanchoicenergy.com/careers.
About CleanChoice Energy
Our mission is to transform the U.S. electricity market by switching homes and businesses to 100% clean, pollution-free energy. We are working toward a world free of catastrophic climate change with pure, clean air and abundant renewable energy by providing renewable energy to everyone everywhere.