Title:  Technical Business Analyst with Revenue Reporting and P&L

Requisition ID: 200443

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

Team

GCMT Regulatory & Compliance Technology Team is transforming the digital experience for its users. The team partners and works closely with the Scotia Digital team to bring world-class digital experiences for all Internal Control users.  The team plays a key role supporting users for regulatory reporting.

Role

GCMT Regulatory & Compliance Technology Team is looking for an energetic and results-oriented Technical Business Analyst to join our team to help implement portal to manage supervisory hierarchy for our Internal control users. We’re looking to fill our team with influencers, makers, creators, and leaders who are flexible, curious, adventurous, versatile, and responsive; and who are ready to roll up their sleeves in a collaborative and productive environment to get things done.

Job responsibilities

Do you have proven leadership skills? Are you ready to apply your hands-on technical experience, and a can-do approach towards a fast-paced, high-profile business, Regulatory, and technology perimeter within the bank?  In this role, you will:

• 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.
• High attention to detail and sense of urgency, with the ability of working well under pressure.

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).
• 2+ years’ experience in capital markets (product knowledge, working with big data, middle to back-office experience)

Nice to have skills

• Power BI is a strong asset.
• Ideally 4+ years of experience in financial or MIS reporting

What's in it for you?

• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
• Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.  
• Upskilling through online courses, cross-functional development opportunities, and tuition assistance. 
• Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
• Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

Location(s):  Canada : Ontario : Toronto 

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.  

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.