Data & Reporting Analyst: SQL/Power BI for Fraud Analytics

Finance Professionals Inc.; Toronto; Hybrid; CAD 55,000 - 70,000; Full time

Job summary

FP Inc. is seeking a Data/Reporting Analyst to support root-cause analysis and post-incident reporting with clear data narratives in a Hybrid setting across Downtown Toronto.

In this role you will ingest and transform data from BigQuery, SQL Server, and CSVs using SQL and Python, build Power BI dashboards for CIAM fraud metrics, and deliver weekly insights decks with trend analyses and operational recommendations.

Qualifications

• 2–4 years of hands-on experience as a Data Analyst or Reporting Analyst.
• Proficiency in SQL for querying large datasets.
• Practical experience with Power BI and building dashboards.
• Experience in Agile teams and tools (Jira, Confluence).
• Exposure to Python, BigQuery or similar cloud data warehousing.

Responsibilities

• Ingest and transform data from multiple sources (e.g., BigQuery, SQL Server, CSV) using SQL and Python.
• Build and maintain Power BI reports and dashboards for CIAM fraud metrics, trends, and patterns across channels and geographies.
• Track and report CIAM KPIs and produce weekly/monthly insights decks with trend analysis and operational recommendations.
• Support root-cause analysis and post-incident reporting with clear, concise data narratives.
• Execute ad hoc queries to answer business questions around control performance, user journeys, and fraud patterns.

Skills

SQL

Power BI

Python

Jira

Confluence

BigQuery

Education

Bachelor's degree in STEM

Tools

CSV

Job description

FP Inc. is seeking a Data/Reporting Analyst to support root-cause analysis and post-incident reporting with clear data narratives in a Hybrid setting across Downtown Toronto.

In this role you will ingest and transform data from BigQuery, SQL Server, and CSVs using SQL and Python, build Power BI dashboards for CIAM fraud metrics, and deliver weekly insights decks with trend analyses and operational recommendations.