Consultant, Business Intelligence and Data Analytics

CIBC•Toronto, ON

3d•Hybrid

About The Position

As a member of the Third-Party Governance Office (TPGO), the Consultant, Business Intelligence and Data Analytics plays an important role in making complex data more accessible, understandable, and actionable for our business partners. As a Consultant, Business Intelligence and Data Analytics, you'll support the end-to-end reporting lifecycle, from sourcing and transforming data to analyzing results and delivering meaningful insights. You'll use Databricks to prepare and analyze data, and Power BI to create clear, effective visualizations and reporting that support decision-making. Through your work, you'll help strengthen reporting capabilities, improve insight generation, and support risk-informed and operationally sound business outcomes. At CIBC we enable the work environment most optimal for you to thrive in your role. You'll have the flexibility to manage your work activities within a hybrid work arrangement where you'll spend 1-3 days per week on-site, while other days will be remote.

Requirements

Experience in Databricks, Alteryx, Power BI, SQL, Python, data modelling, and data design to support data transformation, reporting, dashboard development, and visualization.
Degree or diploma in Computer Science, Mathematics, Engineering, or a related field.
Minimum of 2 years of relevant experience in business intelligence, data analytics, reporting, and/or risk management.
Critical thinking skills.
Embrace and advocate for change.
Motivated by collective success and teamwork.
Values matter to you; bring your real self to work, and live CIBC values - trust, teamwork, and accountability.

Nice To Haves

Experience using Power Automate to support workflow automation and process enablement.

Responsibilities

Support the end-to-end reporting lifecycle, from sourcing and transforming data to analyzing results and delivering meaningful insights.
Use Databricks to prepare and analyze data.
Create clear, effective visualizations and reporting using Power BI that support decision-making.
Strengthen reporting capabilities, improve insight generation, and support risk-informed and operationally sound business outcomes.
Partner with business stakeholders to gather, assess, and document requirements.
Translate complex business needs into high-quality reporting and analytics solutions that support risk insights and operational decision-making.
Support reporting processes using data from centralized cloud-based storage environments.
Design intuitive, user-focused dashboards and reports that communicate trends, themes, and insights clearly and effectively.
Apply data storytelling and user experience principles to improve how insights are understood and used.
Use Power Automate to support and automate workflows related to data movement, reporting activities, approvals, notifications, and process tracking to improve consistency, transparency, and efficiency.
Stay current on industry best practices in business intelligence, data visualization, analytics, workflow automation, and data management.
Share recommendations that strengthen the team's reporting capabilities and overall user experience.

Benefits

Competitive salary
Incentive pay
Banking benefits
Benefits program
Defined benefit pension plan
Employee share purchase plan
Vacation offering
Wellbeing support
MomentMakers, our social, points-based recognition program
Purpose Day; a paid day off dedicated for you to use to invest in your growth and development