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
RQ07546 - Business Analyst - Intermediate
Leadsand conducts business analysis in order to assess client s businessproblems/opportunities and documents the business requirements insuch a way that I&IT solutions can be determined. Providesa comprehensive range of I&IT business analysis servicesfor clients with diverse business and tec...
Junior Capital Markets Analyst with Python/VBA coding to support the trade lifecycle for a large banking client - 52105
Junior Capital Markets Analyst with Python/VBA coding to support the trade lifecycle for a large banking client . Ability to articulate any challenges to business partners and front office. ...
Data Analyst, Model Risk Reporting (Python/SQL/VBA/Tableau)
On behalf of our client in the Banking Sector, PROCOM is looking for a Data Analyst, Model Risk Reporting (Python/SQL/VBA). Data Analyst, Model Risk Reporting (Python/SQL/VBA). Data Analyst, Model Risk Reporting (Python/SQL/VBA) - Job Description. Data Analyst, Model Risk Reporting (Python/SQL/VBA) ...
Business Systems Analyst, Digital Banking
Bridge the gap between business and IT, ensuring common understanding and IT/Business alignment of both functional (for business needs) and non-functional requirements (such as reporting, performance, interfaces, and constraints. Guided by our purpose: "for every future", we help our customers, thei...
Senior Business Systems Analyst (Oracle SQL Specialist)
Role: Senior Business Systems Analyst (Oracle SQL Specialist). Experience in Oracle SQL is mandatory. Lead analysis phases to identify, track, escalate and/or resolve business systems issues in an Agile environment. Strong collaboration with business and operations stakeholders, plus system SMEs. ...
Intermediate Records Management Business analyst to review records management and classification 75885-1
Intermediate Records Management Business analyst. The main function of a Business Analyst is to perform the analysis, design, implementation, modification, and daily functional support of all applications. Line of Business: Enterprise Risk Management – Risk Data Management Office. ...
Intermediate Business Analyst
The Business Analyst I is responsible for managing data files, conducting reconciliations, and other business analysis activities in consultation with business-facing partners and stakeholders to enable informed, evidence-based, operational and strategic decisions . On behalf of our client in the Re...
2 Intermediate BI Business Analysts required to support various internal Data Warehouse and BI initiatives. (2024-026 & 027)
Our Municipal Government client is searching for 2 Business Analysts – Business Intelligence to participate in various IT data projects, the Enterprise Data Warehouse and Business Intelligence program and its initiatives. Our GTA based, Municipal Government Client requires 2 Intermediate Business An...
Business Analytics Manager (Banking exp, PowerBI, SAS, SQL, Data analytics)
Collaboration with internal teams to develop advanced analysis to drive deeper insight and identify revenue opportunities based on information gathering of current trends, competition, and strategy -Provide financial and operational support to monitor the business -Understands and articulates the bu...
Business Analyst (python & SQL)
Role: Business Analyst (Python & SQL ). Act as a senior Business Analyst with previous experience working in Financial Services, governance and metadata management tools. The Business Analyst will work in a team setting to gather requirements on various metadata management tools and to support gover...