Data Analyst – BI/ Analytics, Power BI, Power Platform

FP Inc.; Toronto; Hybrid; CAD 83,000 - 105,000; Full time

Benefits offered by this job

Hybrid work

Downtown Toronto location

Job summary

FP Inc. is seeking a Data Analyst - BI/ Analytics to lead reporting and insights for GTB payments operations in a hybrid role based in Downtown Toronto.

The role focuses on building self-serve dashboards, data pipelines, and robust analytics across North America, enabling migration and efficiency gains. The successful candidate will bring 10+ years in BI/analytics, deep Power BI knowledge, ETL expertise, and strong Excel skills, with a background in banking preferred.

Qualifications

• 10+ years of experience in business intelligence, analytics, or insights roles, with Canadian banking experience.
• Strong knowledge of Microsoft Power BI and Power Platform.
• Solid ETL, data profiling, cleansing, and enrichment expertise.
• Strong Excel and MS Office proficiency.

Responsibilities

• Lead data and analytical workstreams and collaborations with GTB Payments Transformation, technology and product teams.
• Own end-to-end future-state report development with self-serve dashboards and scorecards.
• Partner with business teams across North America to gather requirements and visualize target state views.
• Build end-to-end data pipelines and data lineage for sustainable reporting.

Skills

Power BI

Power Platform

ETL

Data analysis

Excel

Education

Bachelor's degree

Tools

Azure Databricks

GCP

Job description

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, Power BI, Power Platformto Create process flows, user guides, migration documents and testing results related documents. The successful candidate will have the opportunity to work with one of the Top 5 Banks in Canada.

Typical Day in the role:

Reporting and 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 escalat[e] 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 and Centre 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.

Must Have Skills:

• 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

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

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. The hourly compensation range for this role is $60/hr -$76/hr. We seek applicants with a wide range of abilities, and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, colour, religion, national origin, sex, physical or mental disability, or age.