We are currently seeking a Senior ETL Developer to join our Information Systems team to design, develop, and maintain data and ETL platforms that support the data needs across Energy Solutions. In this role, you will bring your expertise and leverage cutting-edge technologies in AWS to implement ETL for building Data platforms. This unique position is perfect for individuals with technical prowess in data field that want to have an impact on energy efficiency markets and greenhouse gas reductions through our work for major North American utilities and other clients around the country.

Energy Solutions has a remote-friendly work environment for staff located throughout the United States. We also have offices in Oakland and Orange California as well as Boston, New York and Chicago for those that wish to work from one of our offices.

Daily responsibilities include but are not limited to:

• Developing ETL Processes: Implementing ETL processes using relevant tools, technologies, and programming languages. This includes extracting data from various sources, performing data cleansing, transformation, and enrichment, and loading it into target systems.
• Data modeling and database design: Creating and optimizing data models and database schemas to ensure efficient data storage, retrieval, and query performance. This involves understanding data relationships, normalization/denormalization techniques, and dimensional modeling concepts.
• Performance tuning and optimization: Identifying and addressing performance bottlenecks in ETL processes and database operations. This includes optimizing SQL queries, tuning database configurations, and implementing caching mechanisms to enhance overall system performance.

Qualifications:

• Educational Background: A bachelor’s degree in computer science or information technology and 8+ years of relevant experience, or master’s degree in a related field. Candidates exhibiting 8 or more years of work experience using related technologies are also encouraged to apply.
• Programming Proficiency: High proficiency in programming languages commonly used in ETL development, such as PLSQL, SQL, Python. Ability to write efficient SQL queries, SQL store procedures, develop scripts for data transformations, and utilize programming frameworks and libraries to create/enhance ETL mappings and workflows.
• AWS Services: Expertise in utilizing AWS services, including but not limited to Amazon s3, glue, data catalog, Amazon redshift, redshift spectrum and Amazon Athena. Ability to leverage these services to build scalable, reliable, and performant data pipelines and analytics solutions.
• Proficiency in working with relational databases such as Postgres, Oracle, MySQL, or SQL Server. Knowledge of database design, optimization techniques, and advanced querying capabilities.
• Experience in performance tuning and optimizing database operations.
• Familiarity with data governance frameworks and data security best practices.
• Passion for learning new technologies, staying up to date with industry trends, and exploring innovative approaches to ETL development.

Salary DOE: $130K - $165K / Annually