System Analyst – Oracle & SQL Developer

About Us

Brookfield Renewable is one of the core businesses under Brookfield Corporation (“Brookfield”), one of the world’s leading alternative asset managers. Brookfield Renewable is one of the world’s largest owners, operators, and developers of renewable power, with $102 billion of power assets under management. Our portfolio of hydropower, wind, utility-scale solar, distributed generation, and storage assets extends across North America, South America, Europe, India, and China, totaling almost 33,000 megawatts of capacity, and over 7,000 generating facilities globally.

Come Join Us

At Brookfield Renewable, we attract and retain high-performing individuals who are interested in making an impact, driving meaningful change and being part of a fast-paced and collaborative environment. Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. Together, we contribute to the success of one of the fastest growing and largest publicly traded, pure play renewable power platforms in the world while supporting decarbonization and greater energy sustainability to facilitate the global transition to a net-zero.

About the Role

Reporting to the Technology services Manager, the System Analyst-Oracle & SQL Developer will be a member of the Technology services team. The System Analyst-Oracle & SQL Developer will be responsible for maintaining, developing, and deploying database code and objects on Oracle and SQL Server platforms.

Key Responsibilities

- Respond to production incidents and support requests.

- Write complex SQL code to query data, fix bugs and implement enhancements

- Design and deploy various data objects including tables, views, indexes, stored procedures (T-SQL and PL/SQL)

- Plan and coordinate data migrations between systems

- Diagnose and resolve access and performance issues

- Create and maintain technical documentation

- Work within the support process standards (and improve when required)

- Provide periodic on-call support (24/7)

- SOX evidence reporting for databases

Knowledge and Experience Required

- University or College Degree in Computer Science/Technology or equivalent

- Advanced knowledge in database coding (T-SQL & PL/SQL)

- Demonstrated technical skills (5+years) with Oracle PL/SQL and SQL Server T-SQL, Postgres SQL

- Advanced knowledge Experience in root cause analysis and providing workarounds and solutions for DB code

- Good working knowledge of formal change management processes

- Familiarity with the main data manipulation languages and the principles of database design

- C# and .Net development experience are considered a valuable asset

- ETL is an asset

- UI / UX experience is an asset

- Strong analytical skills and critical thinking

- Ability to work in a fast-paced environment

- Strong planning, prioritizing and time management skills - must be able to undertake and manage multiple tasks at the same time and work under tight deadlines and operational pressures

- Ability to collaborate professionally with other teams

- Excellent communication skills (verbal and written)

Note: Offices continue to be central to collaboration and Brookfield’s identity. This position requires the employee to be on-site for 4 days to perform most effectively. We will reassess the approach on a as needed basis.

Working here, you will enjoy:

At Brookfield, your goals are a priority. We start with your strengths and ambitions as an employee and strive to create opportunities to tap into your potential.

- We work to recognize you in meaningful, personalized ways including a competitive salary, bonus structure, a health benefits program, and defined contribution pension plan.

- Our spaces are open, dynamic, and collaborative, giving you access to different businesses and teams. For your wellbeing, our building is equipped with a modern gym, bike storage, and healthy snacks and drinks.

- We cultivate a culture where we invest in your growth and development.

Diversity & Inclusion

Brookfield Renewable embraces and promotes the principles of diversity, equity, and inclusion. We welcome and encourage applications from all qualified candidates, including women, Indigenous peoples and other persons of all races, ethnic origins, religions, abilities, sexual orientations, and gender identities and expressions. We also provide accommodation during all parts of the hiring process, upon request. If contacted to proceed to the recruitment process, please advise us if you require any accommodation.