Data Analyst

Amilia; Brampton; On-site; CAD 65,000 - 85,000; Full time

Job summary

A leading SaaS company in Brampton is looking for a Data Analyst to support internal teams by transforming raw data into actionable insights. Responsibilities include building and maintaining Power BI dashboards, performing exploratory analysis, and collaborating on custom reporting solutions. Ideal candidates should have at least 2 years of experience in data analytics, proficiency in SQL, and familiarity with BI tools. This role offers a competitive salary, flexible work environment, and opportunities for skill development.

Benefits

Competitive salary

Group RRSP employer contribution up to 5%

Group insurance and EAP

Wellness allowance of $750 per year

Flexible hours and 4 weeks' vacation

Access to skill development workshops

Weekly Bootcamp and Pilates classes

25% discount on annual STM and EXO membership

In-office snacks and beverages

Qualifications

• 2 years of experience in data analytics or business intelligence in a SaaS environment.
• Strong grasp of SaaS metrics such as ARR, churn, LTV, and CAC.
• Experience with BI tools like Power BI, Looker, Tableau, or Data Studio.

Responsibilities

• Build and maintain Power BI dashboards for internal teams.
• Collaborate on SQL-based custom reporting for clients.
• Perform exploratory analysis to identify trends and opportunities.

Skills

Data analytics

Business intelligence

SQL proficiency

Analytical thinking

Bilingual in English and French

Tools

Power BI

MSSQL

PowerAutomate

Job description

Amilia is transforming the recreation and activities market with its innovative, purpose-built SaaS platform. Designed for municipalities, community centers, nonprofits, businesses, and recreation organizations, Amilia SmartRec streamlines operations, optimizes facility management, and simplifies program and membership management.

Since2009, Amilia has been on a mission to revolutionize how communities connect and participate in activities. By combining cutting-edge technology with deep industry expertise, the software empowers organizations to manage registrations, memberships, facilities, and finances more efficiently while enhancing community engagement.

Over 1,500 organizations across 6,600 locations in North America rely on Amilia to serve 4.5 million participants and process $750M in transactions annually.

Caring is at the core of Amilia’s culture : for customers, tailored products, and colleagues alike. Driven by an entrepreneurial spirit and a passion for innovation, this mindset shapes everything we do.

What you can expect :

As a key contributor to Amilia’s data-driven culture, the Data Analyst supports internal teams by transforming raw data into clear, actionable insights. This role focuses on creating, maintaining, and enhancing Power BI dashboards, performing exploratory and ad-hoc analysis, and supporting both internal and enterprise customer data needs.

You’ll also work with the BI Analyst and our Data Services Team to support custom reporting solutions for enterprise clients, using SQL and automation tools like PowerAutomate or other middleware. This is a great opportunity to deepen your BI skills while helping Amilia scale its data capabilities internally and externally.

You will be responsible for :

Dashboard Development & Data Support

Build and maintain Power BI dashboards for internal teams

Update and enhance existing dashboards based on feedback and business needs

Support internal teams with ad-hoc reporting and data requests

Ensure data used in reports is accurate, timely, and relevant

Custom Reporting for Enterprise Clients

Collaborate with the BI Analyst on SQL-based custom reporting for clients (e.g. YMCAs)

Help develop and maintain automated reporting workflows using PowerAutomate or other middleware

Work with Data Services and Client Success to understand and address client data export needs

Business Intelligence Analysis

Perform exploratory analysis to identify trends, anomalies, and opportunities

Translate data findings into clear business insights and visual storytelling

Assist in refining key metrics to track company and product performance

Data Governance & Learning

Maintain up-to-date documentation on dashboards and metrics in Confluence

Help ensure adherence to data definitions and reporting standards

Stay current with BI and automation tools, share learnings, and suggest improvements

What we want from you :

2 years of experience in data analytics or business intelligence, ideally within a SaaS environment, with a strong grasp of SaaS metrics such as ARR, churn, LTV, and CAC.

Proficiency in SQL and experience working with relational databases (e.g., MSSQL)

Experience with BI tools like Power BI, Looker, Tableau, or Data Studio.

Strong analytical thinking, attention to detail, and the ability to translate complex data into clear insights for both technical and non-technical audiences.

Familiarity with data pipelines, APIs, and ETL tools, as well as exposure to product analytics platforms

Bilingual proficiency in English and French is a strong asset.

What you will get from us :

A competitive and progressive salary;

A group RRSP employer contribution up to 5%;

A group insurance for you and your family as well as an Employee Assistance Program (EAP) and telemedicine;

A $750 wellness allowance per year;

The possibility of working in the office or at home, and up to3 months abroad per year

• conditions apply;

A strong work-life balance : flexible hours, 4 weeks' vacation and8 sick days yearly, and year-round mini-Fridays;

Skill development opportunities through engaging workshops, communities of practice, trainings, access to Udemy and opportunities to attend conferences;

Companywide and team bonding activities to connect with your peers throughout the year and weekly social activities to connect with your peers;

Weekly Bootcamp and Pilates classes for Amilians;

25% discount on annual membershipfor STM and EXO;

In-office snacks, including fresh fruit baskets, coffee, beverages, and free drinks.

Amilia is committed to the principle of equal employment opportunity and encourages applications from women, members of visible minorities and ethnic groups, Indigenous Peoples, persons with disabilities, or any other status protected by the laws or regulations of the Province of Quebec. Amilia is committed to providing a work environment free of discrimination and harassment. Amilia's strength lies in the sum of the ideas and innovations shared by its diverse and inclusive teams.