Data Analyst – BI​/Analytics, PowerBI, ETL

Job Description

Location:

Hybrid | Downtown, Toronto

Duration: 12 Months

Our client, a leading financial institution in Downtown Toronto, is looking for a Data Analyst - BI/Analytics, PowerBI, ETL to lead data and analytical work streams and on‑going initiatives in collaboration with GTB Payments Transformation, technology and product teams. The successful candidate will have the opportunity to work with one of the Top 5 Banks in Canada.

Compensation: $60/hr - $70/hr.

• 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 elevate 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.

• 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.

• 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.

• 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.

• 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.
• Strong analytical skills to identify and evaluate unusual numbers and trends.
• Strong proficiency with Excel and other MS products.

• Master’s degree or MBA.
• Experience with Azure Databricks, GCP.
• Previous experience working on large‑scale transformational projects.

• 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 draws 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.

• Bachelor’s degree in business, analytics computer science, finance, or related field.

FP Inc. is committed to creating an inclusive environment where all team members and clients feel like they belong. In accordance with the requirements set out in the Employment Standards Act, FP Inc. hereby declares that AI is utilized in the screening process for this position. We advocate for you and welcome anyone regardless of race, colour, religion, national origin, sex, physical or mental disability, or age.