Data Analyst

TekStaff IT Solutions; Toronto; On-site; CAD 65,000 - 90,000; Full time

Job summary

TekStaff's Client has a current vacancy for a Data Analyst - 2. The candidate will ingest and transform data from multiple sources using SQL and Python, and build dashboards in Power BI to monitor CIAM fraud metrics across geographies.

The role requires 2–4 years of hands-on experience, proficiency in SQL, Power BI, and familiarity with Agile processes (Jira, Confluence). Exposure to Python and BigQuery is desirable.

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 working 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

Agile teamwork

Tools

Jira

Confluence

BigQuery

Job description

TekStaff's Client has a current vacancy for a Data Analyst - 2

Job Description

Role Responsibilities / Typical Day in Role:

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

Candidate Requirements/Must Have Skills:

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

Nice-To-Have Skills:

• Experience in Fraud Analytics, CIAM, or Cybersecurity analytics.

TekStaff may use artificial intelligence (AI) tools as part of the applicant screening process. However, applications will also be reviewed by a member of our Recruitment team to ensure a fair and thorough assessment.