Search jobs > Toronto, ON > Intermediate analyst

Intermediate Business Analyst – Banking/VBA/SQL

CB Canada
Toronto, Ontario, Canada
$60 an hour (estimated)
Full-time

Job Posting Title : Intermediate Business Analyst Banking / VBA / SQL

Business group : The Liquidity Regulatory Reporting team is responsible for reporting and managing liquidity and funding risk for the Bank.

Project : The incumbent will work with project manager, developer and IT partners to implement daily new undrawn commitment reports.

Candidate Requirements / Must Have Skills :

1) 3+ years as a Business Analyst

2) Basic knowledge in VBA and SQL, and Microsoft advanced functions.

3) Experience with conducting UAT on data intensive reporting implementations involving technology changes.

Nice-To-Have Skills :

1) Good knowledge of banking products, as well as liquidity risk reporting preferred.

2) Exposure to liquidity cashflow generator would be an asset.

3) Advance expertise in MS Office suite of products

Soft Skills Required :

  • Creative, results oriented, highly motivated individual with excellent analytical and problem-solving skills, with the ability to apply knowledge to independently and effectively resolve complex business problems.
  • Strong communication (written & verbal) and interpersonal skills to facilitate working with colleagues at all levels of the organization.
  • Ability to work in a dynamic environment, manage multiple deadlines and priorities.
  • Adaptable working as part of a team or independently with minimum supervision.

Education :

  • Undergraduate degree in business, finance or computer science is required
  • MBA, CFA or accounting designation is an asset

Typical Day in Role :

1. Data Analysis and testing

  • Review various data mappings along the liquidity risk data flow and understand the data structures along with the mappings.
  • Write SQL queries for data mining.
  • Write UAT test cases.
  • Conduct UAT of data provisioned to support undrawn commitment report changes.
  • Conduct UAT of undrawn commitment records generated from liquidity risk cashflow engine.
  • Conduct UAT of undrawn commitment report generated from reporting layer.

2. Documentation

  • Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in undrawn commitment reporting
  • Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module.
  • Create, update, and maintain product mapping logic from source system to liquidity risk data provisioning and enrichment layer

3. Relationship Management

  • Collaborate and build rapport with Project Manager, other Business Analysts, reporting analysts and IT partners.
  • Work with IT partners to help translate users’ requests into technical specifications, when necessary
  • 30+ days ago
Related jobs
Promoted
Genpact
Toronto, Ontario

Works independently as the senior or lead business analyst and coaches and guides members within area of expertise. Data centric project (retail banking/fraud/AML) / work packages for Tier 2-4, low to moderate risk and regulatory projects with multiple stakeholders and across multiple LoB. Advanced ...

Astra North Infoteck Inc.
Toronto, Ontario

Business system analyst, Wealth and Journeys experience, Agile background, banking experience, JIRA, Confluence, MS Visio and other BSA tools. Business System analysis, SQL skills. Business Analysis, Usability Analysis and Evaluation Techniques. ...

Astra North Infoteck Inc.
Toronto, Ontario

Business system analyst, Wealth and Journeys experience, Agile background, banking experience, JIRA, Confluence, MS Visio and other BSA tools. Business System analysis, SQL skills. Business Analysis, Usability Analysis and Evaluation Techniques. ...

S.i. Systems
Toronto, Ontario

Business Analyst and Data Analyst. Eliciting business requirements from stakeholders and turning these into data/technical requirements for further implementation by technology groups. Articulate findings to relevant business and technology groups and recommend next steps in the implementation cycle...

TELUS
Toronto, Ontario

We are looking for a driven, high-energy, technical and results-oriented individual to join the team for the role of Business Analyst II, within the Campaign Data Strategy function. The TELUS Business Solutions (TBS) organization is dynamic, fast-paced, and entrepreneurial. Our team of technical pro...

CB Canada
Toronto, Ontario

Line of Business: Marketing Solution & Client Offers. Daily Job Duties/Activities: The Senior Consultant is primarily responsible for ongoing and ad-hoc analytical support of credit card acquisition and retention campaigns and programs, including the delivery of detailed campaign post-analyses at th...

S.i. Systems
Toronto, Ontario

Duration: 1yr contract (possible extension).Extension possible: yes definitely .Interview Process: Potentially 1 - panel.Work Location: Hybrid Model- minimum 2 days a week.Cash flow projects- experience with the FR- A report .Good exp with confluence/ Jira.Liquidity risk/ Cash Flow projects – 5 year...

CB Canada
Toronto, Ontario

On behalf of our client in the Banking Sector, PROCOM is looking for a Lead Business Analyst - Banking - Basel. Lead Business Analyst - Banking - Basel. Lead Business Analyst - Banking - Basel – Job Description. Lead Business Analyst - Banking - Basel – Mandatory Skills. ...

S.i. Systems
Toronto, Ontario

You will support business banking portfolio data clean up to mitigate the impact of data migration from local accounts in International Banking to Credit. Project: As an Analyst, you will provide support to the Strategic Initiatives team by ensuring data integrity and data quality in collaboration w...

Astra North Infoteck Inc.
Toronto, Ontario

Gathering requirements and create Business Requirement Document (BRD) Functional Requirement Document (FRD), technical specifications, facilitating joint Application sessions, support documentation demo. Create system analysis document after discussion with business and architect teams. Define appli...