Data Analyst

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

Job summary

A leading real estate firm in Toronto is seeking a Data Analyst to maintain and improve reports, deliver insights, and support operations of their cloud-based data platform. The ideal candidate will have a background in data analytics and experience with SQL and BI tools. Competitive compensation and benefits include flexible hours and fully paid healthcare from day one.

Benefits

Flexible Hours

Company-matched savings plans

Fully paid Extended Healthcare benefits

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.
• Detail-oriented with strong documentation skills.
• Willingness to learn new skills in a dynamic environment.

Responsibilities

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

Skills

SQL

Business Intelligence (BI)

Data Analysis

Teamwork

Education

Post-secondary education in Data Analytics, Computer Science, Information Systems, Business, or a related field

Tools

Power BI

Snowflake

Sigma

Job description

First Capital [TSX: FCR.UN] owns, operates, and develops grocery anchored open air centres in neighbourhoods with the strongest demographics in Canada. Through the expertise and collaboration of our team, we create thriving properties which generate value for businesses, investors and our neighbourhoods. As one of the Greater Toronto Area’s top employers, we foster a vibrant culture that ensures equal opportunity and well‑being for all employees in a dynamic workplace. We are proud to provide rewarding opportunities to build meaningful careers in a fun and high performing environment.

THE ROLE:

As a Data Analyst, you will be reporting to the Director, Data & Automation and play a key role in maintaining and improving reports, delivering insights and supporting the day‑to‑day operation of our cloud‑based data platform.

As the ideal candidate for this role, you are curious, analytical and passionate about data and bring a track record of strong teamwork and partnership.

WHAT YOU WILL DO:

• Maintain and enhance dashboards and reports using Power BI and Sigma.
• Write and optimize SQL queries in Snowflake to support reporting and analysis.
• Respond to data and reporting requests from business users.
• Help document report logic, data definitions, and dashboard users.
• Validate data accuracy and investigate data issues or anomalies.
• Assist with data profiling, reconciliation and functional testing.
• Support business users during testing and rollout of updates to data products.
• Learn and apply best practices in data modelling, translation, and visualization.

WHAT YOU WILL BRING:

• Post‑secondary education in Data Analytics, Computer Science, Information Systems, Business, or a related field.
• 1–3 years of experience in a data‑related role such as Data Analyst, BI Analyst, Reporting Analyst, or Data Engineer.

WHAT YOU NEED TO BE SUCCESSFUL:

• Foundational SQL and BI skills.
• Detail‑oriented with strong documentation skills.
• Willingness to learn new skills (Snowflake and Sigma) in a dynamic environment and translate these skills into knowledge for the business or IT team and communicate new learnings to a broader audience.
• Love problem solving and working as a team.

WHAT WE OFFER:

Along with our competitive compensation packages—we’re always thinking of new ways for our people to share in the company’s success. We are very proud to offer the following to our employees:

• 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

Our people are what makes us different. At First Capital we are committed to workplace diversity and inclusion within our organization, therefore, we encourage all qualified persons from all backgrounds to apply. Accommodations are available, upon request, to all applicants with disabilities throughout our hiring process. To discuss any accommodation, please email us at [e-mail].