Analyst, Treasury Data Quality & Reconciliations

CIBC; Toronto; Hybrid; CAD 70,000 - 100,000; Full time

Job summary

CIBC is seeking a data quality and reconciliation Analyst to support Treasury Data Management. The role focuses on ensuring data integrity for treasury reporting across daily to annual cycles, with hybrid work on-site 1–3 days per week and remote on other days.

The incumbent will engage in data quality control, issue resolution, and collaboration with business partners to improve processes. Candidates should have a university degree or equivalent in a related field, strong SQL/Power BI/Excel

Qualifications

• University degree or equivalent in Business, Information Technology, Computer Science, Engineering or Mathematics.
• Proficiency in SQL, Power BI, MS Access, Excel and PowerPoint.
• Analytical mindset with strong problem-solving, judgment and reporting capabilities.

Responsibilities

• Support the Director of Data Quality and Reconciliations in Treasury Data Management to ensure data integrity across reporting.
• Monitor and reconcile data quality for daily, weekly, monthly, quarterly, and annual treasury reporting.

Skills

Accountability

Analytical Thinking

Data Integrity

Data Management

Data Quality

Financial Analysis

Microsoft Office

Excel

PowerPoint

Education

University degree

Equivalence to university degree in Business/IT/CS/Engineering/Mathematics

Tools

SQL

Power BI

MS Access

Excel

PowerPoint

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

The Analyst will support the Director of Data Quality and Reconciliations team, Treasury Data Management to ensure the data integrity in Treasury owned applications. The role will ensure the data quality for Treasury reporting on a daily/ weekly/ monthly/ quarterly, or annual basis. The role will support Treasury QRM end-to-end production as it relates to reporting, reconciliation and manual adjustment. In addition, the incumbent will take part in various data quality control and data issue solution, manual adjustment automations and work on the projects or initiatives from data management internally or requested by business partners, e.g. Treasury LMG (Liquidity Management Group) and Liquidity Reporting teams, and ALM (Asset Liability Management), FTP (Funding Transfer Pricing), Capital Management teams etc. The incumbent will ensure all activities are properly documented and in accordance with the enterprise change management guidelines and SLAs. 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

• Accountability- Take accountability of month-end balance sheet and off balance sheet reconciliation processes for assigned products and ensure unreconciled variances are within expected thresholds.
• Analysis- Identify, analysis, investigates and resolves reconciliation variances, in order to ensure that daily/monthly/quarterly/annual regulatory reporting requirements are met on time.
• Support Liquidity reporting manual adjustment process as needed
• Data Management- Monitor and remediate data issues impacting reconciliations and reporting related to assigned products, as well as other critical data elements as defined by the business
• Provide Support- Contribute to the overall effectiveness of the Accounting and Reconciliation group by ensuring information supplied to users of the financial information is accurate, complete and provided on a timely basis. Assist with ad hoc data inquiries/requests from business partners.
• Reviews- Conduct periodic review of the data quality control processes to identify gaps or areas for improvement, and keep up to date on ever-changing business developments and the evolving regulatory environment.
• Support Data Management and Project Delivery initiatives (both Treasury and Strategic Business Unit Initiated) and participate in projects and assess impacts to reconciliation as required
• Controls and Process Enhancement- Maintain an appropriate internal control environment including adequate documentation. Ensure Finance-owned controls are performed on a regular basis to identify/manage exposure to risks, escalating issues as appropriate. Work with internal and/or external auditors when required. Identify and implement areas of improvement within the group, develop and implement sound business processes, practices and technical solutions to address business issues/challenges where applicable under the SOX guidelines

Who you are

You can demonstrate experience in Industry-related experience preferably in the areas of data warehousing, relational databases, and Liquidity reporting

You have a degree Equivalent to University degree in Business, Information Technology, Computer Science, Engineering or Mathematics

You are Proficiency in SQL, Power BI, MS Access, Work, Excel and PowerPoint

You are analytical. Strong problem solving, analytical, judgment and reporting capabilities.

Demonstrated strong attention to detail and accuracy.

Self-started, able to work independency and take ownership. Delivery focused.

Ability to manage deadlines while balancing multiple complex priorities

You work well with others. Ability to establish and build working relationships and partnerships with the business as well as peers and wide variety of stakeholders (Finance, Risk Management, Technology, etc.)

It would be an asset to have Knowledge of CIBC operating policies, standards and organizational structure. Experience with Quantitative Risk Management (QRM) system is beneficial. Knowledge on Accounting standard and rules would be a bonus

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. *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. 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, 26th Floor

Employment Type

Regular

Weekly Hours

37.5

Skills

• Accountability
• Accounting
• Analytical Thinking
• Business
• Business Analysis
• Business Analytics
• Business Processes
• Change Management
• Data Integrity
• Data Management
• Data Quality
• Financial Analysis
• Microsoft Access
• Microsoft Office

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.