Data Analyst

Description

First Capital [TSX : ] 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 brings 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 request 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 :

WHAT YOU NEED TO BE SUCCESSFUL :

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 :