Data Reporting Analyst

Finance Professionals Inc.; Toronto; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

A leading company in finance is seeking a skilled professional for a key role in Corporate Treasury. The successful candidate will enhance liquidity reporting and internal controls, utilizing strong SQL and Excel skills. This hybrid position requires an undergraduate degree in a technical field and relevant experience in financial data mapping. Join a dynamic team and contribute to effective liquidity management.

Qualifications

• 4 years relevant work experience in financial data mapping.
• Practical knowledge of banking products and risk measurement.

Responsibilities

• Support Controller in liquidity reporting and internal controls.
• Configure and extract position data for regulatory compliance.
• Develop reports for regulatory bodies.

Skills

SQL

Excel

Tableau

Business Analysis

Education

Undergraduate degree in a technical field

Graduate degree in business or MBA

Tools

Tableau

Access Database

Job description

Contract Duration: 7 months

Location: Hybrid 3 days in office | Downtown, Toronto

Daily Responsibilities:

A key role within Corporate Treasury, where you will support the Controller of Client’s Liquidity Measurement in providing regulatory, management, and financial liquidity reporting by enhancing the effectiveness and efficiency of internal controls around processing and analyzing liquidity data to ensure the provision of timely, accurate, and reliable information.

Key Accountabilities:

· Provide assistance and guidance to technical staff for developing mapping logic for source data feeds

· Configure and extract position data using internal Enterprise Risk System for generating business-specific products to generate future cash flows, create new products/accounts, model customer behaviour, balance position data to the general ledger, and develop reports to comply with regulatory requirements

· Develop and generate reports in the appropriate format to be submitted to regulatory bodies

What program/technology/software knowledge is essential for this role? Describe in what capacity the selected candidate will be using it?

Strong SQL, Tableau, Excel skills

Must-have Skills/Experiences and/or Education, certifications, qualifications, designations:

• Strong proficiency in SQL
• Advanced Excel skills
• Undergraduate degree in a technical field such as engineering, mathematics, physics, or computer science, and a graduate degree in business, economics, or MBA
• 4 years relevant work experience
• Practical knowledge and experience in financial data mapping concepts and processes
• Practical and solid knowledge of business-specific banking products
• Experience and knowledge in the areas of data warehousing, relational databases and information flow
• Working knowledge of risk measurement (i.e. market risk or credit risk or liquidity risk) and valuation methodology of capital markets and banking products with any risk system
• Ability to identify, analyze and rectify project issues as they arise
• Well-developed PC Skills concerning spreadsheets, Access database, and presentation software
• Ability to deal with ambiguous inputs/user requirements and able to question, interpret, investigate, define the ambiguity, and obtain answers
• Ability to convey complex conceptual information involving extensive interpretation and opinion, which would involve technical and business components
• Proven business analysis and problem-solving skills

Nice-to-have Skills/Experience and/or Education, certifications, qualifications, designations:

• Familiarity with data visualization tools such as Tableau
• Experience in Financial Institutions
• General understanding of liquidity risk (Liquidity Adequacy Requirements)
• Ability to react to changing demands on an ad hoc basis