Data Analyst – Power BI & SQL

Astra-North Infoteck Inc.

Toronto

On-site

CAD 68,880 - 96,432

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

A technology consulting firm located in Toronto is seeking a Data Analyst to translate data into actionable insights. The role requires strong SQL skills and experience with Business Intelligence tools, particularly Power BI. Ideal candidates will have over 5 years of experience, excellent communication abilities for engaging with business leaders, and a solid understanding of relational databases. This full-time position offers a competitive salary range between CAD 50.00 and CAD 70.00 per hour.

Qualifications

  • 5+ years of experience writing and optimizing SQL queries.
  • Strong understanding of relational databases and data warehouses.
  • Excellent communication skills for engaging stakeholders and presenting to executives.

Responsibilities

  • Design and maintain dashboards and reports using BI tools.
  • Write and optimize complex SQL queries for data extraction.
  • Collaborate with stakeholders to deliver data-driven solutions.
  • Present findings to non-technical audiences, including executives.
  • Ensure data accuracy and compliance with standards.

Skills

SQL
Business Intelligence
Communication skills

Tools

Power BI

Job description

Location: Toronto

Role: Data Analyst with strong technical and communication skills.

This role involves working closely with business leads and executives to translate data into actionable insights. The ideal candidate will have a solid foundation in SQL, relational databases, and experience with Business Intelligence tools, preferably Power BI.

Key Responsibilities
  • Design, develop, and maintain dashboards and reports using BI tools (Power BI preferred).
  • Write and optimize complex SQL queries for data extraction and analysis.
  • Collaborate with business stakeholders to understand requirements and deliver data-driven solutions.
  • Present findings and insights clearly to non-technical audiences, including executives.
  • Ensure data accuracy, integrity, and compliance with organizational standards.
Ideal Candidate Traits
  • Strong SQL capabilities with at least 5 years of experience (query writing, optimization, troubleshooting).
  • Strong understanding of relational databases and data warehouses.
  • Excellent communication skills for stakeholder engagement and executive presentations.
  • Experience as a BI Developer, ideally with Power BI.
Nice-to-Have
  • Background in insurance or related industry.
  • Exposure to CloudSQL or BigQuery environments.
Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Information Technology

Industries

IT Services and IT Consulting

Toronto, Ontario, Canada CA$50.00-CA$70.00 15 hours ago

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data & Reporting Analyst - SQL (Power BI and Tableau)
Data & Reporting Analyst - SQL (Power BI and Tableau)

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 70,000 - 90,000
Power BI Developer
Power BI Developer

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 70,000 - 90,000
Data Analyst: Power BI & SQL Dashboards (Toronto)
Data Analyst: Power BI & SQL Dashboards (Toronto)

Astra-North Infoteck Inc. • Toronto

On-site
CAD 68,880 - 96,432
Data Analyst
Data Analyst

Acquird.io • Toronto

Hybrid
CAD 70,000 - 80,000
Health and Dental benefits + Annual 0%
Power BI developer
Power BI developer

Tata Consultancy Services Limited • Toronto

On-site
CAD 80,000 - 100,000
Data Analyst / Business Intelligence Analyst
Data Analyst / Business Intelligence Analyst

NorthBridge Analytics • Ottawa

Hybrid
CAD 75,000 - 90,000
Company pension
Dental care
Flexible schedule
+3
Software Developer - ETL / Power BI - Intermediate
Software Developer - ETL / Power BI - Intermediate

isgSearch • Toronto

On-site
CAD 90,000 - 130,000
Power BI Developer
Power BI Developer

Agilus Consulting Group • Toronto

Hybrid
CAD 103,000 - 117,000
Intermediate Software Developer
Intermediate Software Developer

Hirematic Talent Solutions • Toronto

On-site
CAD 55,000 - 62,000
BI Developer
BI Developer

Cpus Engineering Staffing Solutions Inc. • Oshawa

Hybrid
CAD 123,984 - 130,872