Data Analyst — Power BI, SQL & Snowflake Insights

First Capital REIT; Toronto; On-site; CAD 60,000 - 80,000; Full time

Job summary

A leading real estate investment trust in Canada is seeking a Data Analyst to report to the Director, Data & Automation. This role involves maintaining and improving reports, delivering insights, and supporting day-to-day operations of cloud-based data platforms. The ideal candidate will possess foundational skills in SQL and BI, paired with a strong documentation focus and a keen problem-solving mindset. Competitive compensation and a variety of benefits are offered, promoting workplace diversity and inclusion.

Benefits

Flexible Hours

Company-matched savings plans

Fully paid Extended Healthcare benefits from day one

Annual Wellness Subsidy

Tuition & Development Program

Employee Referral Program

Rewards and Recognition Programs

Paid time off during December holiday season

Parental leave benefits

Qualifications

• 1–3 years of experience in a data-related role such as Data Analyst, BI Analyst, Reporting Analyst, or Data Engineer.
• Willingness to learn new skills in a dynamic environment.
• Curious, analytical, and passionate about data.

Responsibilities

• Maintain and enhance dashboards and reports using Power BI and Sigma.
• Write and optimize SQL queries in Snowflake.
• Validate data accuracy and investigate data issues.

Skills

Foundational SQL skills

BI skills

Problem solving

Strong documentation skills

Education

Post-secondary education in Data Analytics, Computer Science, Information Systems, Business

Tools

Power BI

Snowflake

Sigma

Job description

A leading real estate investment trust in Canada is seeking a Data Analyst to report to the Director, Data & Automation. This role involves maintaining and improving reports, delivering insights, and supporting day-to-day operations of cloud-based data platforms. The ideal candidate will possess foundational skills in SQL and BI, paired with a strong documentation focus and a keen problem-solving mindset. Competitive compensation and a variety of benefits are offered, promoting workplace diversity and inclusion.