Senior System Analyst - SQL Developer

Description

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.

• Collaborate with external vendors and internal teams to configure and implement new features and applications.
• Document technical processes and maintain up-to-date documentation.
• Stay informed about the latest Fabric features, updates, and enhancements to recommend improvements and optimizations.
• Develop cloud-based systems and software integrations using Microsoft Fabric, Data Factory, SQL and DevOps.
• Develop and optimize data ingestion pipelines in Microsoft Fabric, ensuring efficient and secure data flow.
• Engage with Citizen Developers and Power Users, offering guidance on best practices to enhance their effective use of Fabric platform.
• Conduct thorough testing to ensure system reliability and performance.
• Design and implement data models to support analytics and reporting requirements.
• Analyze both functional and non-functional requirements to provide accurate estimates for development efforts.
• Build and maintain SQL queries, stored procedures, and database structures for performance and reliability.

Requirements

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.

• Curiosity and eagerness to learn new technologies and concepts.
• Minimum of 5 years of experience in software development, including data modeling, SQL development (T-SQL, PL/SQL), and data ingestion pipelines.
• University or College degree in Computer Science, Information Technology, or a related field.
• Solid understanding of the Software Development Life Cycle (SDLC) and commitment to development best practices (naming conventions, error handling, logging, commenting).
• Strong understanding of modern data architecture and integration patterns.
• Proficiency in creating and managing SQL stored procedures (intermediate to senior level).
• Bilingualism in French and English is an asset.
• Strong planning, prioritization, and time-management skills, with the ability to manage multiple tasks under tight deadlines.
• Strong communication skills, with the ability to collaborate effectively with clients and team members.
• Microsoft Fabric and/or Microsoft Power BI Certification will be considered as an asset.
• Experience with Microsoft Fabric, including Power BI, Purview, and DevOps.
• Practical knowledge of data analytics and proficiency with analytics tools to support informed decision-making.
• Experience with data analytics tools (e.g., Alteryx)

Benefits

• 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 work to recognize you in meaningful, personalized ways including a competitive salary, bonus structure, a health benefits program, and defined contribution pension plan.

Training + Development

Interview process

Visa Sponsorship

Security clearance