Senior Data Engineer

Jonas Software; Canada; On-site; CAD 100,000 - 130,000; Full time

Job summary

A leading software provider in Canada seeks a Senior Data Engineer to design systems and lead data transformation initiatives. The ideal candidate will have significant experience in SQL Server and the AWS data stack, proven project leadership skills, and advance analytical abilities to drive data-driven decision-making within the organization. This role involves hands-on engineering and managing a Technical Business Analyst, ensuring high-performance, scalable data solutions for both internal and client-facing needs.

Qualifications

• 7+ years of professional experience in data engineering or architecture roles.
• Proven track record of leading data transformation projects.
• Strong hands-on experience with AWS and SQL Server.

Responsibilities

• Design and implement scalable data solutions.
• Optimize ETL/ELT pipelines for data processing.
• Lead data transformation initiatives.

Skills

SQL Server expertise

AWS data stack

Data modeling

Data visualization tools

Analytical skills

Education

Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or related field

Tools

Power BI

Tableau

AWS Redshift

Job description

Senior Data Engineer Job Description - InnoSoft Canada Inc.

POSITION SUMMARY

InnoSoft Canada is looking for a Senior Data Engineer to lead our data department and drive the modernization of our data systems. In this role, you will both architect and build the infrastructure that powers client-facing reporting, internal analytics, and data-driven decision making. You will directly manage a Technical Business Analyst I, but will remain highly hands-on—designing pipelines, optimizing performance, and delivering reliable data solutions.

This role requires proven expertise in designing and implementing modern data architectures, leading transformation initiatives, and building high-performance systems that support both client reporting and internal business intelligence needs. This is a technical leadership role for someone who enjoys solving complex problems at scale and has proven success delivering end-to-end data transformation initiatives.

ABOUT INNOSOFT

InnoSoft Canada, creators of Fusion + Fusion Family suite of products, recreation management software solutions aimed at enhancing the overall well-being of individuals and communities through technology. At InnoSoft, we believe in the transformative power of technology to drive positive change and it is our mission to create innovative, user-friendly products that bring people together, foster collaboration, and promote a sense of belonging. Our customer-centric approach drives us as a company to not only deliver outstanding products but also build collaborative, lasting relationships with our clients.

Operating under the Jonas Software Group, we are a proud subsidiary of the public company, Constellation Software, Inc. (CSI), an international provider of market-leading software with revenues of over $3.5 billion USD and 20,000+ employees across the globe.

JOB RESPONSIBILITIES

The core responsibilities of the position include:

Data Architecture & Infrastructure

• Design and implement scalable multi-tenant data solutions that ensure security, isolation, and performance across tenants.
• Develop, optimize, and monitor ETL/ELT pipelines to ingest, transform, and serve data from multiple systems.
• Implement data models and schemas that support downstream analytics, BI, and machine learning use cases
• Build infrastructure to support both client-specific reporting and aggregate reporting for InnoSoft.

Hands-On Data Engineering

• Continuously evaluate and optimize the performance, cost, and scalability of data systems.
• Write advanced SQL queries, stored procedures, and scripts for large-scale data processing.
• Manage and improve telemetry, logging, and exception datasets to drive insights into product and client performance.
• Build dashboards and reporting layers that deliver actionable insights to both internal and client-facing stakeholders.
• Partner with product, engineering, and business teams to define requirements and deliver actionable insights.
• Establish monitoring, validation, and error-handling frameworks to ensure data integrity, governance, and compliance with industry best practices.

Strategic Data Projects

• Lead InnoSoft’s data transformation initiatives, modernizing legacy systems and processes into a unified, scalable data ecosystem that supports real-time analytics, predictive insights, and performance benchmarking.
• Design, implement, and maintain data automation processes, advanced analytics, and AI/ML applications to improve business outcomes.
• Deliver the Operational Excellence Index benchmarking project, designing the data models, metrics, and reporting framework to measure performance and client success.
• Collaborate with product, engineering, and business teams to define requirements, prioritize initiatives, and ensure data solutions align with business needs.

Leadership & Mentorship

• Oversee all data analysis, reporting, and business intelligence activities.
• Manage and mentor a Technical Business Analyst I, guiding their work in data analysis, reporting, and solution development.
• Set coding standards, review technical work, and establish a culture of engineering best practices.
• Advocate for automation, repeatability, and modern development practices in all data workflows.

JOB QUALIFICATIONS

The core qualifications for the position are:

Required:

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or related field.
• 7+ years of professional experience in data engineering or data architecture roles.
• Proven track record of leading a data transformation project from planning through implementation.
• Deep expertise in SQL Server (query optimization, schema design, indexing, performance tuning).
• Strong hands-on experience with AWS data stack (e.g., Redshift, RDS, S3, Glue, Lambda, Athena, Lake Formation, DMS).
• Demonstrated experience building and managing ETL/ELT pipelines for large-scale data sets.
• Strong skills in data modeling, warehousing, and reporting architecture.
• Proficiency with data visualization tools (Power BI, Tableau, or similar).
• Professional experience with AI/ML, predictive analytics, or advanced statistical modeling.
• Excellent leadership, collaboration, and communication skills, with the ability to explain complex data-driven insights to various stakeholders and translate business needs into actionable technical requirements. Experience managing direct reports is a plus.
• Strong analytical and problem-solving skills with a focus on identifying business challenges and developing solutions.
• Strong understanding of multi-tenant architecture, data isolation and application/data security.

Preferred:

• Experience with telemetry, logging, and exception data analysis.
• Familiarity with CI/CD for data pipelines and Infrastructure as Code (Terraform, CloudFormation).
• Exposure to Python or other scripting languages for data engineering.
• Background in SaaS or product-driven organizations with high data demands.

Key Technical Skills

• Databases: SQL Server (T-SQL, schema design, optimization), AWS Redshift
• Cloud & Infrastructure: AWS (RDS, S3, Glue, Lambda, Athena), Terraform/CloudFormation (preferred)
• ETL/ELT: Data pipeline design, orchestration, and monitoring
• Programming/Scripting: SQL (expert), Python (preferred)
• Data Modeling & Warehousing: Star/snowflake schema, dimensional modeling, partitioning strategies
• Visualization & Reporting: Power BI, Tableau, or similar BI tools
• Other Tools: Git, JIRA, Confluence, CI/CD pipelines for data

Note: Business Unit: Innosoft

Scheduled Weekly Hours: 37.5

Number of Openings Available: 1

Worker Type: Regular

More About Jonas Software:

Jonas Software is the leading provider of enterprise management software solutions to the Country and Golf Clubs, Foodservice, Construction, Fitness & Sports, Attractions, Salon & Spa, Education, Radiology/Laboratory Information Systems, and Product Licensing industries. Within these vertical markets, Jonas is made up of over 65 distinct brands, which are respected and leaders within their own domain.

Jonas’ vision is to be the branded global leader across the aforementioned vertical markets and to be recognized by customers and respective industry stakeholders as the trusted provider of ‘Software for Life’ and as an ambassador for technology, product innovation, quality, and customer service.

Jonas Software is the valued technology partner of over 60,000 customers worldwide in more than 30 countries. Jonas employs over 2,000 skilled individuals consisting of a cross-section of industry experts and technology professionals. Jonas is headquartered in Canada and also operates offices throughout North America, the United Kingdom, Europe, Australia New Zealand and Africa. Jonas is a 100% owned subsidiary of Constellation Software Inc., headquartered in Toronto and traded on the S&P/TSX 60.