Data Analyst – Power BI & SQL

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; On-site; CAD 68,880 - 96,432; Full time

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