Data Solutions Consultant

Amilia Enterprises Inc; Brampton; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

A leading technology firm in Brampton seeks a Data Solutions Consultant to lead data migrations and develop custom solutions for clients. Candidates should have experience in data migration, excellent analytical skills, and proficiency in tools like Power BI. This role offers competitive salary, flexible work arrangements, and comprehensive benefits including an RRSP contribution and wellness allowance.

Benefits

Competitive salary

RRSP employer contribution up to 5%

Group insurance and EAP

$750 wellness allowance

Flexible hours and work-life balance

Skill development opportunities

Weekly fitness classes

In-office snacks

Qualifications

• Proven experience in data migration and ETL methodologies.
• Experience in SaaS or payment systems is a significant asset.
• Bilingual in English and French preferred.

Responsibilities

• Lead end-to-end data migration efforts including users and payments.
• Build custom reports using Power BI.
• Collaborate with Product and Engineering to enhance platform features.

Skills

Data migration experience

ETL methodologies

Proficiency in Excel / Google Sheets

SQL skills

Data visualization tools

APIs and middleware experience

Strong analytical skills

Excellent communication skills

Tools

Power BI

Google Sheets

APIs

Job description

Overview

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.

Since 2009, 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 Data Solutions Consultant, you’ll be at the heart of our client onboarding experience. You’ll lead the charge in migrating complex datasets from legacy systems to SmartRec, while also designing custom data solutions that help our clients make smarter decisions. You’ll collaborate with cross-functional teams and act as a trusted advisor, solving real-world data challenges with creativity and precision.

This is a unique opportunity to shape a growing team, build scalable processes, and make a direct impact on our clients’ success.

You will be responsible for:

Responsibilities

• Data Migration & Onboarding: Scope and propose migration strategies during the sales cycle
• Lead end-to-end data migration efforts (users, activities, payments)
• Document and refine repeatable migration processes
• Partner with Implementation Consultants to ensure smooth transitions
• Customer-Centric Data Solutions: Solve data-related business challenges with tailored solutions
• Build custom reports and dashboards using tools like Power BI, API connectivity, automation tools
• Support integrations with third-party applications
• Advise clients on SmartRec’s data structures and best practices
• Process Improvement & Collaboration: Identify opportunities to improve and scale migration workflows
• Maintain internal knowledge bases and integration guides
• Collaborate with Product and Engineering to enhance platform features
• Contribute to new service offerings that meet evolving client needs

What we want from you

• Proven experience in data migration and ETL methodologies
• Experience in SaaS, accounting data migration, or payment systems is a significant asset
• Proficiency in Excel / Google Sheets, SQL, and data visualization tools
• Experience with APIs, middleware, and custom integrations
• Strong analytical skills and attention to detail
• Excellent communication skills in English — able to translate technical concepts for non-technical audiences. Bilingual is preferred (English & French)

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 to 3 months abroad per year
• conditions apply;
• A strong work-life balance: flexible hours, 4 weeks' vacation and 8 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 membership for STM and EXO;
• In-office snacks, including fresh fruit baskets, coffee, beverages, and free drinks.