Pattern Energy Group Data Engineer in Houston, Texas
Pattern Energy is an independent, fully integrated energy company that develops, constructs, owns and operates renewable energy projects and transmission assets across North America, Canada and Latin America. The company focuses primarily on wind and transmission with limited investments in other generation technologies.
The Pattern Energy team has a history as one of the top North American renewable energy and transmission providers in the industry. The team is dedicated to delivering the highest value for its customers, partners, financial supporters and the communities in which it works, while exhibiting a strong commitment to promoting environmental stewardship and corporate responsibility.
Pattern Energy operates in the United States, Canada and Latin America with offices in San Francisco, Houston, San Diego, New York, Toronto, Puerto Rico and Chile. Pattern Energy Group's corporate headquarters are in San Francisco.
The primary purpose of the Data Engineer is to oversee the development, maintenance, and support of the Pattern Operations data warehouse while working with internal and external customers to provide sustainable solutions to their data needs and requests. This role requires cross functional interaction across the company, while managing the oversight of multiple databases and software platforms. This role will develop an understanding of how renewable systems function and develop the skills to identify how data should be extracted, transformed, and loaded to properly meet end-user requirements.
The key responsibilities will include the following:
Work in cross functional teams to understand requirements, identify limitations, and agree on scope to properly develop and deliver on sustainable data solutions.
Leverage internal resources, contractors, or service providers to develop new data pipelines, improve existing systems, and transform data into a useable format given business constraints.
Help support Pattern Operations’ fleet management and reporting software platform (Power Factors), including the API and data warehouse processes.
Support data requirements for ad hoc studies as needed relating to fleet performance, equipment reliability, and root cause analysis.
Assist with engineering and meteorological studies related to wind and solar asset improvements (such as design changes and retrofit solutions) as well as to operations and maintenance improvements (condition monitoring systems, drone inspection technologies, lightning analytics, etc).
Develop analytics tools, reports, and dashboards using Power BI.
A bachelor’s degree in computer science, mathematics/statistics, physics, or engineering OR demonstration of equivalent work experience is required as a minimum.
2+ years of experience in ETL/ELT, database management, and cloud storage (College Work, internships or part time work may qualify)
Data Engineering background preferred.
Wind power operations or Electric Utility operations preferred but not required
Strong technical capabilities and a creative, curious, self-driven work ethic
Ability to work well with customers and support.
Ability to travel (Up to 10% travel)
Data Engineering knowledge in Microsoft SQL, Microsoft Azure (Data Factory, Databricks, Azure Synapse) or other cloud storage databases.
Demonstrated programming skills with software applications, databases, and historians that produce large time-series based data sets.
Proficient with Spark, Delta Engine/Delta Lake, Polybase, and/or BLOB storage.
Familiar with data visualization tools such as Power BI and Plotly.
Demonstrated excellence and ability to learn new programming skills and languages.
Familiarity with SCADA systems (particularly in electrical utility applications).
Ability to occasionally perform physical requirements including standing, sitting, walking, kneeling, twisting, reaching, and climbing at project locations in order to install or inspect equipment.
Ability to read and understand plans, specifications, drawings, and documents relating to computers and data systems.
Ability to quickly assess emergency situations and requirements and to develop and implement appropriate action plans
Pattern Energy Group is an equal opportunity employer
External Company Name: Pattern Energy Group LP
External Company URL: www.patternenergy.com
Street: 1201 Louisiana Street, STE 3200