Consultant, Reporting and Analytics

CIBC•Toronto, ON

1d•Hybrid

About The Position

As a member of CIBC’s Capital Markets Technology team, the Consultant, Reporting and Analytics is responsible for supporting the delivery of advanced advice in data analytics, providing research and insights, and ensuring senior management has the relevant information to make informed decisions. The Consultant, Reporting and Analytics applies strong problem framing and solving skills, translate business questions to data requirements and analytical solutions; provides insights that inform decisions influencing department strategy, performs in-depth analysis of research information to identify opportunities, develop relevant dashboards, and makes recommendations for business use. The role performs tasks of technical depth and breadth, utilizing a solid understanding of business dynamics to conduct impact analysis and provide feedback on problems with recommended solutions involving Business Intelligence. 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 2-3 days per week on-site, while other days will be remote.

Requirements

3–5 years in data analytics, business intelligence, or related roles.
At least 2 years of experience with PowerBI.
At least 4 years of SQL experience.
Degree in a quantitative field (i.e. mathematics, statistics, computer science, economics, engineering, physics, business) or equivalent experience.
Exceptional critical thinking, problem solving and decision-making skills with demonstrated ability to independently identify and analyze business problems and recommend solutions.
Knowledge in organization's Information Technology (IT) environment and understand the integration / interdependencies of various processes across a line of business.
You know that relationships and networks are essential to success.
You inspire outcomes by sharing your expertise.
You seek out innovative solutions and embrace evolving technologies.
You can easily adapt to new tools and trends.
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.
You bring your real self to work and you live our values - trust, teamwork, and accountability.

Nice To Haves

Python and Microsoft Copilot Studio experience
Worked within Capital Markets/Equities
Advanced degree (i.e. MMA, MBAN, MSc, MA, MBA)
Microsoft Certified: Power BI Data Analyst Associate certification

Responsibilities

Collect, clean, and analyze large datasets to uncover trends and opportunities.
Use SQL and Pyspark to process and prepare data for PowerBI dashboard.
Build interactive dashboards and reports using Power BI, Tableau, or Python visualization libraries.
Drive, manage and execute data and reporting projects and initiatives in alignment with CIBC Strategy while supporting the business goals, objectives, and key performance indicators.
Ability to think strategically about how to mobilize and engage teams across the enterprise to deliver strategic change.
Actively lead the development, delivery, and continuous improvement of complex data analytics and visualization solutions.
Excellent verbal and writing skills to effectively articulate ideas and opinions that involve analysis, processes, and technology solutions to others with different disciplinary backgrounds.
Ability to produce a variety of business documents that demonstrate command of language, clarity of thought and orderliness of presentation.

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