Database Engineer / Senior Database Engineer
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.
