Sr Data Analyst #88432

CG Consulting Group; Toronto; Hybrid; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a Senior Data Analyst to enhance risk domain business intelligence. This role involves taking ownership of credit risk reporting, ensuring data quality, and collaborating with various teams. You'll thrive in a hybrid work environment that values innovation and flexibility, with ample opportunities for personal and professional growth. If you're passionate about data analysis and want to make a significant impact in a supportive culture, this position is perfect for you.

Benefits

Health Benefits

Employee Share Purchase Plan

Flexible Work Hours

Ongoing Learning Opportunities

Best-in-Class Onboarding Experience

Qualifications

• 5+ years of experience as a Data Analyst with strong SQL skills.
• Experience in project delivery related to data warehousing and reporting.
• Ability to gather requirements and perform business analysis.

Responsibilities

• Own monthly and quarterly credit risk reporting for various teams.
• Ensure high data quality in reporting and collaborate with stakeholders.
• Lead testing activities and manage project timelines.

Skills

SQL

Data Analysis

Business Analysis

Project Delivery

Communication Skills

Education

Degree in Business

Degree in Finance

Degree in Software Development

Degree in Risk

Tools

Cognos

Tableau

Power BI

Job description

Sr Data Analyst #88432

Request ID: 88432-1
Start/End Dates: 6/2/2025 - 10/31/2025
Work Location: 81 Bay 31st Floor
Job Title: IT - Data Analyst - Senior

Position Title: Data Analyst - Senior
Line of Business: Risk Business Intelligence Office (RBIO) - Perform credit risk reporting (OFSI reports, public disclosure reporting, senior management reporting).

Target Start Date: ASAP
Contract Duration: until Oct 31st 2025 - Fiscal Year End
Extension/FTE: Potential for extension

Hybrid Work: Mon and Tues in Office plus first Friday of every month
Location Address: 81 Bay 31st Floor, downtown Toronto
Schedule Hours: 37.5 hrs// Mon-Fri 905
OT: no

Interview:
1st - 2 parts (candidate should allot at least 2 hrs)
a. Tech interview- 45 min- online SQL test - candidate required to bring their own laptop
b. Behavioural interview afterwards - 1 hr 2nd - with HM and Director - in person/MS Teams

Reason: Project work
Project: Slated to end in Oct. Real Estate Data Capture Project (REDC) - Data mapping, Business Analysis, UTA testing along with project activities.
Who will the candidate be working with on a Daily basis: Working with the HM, stakeholders

Selling point of the position: Benefit from an open and approachable culture that provides the flexibility and support you need to integrate your life at work and at home · Connect: Work in a place where the right technology and infrastructure fosters innovation, collaboration and creativity · Develop: Grow your skills and career through our best-in-class onboarding experience, ongoing learning opportunities, individual development planning, and comprehensive product training · Prosper: Share in our collective success with a competitive salary, incentive pay, banking benefits, health benefits program, and employee share purchase plan

Job Description:
What You’ll Be Doing
You will apply your strong reporting and data analysis skillsets, combined with an understanding of Risk Management to further RBIO’s purpose of “Acting as a trusted advisor” by enhancing risk domain business intelligence in CIBC. Your accountabilities include taking ownership of the assigned monthly and quarterly wholesale credit risk reporting to various CIBC partner teams as well as to the regulators. You will also be accountable for developing detailed requirements ensuring high data quality in the development and maintenance of robust reporting and analytic solutions in collaboration with various teams across Product, Finance, Risk, and Technology.

How You’ll Succeed
· Leadership skills – By bringing a can-do and energetic self to work, you will build strong trustful relationships with your team members inside RBIO and with partner teams. You show accountability of running a project or process to completion by taking on the role of an owner, solving for roadblocks and proactively identifying possible issues for the overall success of the group. You take opportunities to provide advice to your team, including ongoing feedback, support, and mentorship.
· Data Quality – You understand the importance of data quality in reporting and are mindful of the impacts of low data quality to reporting. You are systematic in adhering to the processes related to monitoring data quality, raising data quality issues, and taking ownership to solve them in both production reporting and project delivery setting.
· Business and Data Analysis – You understand that both technical and business acumen are required. You are well versed in SQL and be a reliable liaison between business and technology groups. You understand the processes related to project delivery such as requirements analysis and user acceptance testing. Working closely with partners such as risk data consumers and risk data providers, you will provide analysis and support to the group with concepts around ingesting, measuring, monitoring, and reporting wholesale risk data to regulators and senior management.
· Projects & Testing – Identify obstacles or risks that may impact a project’s timeline or success and provide regular status updates to the business. Keep the lines of communication open with stakeholders, and escalate issues when necessary. Ensure that all test deliverables are received, approved, and aligned to your project’s timeline, budget and goals. Lead the investigation and translation of business requirements into test cases. Design and manage end-to-end testing activities for various projects across the business.

Who You Are
· You give meaning to data. You enjoy investigating complex problems, and making sense of information. You have experience in Data Analysis tools, including SQL, BI tools such as Cognos, Tableau, and Power BI. You're confident in your ability to communicate detailed information in an impactful way.
· You love to learn. You're passionate about growing your knowledge, and you know that there is no limit to what you can achieve. You have a demonstrated history of continuous learning.
· Values matter to you. You bring your real self to work and you live our values – trust, teamwork, and accountability.
· You act like an owner. You thrive when you're empowered to take the lead, go above and beyond, and deliver results.

Must haves:
1. 5+ years of previous experience as a Data Analyst
2. 5+ years in project delivery related to data warehousing and reporting
3. Experience writing requirement documents and data mapping
4. Experience writing SQL queries and performing analysis
5. Project skills - gathering requirements, business analysis, UAT testing.
6. Knowledge of reporting tools (BI tools such as Cognos, Tableau, and Power BI)

Nice to have:
1. Previous experience working on Commercial banking data projects - (Wholesale banking/Capital Markets)
2. Tech background

Soft Skills
· Able to hit the ground running
· Experience managing stakeholders
· Strong communication skills

Education and Certifications: Preferred - Degree in business, finance, software development, or risk

Supplier Call Notes:
- Large project with stakeholder engagement
- Previous experience with commercial banking data projects - very nice to have
- Familiar with tools/concepts of reporting - coding is not required
- Will look at BSA with Data Mapping, and Data warehousing, SQL, banking

close on Monday May 12 @ 1:50pm