Consultant, Business Intelligence and Data Analytics

Canadian Imperial Bank of Commerce; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive salary

Benefits program

Paid day off

Job summary

Canadian Imperial Bank of Commerce (CIBC) seeks a Consultant, Business Intelligence and Data Analytics to make complex data accessible and actionable for business partners. You will support the end-to-end reporting lifecycle, transforming data with Databricks and delivering clear Power BI visualizations to inform decision-making.

The role offers a hybrid work arrangement with 1–3 days on-site and remote days, focusing on governance, analytics, and workflow automation using Power Automate.

Qualifications

• Experience with end-to-end reporting lifecycle from data sourcing to reporting.
• Ability to transform business requirements into high-quality dashboards and analytics.
• Knowledge of data governance and BI best practices.

Responsibilities

• Support the end-to-end reporting lifecycle from data sourcing to insights delivery.
• Use Databricks for data preparation, transformation, and analysis, and deliver Power BI dashboards.

Skills

Databricks

Alteryx

Power BI

SQL

Python

Data modelling

Data design

Power Automate

Education

Bachelor's degree in Computer Science, Mathematics, Engineering, or related field

Tools

Databricks

Alteryx

Power BI

SQL

Python

Job description

What you’ll be doing

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.

How you’ll succeed

• Innovation and simplification - Strive for continuous improvement in data quality and help simplify reporting, governance, and operational processes through thoughtful analysis, automation, and the effective use of business intelligence tools.
• Data analysis and business requirements - 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.
• Data sourcing, transformation, and reporting - Support reporting processes using data from centralized cloud-based storage environments. Use Databricks for data preparation, transformation, and analysis, and deliver meaningful insights through Power BI.
• Visualization and insight delivery - 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.
• Workflow automation and process support - 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.
• Continuous improvement - 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.

Who you are

• You can demonstrate experience in Databricks, Alteryx, Power BI, SQL, Python, data modelling, and data design to support data transformation, reporting, dashboard development, and visualization.
• It’s an asset if you have experience using Power Automate to support workflow automation and process enablement.
• You have a degree or diploma in Computer Science, Mathematics, Engineering, or a related field.
• You also bring a minimum of 2 years of relevant experience in business intelligence, data analytics, reporting, and/or risk management.
• You know that details matter. You notice things that others don’t. Your critical thinking skills help to inform your decision making.
• You embrace and advocate for change. You continuously evolve your thinking and the way you work in order to deliver your best.
• You’re motivated by collective success. You know that teamwork can transform a good idea into a great one.
• You know that an inclusive team that enjoys working together can bring a vision to life.
• Values matter to you. You bring your real self to work, and you live our values - 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.

• 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.
• 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 [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, 1st Floor

Employment Type: Regular

Weekly Hours: 37.5

Skills: Data Analysis, Data Analytics, Data Designing, Data Reporting, Data Visualization

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.