Data Solutions Consultant

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:

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.

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.