Story Behind the Need:

• Business group: GWRT – Regulatory & Compliance Technology – Supporting Client Revenue & P&L Reporting
• Project: Client Analytics Reporting
• Reason for request: Backfill

Candidate Value Proposition:

• The successful candidate will have the opportunity to gain exposure to various systems and work with big data.
• Working on high visibility products and building experience with data analytics software.
• Opportunity to work with various stakeholders (senior level, and subject matter experts) across departments.

Typical Day in Role:

• The incumbent acts as technical business/data analyst resource in projects, providing detailed technical data analysis, testing, investigations, recommendations, program specifications and business requirements for development of technical solutions for the sourcing, delivery, and processing of required monthly/daily data sources within the distributed technical architecture to support client profitability and analytics for wholesale customers.
• Supported by knowledge of wholesale business products and detailed understanding of Bank source applications, the incumbent uses technical knowledge and business/data insights to design and build specifications for operationally stable processes that extract, transform, and map raw data to organized/structured schemas for the purpose of consistent reporting and analytics.
• The incumbent supports technical peers in the team and collaborate with business partners, data engineers and cross functional IT teams to deliver complex, creative, cost-effective and robust operationally stable data solutions. This includes development of complex queries against big data that are required to ensure data are accessible for analytics and reporting by the data teams, as well as providing oversight of reporting solutions using Tableau, and/or other industry standard BI tools.
• The incumbent provides acceptance testing and verification to help verify complex technical/business solutions for the assigned tasks. They will share the results with users for confirmation and sign-off to proceed with implementation to release the solution in production environment. The incumbent may be required to perform operational support after hours from time-to-time in order to support late hours implementation and operational processes.
• The incumbent drives the implementation of new processes, improving methodologies and utilizes cutting-edge technologies to expedite delivery of new and enhanced products to our customers on a daily basis. They drive adoption of modern testing approaches and techniques to both ensure excellent quality standards while delivering with velocity.
• The incumbent is expected to function independently combining technical expertise and business knowledge to recommend, develop and implement technical solutions and also identify opportunities for automation or efficiency in ETL processes. The incumbent may receive general direction from Director/Senior Manager/Project Managers/Business Analysts for the projects assigned.
• Collaborate with data architects, modelers and IT team members on project goals.

Must Have Skills:

• 5-7 years of experience working in a similar capacity as a BA/BSA
• Recent project experience writing intermediate to advanced queries using SQL
• 3+ years’ finance/accounting background (experience with revenue reporting and P&L)

Nice-To-Have Skills:

• Power BI is a strong asset

Soft Skills:

• Ability to work as part of a team, as well as work independently or with minimal direction.
• Excellent written, presentation, and verbal communication skills.

Best vs Average:

• Strongest resources will have strong backgrounds in using databases and Power BI. The team needs a resource who is highly engaged and motivated to delivery on project requirements.

Degrees or certifications:

• Bachelor’s degree in a technical field such as computer science, computer engineering or related field required.
• Financial courses or certification completion is an asset
• Prior courses taken in mathematics (statistical analysis and discreet mathematics)

Candidate Review & Selection:

• Structure and Format:
o 1st round: Codility assessment
o 2nd round: MS Teams Video interview, panel discussion (technical and behavioral), 45-60mins
o Potential final round as needed