At a Glance
- Tasks: Analyse data, enhance reports, and support our cloud-based data platform.
- Company: First Capital, a top employer in the Greater Toronto Area.
- Benefits: Flexible hours, health benefits, tuition support, and wellness subsidies.
- Why this job: Join a vibrant team and make an impact with your data skills.
- Qualifications: Post-secondary education in Data Analytics or related field; 1-3 years experience.
- Other info: Diverse workplace with great career growth and learning opportunities.
The predicted salary is between 28800 - 48000 ÂŁ per year.
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 careers@fcr.ca.
Data Analyst in Scarborough employer: First Capital Realty Inc.
Contact Detail:
First Capital Realty Inc. Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst in Scarborough
✨Tip Number 1
Network like a pro! Reach out to current employees at First Capital on LinkedIn. A friendly chat can give you insider info and might just get your foot in the door.
✨Tip Number 2
Prepare for the interview by brushing up on your SQL and BI skills. Be ready to showcase how you've used data to solve problems in past roles—real examples will make you stand out!
✨Tip Number 3
Show your passion for data! During interviews, share your excitement about learning new tools like Snowflake and Sigma. Employers love candidates who are eager to grow and adapt.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re serious about joining the First Capital team.
We think you need these skills to ace Data Analyst in Scarborough
Some tips for your application 🫡
Show Your Passion for Data: When you're writing your application, let your enthusiasm for data shine through! Share specific examples of how you've used data to solve problems or improve processes in your previous roles. We love candidates who are curious and analytical!
Tailor Your Application: Make sure to customise your CV and cover letter for the Data Analyst role. Highlight your experience with SQL, Power BI, and any other relevant tools. We want to see how your skills align with what we're looking for, so don’t hold back!
Be Detail-Oriented: Since attention to detail is key in this role, ensure your application is free from typos and errors. Use clear and concise language to describe your experiences. Remember, we appreciate strong documentation skills, so show us you’ve got them right from the start!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it gives you a chance to explore more about our company culture and values!
How to prepare for a job interview at First Capital Realty Inc.
✨Know Your Data Tools
Familiarise yourself with Power BI and Sigma before the interview. Be ready to discuss how you've used these tools in past projects or how you plan to apply them in this role. Showing that you can hit the ground running will impress the interviewers.
✨SQL Skills on Display
Brush up on your SQL skills, especially with Snowflake. Prepare to answer questions about writing and optimising queries. You might even be asked to solve a problem on the spot, so practice some common SQL scenarios to feel confident.
✨Show Your Curiosity
As a Data Analyst, curiosity is key! Be prepared to share examples of how your inquisitive nature has led you to uncover insights or solve problems in previous roles. This will demonstrate your passion for data and your analytical mindset.
✨Teamwork Makes the Dream Work
Highlight your experience working in teams. Discuss how you've collaborated with others to achieve goals or overcome challenges. First Capital values strong teamwork, so showing that you can work well with others will definitely work in your favour.