QA Analyst, Business Intelligence – BI/ETL/Synapse

Role Overview

• Test ETL/ELT processes and BI transformations;
• Validate Synapse integration, storage, and analytics components;
• Ensure data governance and data quality;
• Automate pipeline tests;
• Contribute to functional and integrated testing with BI and data teams.

Requirements

• Strong experience in BI/ETL;
• Deep knowledge of Synapse Analytics;
• Understanding of semantic models and BI pipelines;
• Comfortable with validation scripts and APIs;
• Technical expertise including:
• Synapse Pipelines, Linked Services, Spark Notebooks;
• Azure Storage, Key Vault, Functions;
• Advanced networking & security (VNet, Private Endpoints, Subnets);
• ETL/ELT, Medallion architecture;
• BI tools: Semantic Models, Gateways;
• Scripting: PySpark, PowerShell, Bash;
• API testing: Postman.
• French: Advanced
• English: Intermediate
• Please note that intermediate English is required due to the nature of the tasks, including frequent communication with Quebec employees and managers.

Tech Stack

• Azure
• ETL
• PySpark
• Spark
• Vault

Benefits

• Work-life balance helps us stay at our best. We offer flexible work options, and with our Unlimited Vacation Plan, you can rest and recharge when you need it most.
• Your contributions matter. From day one, our total rewards package offers a comprehensive compensation plan, including short-term incentive programs.
• Our benefits are designed with optimal health and wellness in mind. You’ll have access to 24/7 virtual healthcare, as well as an extensive wellness portal that provides tools and resources to support your physical, mental, emotional and financial well-being.
• Refining your expertise is essential in a rapidly evolving industry, and we support your continuous growth every step of the way. Through partnerships with world-renowned education leaders, we provide access to thousands of top-rated online courses and certifications. With exclusive leadership programs designed to empower you to lead your teams with confidence and deliver impactful outcomes, and with a tuition reimbursement program for external training, we set you up for success to thrive and achieve your ambitions.
• Through our Employee Share Purchase Plan with matched contributions, you become a stakeholder, sharing in our growth and directly benefiting from our collective achievements.
• The diversity of our backgrounds, experiences, thoughts and insights is our competitive advantage. We foster a collaborative environment rooted in our core values of respect, well-being, passion, trust, integrity and creativity. For us, diversity, equity and inclusion aren’t just buzzwords; they’re essential drivers of innovation and excellence, and powerful catalysts for inspiration and evolutionary ideas. The empowerment of our people is fundamental to being the trusted advisor to our clients. Join us in embracing our authenticity and in leveraging our unique perspectives to collectively build the future we all envision.
• Fostering an environment where you can thrive starts with ensuring an accessible recruitment process. If you require any accommodations, we welcome you to contact us.