Senior System Analyst - SQL Developer

About Us

Brookfield Renewable, as one of the core businesses under Brookfield Corporation, is one of the world’s largest owners, operators, and developers of renewable power, with $125 billion of power assets under management. Our diverse portfolio of hydro, wind, solar, distributed energy, storage, and sustainable solutions extends across five continents, totaling over 46,000 megawatts of generating capacity. We use our operating capabilities, scale and global reach to develop and operate a high-quality clean energy portfolio in a responsible manner, helping accelerate the global transition to net zero.

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

The System Analyst will be a Digital Insights team member, responsible for responsible for designing and implementing cloud-based data solutions using various technologies such as Fabric, Fabric Data Factory, DevOps and SQL and require strong skills in data modelling, data ingestion pipelines (Microsoft Fabric), and SQL development. Reporting to the Director, Digital Insights, the Senior System Analyst will collaborate with internal and external stakeholders to deliver high-quality solutions that meet the business needs and comply with the established standards and best practices.

Key Responsibilities

- Design and implement data models to support analytics and reporting requirements.

- Develop and optimize data ingestion pipelines in Microsoft Fabric, ensuring efficient and secure data flow.

- Build and maintain SQL queries, stored procedures, and database structures for performance and reliability.

- Develop cloud-based systems and software integrations using Microsoft Fabric, Data Factory, SQL and DevOps.

- Conduct thorough testing to ensure system reliability and performance.

- Collaborate with external vendors and internal teams to configure and implement new features and applications.

- Analyze both functional and non-functional requirements to provide accurate estimates for development efforts.

- Stay informed about the latest Fabric features, updates, and enhancements to recommend improvements and optimizations.

- Engage with Citizen Developers and Power Users, offering guidance on best practices to enhance their effective use of Fabric platform.

- Document technical processes and maintain up-to-date documentation.

Knowledge and Experience Required

- Minimum of 5 years of experience in software development, including data modeling, SQL development (T-SQL, PL/SQL), and data ingestion pipelines.

- Experience with Microsoft Fabric, including Power BI, Purview, and DevOps.

- University or College degree in Computer Science, Information Technology, or a related field.

- Strong understanding of modern data architecture and integration patterns.

- Solid understanding of the Software Development Life Cycle (SDLC) and commitment to development best practices (naming conventions, error handling, logging, commenting).

- Practical knowledge of data analytics and proficiency with analytics tools to support informed decision-making.

- Proficiency in creating and managing SQL stored procedures (intermediate to senior level).

- Strong communication skills, with the ability to collaborate effectively with clients and team members.

- Curiosity and eagerness to learn new technologies and concepts.

- Strong planning, prioritization, and time-management skills, with the ability to manage multiple tasks under tight deadlines.

- Bilingualism in French and English is an asset.

- Microsoft Fabric and/or Microsoft Power BI Certification will be considered as an asset.

- Experience with data analytics tools (e.g., Alteryx)

Note: Offices continue to be central to collaboration and Brookfield’s identity. This position requires the employee to be on-site for a minimum of 4 days to perform most effectively.

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 thrive on the challenge to be our best and progressive thinking to keep growing. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

- 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 well-being, 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.