Database Engineer / Senior Database Engineer

TerraForm Power; New York (NY); Hybrid; USD 108,000 - 152,000; Full time

Job summary

The Database Engineer / Senior Database Engineer at TerraForm Power is responsible for designing, developing, and supporting enterprise-scale data and analytics solutions across TerraForm Power's renewable energy portfolio.

This role blends software engineering, data engineering, and cloud technologies to build scalable data platforms, automate workflows, and deliver analytical solutions to optimize renewable energy operations.

Qualifications

• Bachelor's degree in Computer Science, Data Engineering, Software Engineering, Electrical Engineering, Renewable Energy Engineering, or a related technical discipline.
• 5+ years of experience developing production software, data platforms, or engineering analytics solutions.
• Strong proficiency in Python with experience developing production-quality software.
• Strong SQL skills with experience designing and optimizing analytical data models.
• Experience developing ETL pipelines processing large-scale structured and time-series datasets.
• Strong understanding of distributed data processing concepts and cloud-based analytics platforms.
• Excellent analytical, communication, and problem-solving skills.
• Ability to work independently while collaborating effectively with cross-functional teams.
• Preferred: experience with utility-scale solar, wind, or battery storage operations.
• Preferred: Databricks, Apache Spark, Delta Lake, and cloud-native data platforms.
• Preferred: integrating SCADA systems, OT, and third-party APIs.
• Preferred: Streamlit or similar Python frameworks; forecasting or ML experience.

Responsibilities

• Data Engineering & Platform Development: Design, develop, and maintain enterprise-scale Python data pipelines within Databricks and Delta Lake environments.
• ETL & Ingestion: Build scalable ingestion pipelines integrating SCADA systems, weather providers, market data, and third-party APIs.
• Renewable Energy Performance Analytics: Design analytical solutions supporting lost production, curtailment, availability, degradation, and operational performance analysis.
• Data Quality & Engineering Excellence: Develop data quality frameworks including automated validation, reconciliation, anomaly detection, and monitoring.

Skills

Python

SQL

ETL pipelines

Distributed data processing

Cloud analytics platforms

Communication

Problem-solving

Education

Bachelor's degree in Computer Science, Data Engineering, Software Engineering, Electrical Engineering, Renewable Energy Engineering, or related

Tools

Databricks

Apache Spark

Delta Lake

Streamlit

Job description

Job Type: Exempt Salaried, Full-Time

Location: United States – New York, NY (Office Onsite / Remote)

Reports To: Manager, Performance Engineer

Department: Operations

About Us

TerraForm Power ("TERP"), a platform company of Brookfield Renewable, attracts high-performing individuals who are driven to make an impact in a fast-paced and collaborative environment. We offer unparalleled opportunity to lead and manage one of the largest renewable energy businesses with decades of history, while contributing to the global need for sustainable energy.

We offer tremendous growth opportunity for individuals with an entrepreneurial mindset. The company is committed to employee development, encouraging curiosity, ownership, and continuous learning. You’ll be empowered to take initiative, contribute ideas, and grow your career within a supportive and ambitious organization.

Job Summary

The Database Engineer / Senior Database Engineer is responsible for designing, developing, and supporting enterprise-scale data and analytics solutions across TerraForm Power\'s renewable energy portfolio.

This role combines software engineering, data engineering, and cloud technologies to build scalable data platforms, automate engineering workflows, and develop analytical solutions supporting renewable energy operations. The successful candidate will design production-grade data pipelines, build scalable applications, and contribute to the implementation of analytical solutions.

Depending on experience and level, the successful candidate will contribute to or lead engineering best practices, drive continuous improvement initiatives, mentor team members as appropriate, and support the long-term evolution of the Performance Engineering platform.

Key Responsibilities

• Data Engineering & Platform Development
  • Design, develop, and maintain enterprise-scale Python data pipelines within Databricks and Delta Lake environments.
  • Design resilient ETL frameworks supporting production-grade renewable energy analytics.
  • Build scalable ingestion pipelines integrating SCADA systems, weather providers, market data, and third-party vendor APIs.
  • Develop reusable engineering frameworks, shared libraries, and automation tools to improve platform maintainability.
  • Optimize Spark workloads, Delta Lake performance, and large-scale data processing pipelines.
  • Design robust data models, schema evolution strategies, and data governance standards.
• Renewable Energy Performance Analytics
  • Design analytical solutions supporting lost production, curtailment, availability, degradation, and operational performance analysis.
  • Integrate satellite weather datasets, forecasting services, and operational telemetry into engineering workflows.
  • Develop forecasting, regression, normalization, and reconciliation models supporting asset performance evaluations.
  • Develop and support fleet-wide engineering dashboards and performance monitoring tools.
• Data Quality & Engineering Excellence
  • Develop and maintain data quality frameworks including automated validation, reconciliation, anomaly detection, and monitoring.
  • Implement engineering best practices for testing, logging, exception handling, observability, and deployment.
  • Maintain technical documentation, metadata, and data dictionaries.
  • Participate in architecture reviews, code reviews, and engineering design discussions.
  • Contribute to the continuous improvement of platform reliability, scalability, and maintainability.

Skills & Qualifications

Required Qualifications

• Bachelor\'s degree in Computer Science, Data Engineering, Software Engineering, Electrical Engineering, Renewable Energy Engineering, or a related technical discipline.
• 5+ years of experience developing production software, data platforms, or engineering analytics solutions. Candidates with significant additional experience and demonstrated technical leadership may be considered for the Senior Database Engineer level.
• Strong proficiency in Python with experience developing production-quality software.
• Strong SQL skills with experience designing and optimizing analytical data models.
• Experience developing ETL pipelines processing large-scale structured and time-series datasets.
• Strong understanding of distributed data processing concepts and cloud-based analytics platforms.
• Excellent analytical, communication, and problem-solving skills.
• Ability to work independently while collaborating effectively with cross-functional teams.

• Preferred Qualifications
• Experience with utility-scale solar, wind, or battery storage operations.
• Experience with Databricks, Apache Spark, Delta Lake, and cloud-native data platforms.
• Experience integrating SCADA systems, operational technologies, and third-party vendor APIs.
• Experience building engineering applications using Streamlit or similar Python frameworks.
• Experience with statistical modeling, regression analysis, forecasting, or machine learning.

Compensation: $108,000 - $130,000 (Engineer), $125,000 - $152,000 (Senior Engineer); bonus eligible

Recruitment Agency Notice

TerraForm Power Human Resources team does not accept unsolicited resumes from third party recruiters, staffing firms, or related agencies. The Human Resources team coordinates all recruiting and hiring at our company. We do not accept resumes from third-party recruiters unless authorized by the Human Resources team and if a signed agreement is in place. Any unsolicited resumes will be considered property of TerraForm Power and we are not responsible for any related fees. All communication related to recruiting partnerships should ONLY be directed to the Human Resources team.