Senior Business Intelligence Analyst to lead payment modernization analytics and reporting using Microsoft Power BI, Microsoft Power Platform, and Azure Databricks - 41699 Location: Hybrid - Downtown Toronto – onsite 4x/week
The selected candidate will be a member of Global Transaction Banking team reporting to Director, Business Intelligence and Insights, GTB Analytics.
Incumbent contributes to the overall success of Global Transaction Banking (GTB) by performing and overseeing its data, business intelligence and analytics strategy for GTB footprint across North America. This includes ownership and oversight for payments insights, scorecards, reporting and data models. The role is highly technical and requires expert knowledge of Microsoft Power BI, Microsoft Power Platform and Azure Databricks along with data practices and analytical methodologies.
Incumbent possesses strong technical, financial and analytical skills as well as the ability to communicate to a broad audience including executives. The incumbent also possesses leadership skills as well strong knowledge of GTB products, services and operations.
Must Haves 10+ years of experience in business intelligence, analytics, or insights roles, or related fields (some experience within Canadian Banking)
Solid knowledge of Microsoft Power BI and Microsoft Power Platform
Solid understanding of ETL processes, data mining, profiling, cleansing and enrichment
Solid analytical skills to identify and evaluate unusual numbers and trends
Strong proficiency with Excel and other MS products
Nice-To-Have Skills Master’s degree or MBA
Experience with Azure Databricks, GCP
Previous experience working on large-scale transformational projects
Soft Skills Required Results focused – delivers high impact insights that directly support GTB’s revenue, client, and operational outcomes.
Problem Solver – Identifies complex challenges and develops effective, logical solutions to support business needs




Critical thinker – Analyzes the data considering different aspects of business and draw logical conclusions
Open-mindedness – Actively seeking out and considering alternative views and diverse perspectives
Exceptional communication and stakeholder management – both technical and non-technical
Interpersonal, time management and organizational skills are required for this role in conjunction with good relationship management skills
Education: Bachelor’s degree in business, analytics computer science, finance, or related field
Responsibilities Reporting & Insights Lead data and analytical workstreams and on-going initiatives in collaboration with GTB Payments Transformation, technology and product teams
Own end to end future-state report development which serve as the primary portal and one-stop shop for all GTB payments operations to access self-serve dashboards, insights, scorecards and more
Partner with business teams across North America footprint to gather requirements, understand current ecosystems, ideate and visualize the target state views for the business
Help build end to end data pipelines and lineage to enable sustainable reporting from modernized data ecosystem
Work closely with Enterprise Data Lake technology partners to build a robust data infrastructure for catering reporting use cases
Create an impact by providing solid analytics and insights to Payment Modernization, Product, Correspondent Banking and Operations teams in order to drive efficiency, execute against migration mandates, improve the customer experience and protect the Bank
Identify, prioritize, analyze, remediate, and upscale data and reporting issues.
Create process flows,



user guides, migration documents and testing results related documents.
Ensure accuracy, governance, and access control on BI ecosystem
Where material gaps in capabilities versus requirements exist, the incumbent will either directly or indirectly drive efforts to resolve same.
Highly developed analytical and problem-solving skills are necessary as well as a good knowledge of the Bank’s operational and compliance policies, practices, and procedures.
Innovation & Center of Excellence Champions the launch of new technology solutions to the team – focusing on BI and analytics engineering domains
Act as a centre of excellence for GTB business, Product as well as Payment analytics, acting their own trusted advisors for everything related to data analytics
Ideate and innovate the best-in-class automation and reporting tools to support sales, payments and product teams in portfolio management
Training and Communication Lead training sessions with business stakeholders on new feature launches and updates
Provide training sessions to analytics team on new technical enhancements on BI platform and data platform
Relationship Management Work in alignment with the GBM Client Insights and Analytics, GBM Analytics Execution, Small Business Analytics as well as Commercial Banking Analytics and Business Planning teams.
Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.
Candidate Review & Selection 2 rounds
1st round – HM – 30 mins – MS Teams Video (cultural/personality fit, meet and greet, overview of experience)
2nd round – panel (Data analytics engineers, product lab) – 45 mins – in-person (behavioural/situational)
3rd round – VP – 30 mins – MS teams Video (to make final decision)
Duration: 1 year to start
Disclaimer: AI may be used in evaluating candidates. This posting is for an existing vacancy.

#J-18808-Ljbffr

📌 Senior Business Intelligence Analyst to lead payment modernization analytics and reporting using Mic (Ontario)
🏢 S.I. Systems
📍 Ontario