Senior Consultant, Quality Assurance

We’re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what’s right for our clients.

At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are and what they contribute.

To learn more about CIBC, please visit CIBC.com

What You'll Be Doing

You'll join CIBC's Wealth Management – Azure Hub team as an L8 Sr Consultant/ QA ETL Tester. In this role, you'll lead quality assurance efforts for Databricks-based data pipelines, Azure Data Lake Storage (ADLS), and other Azure cloud data solutions. You'll create comprehensive test cases and test plans for the ETL stream, coordinate a team of QA testers, and ensure overall data quality with each release. Your strong SQL expertise will enable you to validate complex data transformations and business logic throughout the data warehousing lifecycle, including ETL type-1 and type-2 scenarios. You'll report directly to the Director and collaborate closely with experienced developers, system analysts, QA testers, and business partners to clarify requirements and track project milestones. Your leadership and technical skills will ensure our data assets are robust, accurate, and compliant with business needs.

At CIBC we enable the work environment most optimal for you to thrive in your role. Details on your work arrangement (proportion of on-site and remote work) will be discussed at the time of your interview.

How You'll Succeed

• Test Planning and Execution – Develop and maintain detailed test cases and test plans for ETL processes and data pipelines. Oversee the execution of manual and automated tests, ensuring coverage of all business and technical requirements.
• Team Coordination and Leadership – Coordinate the activities of QA testers, providing guidance and support to ensure quality standards are met for each release. Act as the main point of contact for QA within the project, reporting status and risks to the Director.
• Technical Expertise – Apply hands-on experience with Azure cloud environments, Databricks-based data pipelines, and Azure Data Lake Storage (ADLS). Write complex SQL queries to validate data transformations, reconciliations, and business logic. Ensure thorough end-to-end data warehousing testing, including ETL type-1 and type-2 scenarios.
• Stakeholder Engagement – Work with developers, system analysts, and business partners to clarify requirements and manage project milestones. Communicate test results, quality metrics, and risk assessments effectively to technical and non-technical stakeholders.

Who You Are

• You're an experienced QA and data professional. You bring 8+ years of hands-on experience in QA roles, specializing in ETL/data testing, data warehousing, and automation.
• You're an Azure and Databricks expert. You have proven expertise in Azure cloud environments, Databricks-based data pipelines, and Azure Data Lake Storage (ADLS).
• You're a SQL power user. Your strong SQL skills enable you to write complex queries for data validation and business logic testing.
• You're a data warehousing specialist. You have a deep understanding of end-to-end data warehousing testing and ETL type-1 and type-2 scenarios.
• You're a leader and collaborator. You excel at coordinating QA testers and working with cross-functional teams, including developers, system analysts, and business partners.
• You're a strong communicator. You clearly document and communicate test plans, results, and project status to stakeholders.
• Values matter to you. You’re committed to putting clients first, collaborating for success, and embodying CIBC’s values of trust, teamwork, and accountability.

What CIBC Offers

At CIBC, 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 aspire to give you a career, rather than just a paycheck.

• We work to recognize you in meaningful, personalized ways including a competitive salary, incentive pay, banking benefits, a benefits program*, defined benefit pension plan*, an employee share purchase plan, a vacation offering, wellbeing support, and MomentMakers, our social, points-based recognition program.

• Our spaces and technological toolkit will make it simple to bring together great minds to create innovative solutions that make a difference for our clients.

• We cultivate a culture where you can express your ambition through initiatives like Purpose Day; a paid day off dedicated for you to use to invest in your growth and development.

*Subject to plan and program terms and conditions

What you need to know

• CIBC is committed to creating an inclusive environment where all team members and clients feel like they belong. We seek applicants with a wide range of abilities and we provide an accessible candidate experience. If you need accommodation, please contact [email protected]

• CIBC is committed to clarity in our hiring process. All roles posted are opportunities we’re actively recruiting for, unless stated otherwise.

• You need to be legally eligible to work at the location(s) specified above and, where applicable, must have a valid work or study permit.

• We may ask you to complete an attribute-based assessment and other skills test (such as simulation, coding, French proficiency).

• We use artificial intelligence tools during the recruitment process. Our goal for the application process is to get to know more about you, all that you have to offer, and give you the opportunity to learn more about us.

Job Location

Employment Type

Weekly Hours

Skills