Consultant, Compliance Reporting & Analytics

CIBC; Toronto; Hybrid; CAD 85,000 - 120,000; Full time

Benefits offered by this job

Competitive salary

Incentive pay

Employee share purchase plan

Pension plan

Wellbeing support

Job summary

CIBC in Toronto is seeking a data management and analytics professional to join the Compliance Reporting & Analytics and help the C&GRA team turn data into actionable insights. You will design data models, build dashboards, and partner with stakeholders to meet data governance requirements.

The role also covers process automation using Power Platform, Python, and VBA, with 3+ years of experience in fast-paced analytics environments and experience in Azure SQL, SQL, and data warehousing to enable

Qualifications

• Experience designing and optimizing relational databases including Azure SQL, MySQL, or Oracle.
• Ability to develop dashboards and reporting solutions for stakeholders.
• Knowledge of data governance, metadata, and secure data access practices.

Responsibilities

• Configure and optimize data tables, models, and relationships to support system integration and high-quality data.
• Lead analytics initiatives using Power BI to build dashboards, reports, and visualizations delivering actionable insights.
• Automate business processes using Power Platform, Python, VBA to reduce manual effort and improve data quality.
• Collaborate with Technology and Compliance teams to implement data architecture and satisfy governance requirements.

Skills

Data analytics

Data management

Data visualization

Dashboard development

SQL

Python

Power BI

Excel

Collaboration

Education

Bachelor’s or Master’s in CS/Math/Engineering or related field

Tools

Azure SQL Database

MySQL

Oracle

Power BI

Python

R

Power Platform

VBA

Excel

SharePoint

Job description

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 be joining CIBC's Compliance Reporting & Analytics and play a key role in helping the Compliance & Global Regulatory Affairs (C&GRA) team harness the power of data to make informed decisions. The role will collaborate with members of the C&GRA team to understand their data needs, develop data management and governance strategies, and implement solutions to drive business objectives. The objective of the role is to perform data management for the Compliance team to produce consumable and measurable data that is timely, high quality, in a consumable format and meets all CIBC data governance requirements. 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.

Data Management, Analytics & Visualization

Configure and optimize data tables, models, and relationships to support seamless system integration and high-quality data. Lead analytics initiatives using Power BI and other tools to build scalable data-collection solutions, dashboards, reports, and visualizations that deliver actionable insights, improve efficiency, and support informed decision-making.

Process Automation

Leverage business-managed automation tools and technologies, including Microsoft Power Platform, Python, VBA, and other low-code or scripting solutions, to identify, design, develop, and implement improvements to internal business processes. Focus on reducing manual effort, improving process consistency and data quality, strengthening operational controls, and increasing overall efficiency. Partner with stakeholders to assess automation opportunities, document requirements, test solutions, support implementation, and maintain scalable, user-friendly tools that deliver measurable business value.

Collaboration, Compliance & Stakeholder Engagement

Partner with Technology and Compliance teams to implement and maintain data architecture, tools, and data assets that enable secure, reliable access to data. Ensure alignment with enterprise data management requirements, including data quality, metadata, and access management, while executing the data management roadmap. Respond to stakeholder requests by designing and delivering tailored data and analytics solutions that support C&GRA business needs.

Who you are

You have a Bachelor's or Master's Degree (or equivalent) in Computer Science, Mathematics, Engineering (or other related field) or equal work experience (3+ years) in a fast paced data and analytics environments. You can demonstrate experience in database management, including the design, configuration, and optimization of relational databases (e.g., Azure SQL Database, MySQL, Oracle); data modelling and normalization; performance tuning; backup and recovery; data quality; metadata; and secure access management practices. Experience with data analytics, visualization, and process automation tools - including Excel, Power BI, SQL, Python, R, Power Platform, and VBA—is an asset, along with the ability to develop dashboards, reporting solutions, and scalable data assets that support stakeholder needs and informed decision-making. You have knowledge of web-based tools (e.g. SharePoint) to create data sharing hubs comprised of source date and/or data visualization reports. You can demonstrate excellent time management skills to prioritize business needs and work on multiple projects simultaneously. You are collaborative and have the ability to work effectively within cross-functional teams and independently. You understand data management, data warehousing, data mining, data movement tools, and data privacy. You live your values. You bring high standards, genuine care to your relationships, and want to grow with an employer that shares your values and brings out your best.

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.

• competitive salary
• incentive pay
• banking benefits
• a benefits program
• defined benefit pension plan
• an employee share purchase plan
• a vacation offering
• wellbeing support
• MomentMakers, our social, points-based recognition program

*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 [e-mail] 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

Toronto-81 Bay, 31st Floor

Employment Type

Regular

Weekly Hours

37.5

Skills

• Data Access
• Data Analytics
• Data Management
• Data Mining
• Data Processing
• Data Quality
• Data Science
• Data Warehousing (DW)

At CIBC, we are in business to help our clients, employees and shareholders achieve what is important to them. Our ability to create value for all CIBC stakeholders is driven by a business culture based on common values: Trust, Teamwork and Accountability. Working with CIBC makes you a part of a work environment committed to our clients, employees and communities - a place where you can excel. Every day, our 48,000 employees help our clients achieve their financial goals, because what matters to our clients, matters to us.