Jonas Software

Long-term ownership of vertical software

BI Data Engineer

Data Engineering +1Confirmed live in the last 24 hours

Full-timeMarkham, ON, CanadaCA$100k - CA$115k

About the Job

Requirements

Two to five years of experience in a business intelligence or reporting development role.
Strong SQL skills, including complex joins, window functions, common table expressions, aggregations, and query performance tuning.
Strong data wrangling, pipeline, and basic web development skills, with experience in .NET, JavaScript, Python, and CSS.
Understanding of data warehousing and dimensional modeling, including star schemas and semantic layers.
Experience with AWS QuickSight, including parameters, controls, calculated fields, and dataset design.
Hands-on AWS Cloud experience and knowledge of AWS data services, including S3, Lambda, and IAM basics.
Hands-on experience with Git and typical development workflows.
Ability to improve data quality and produce reliable reports.
Good communication skills.

Responsibilities

Build interactive QuickSight dashboards using parameters, controls, and calculated fields.
Implement data visualizations that communicate business insights clearly.
Apply security and data-governance standards across BI assets.
Write and optimize complex SQL for extraction, transformation, aggregation, and performance tuning.
Design semantic layers and curated datasets aligned with reporting needs.
Monitor and troubleshoot BI solutions for accuracy, performance, scale, and efficiency.
Contribute to data acquisition, wrangling, and shaping, and validate data quality and lineage for reporting.
Orchestrate and manage cloud-based data-shaping jobs to maintain a high-quality data model.
Maintain the web application layer built with OAuth, Node.js, Express.js, MongoDB, SQL, and .NET.

Desired Qualifications

Maintain web applications, fix defects, and test fixes.
Experience with Google Charts API.
Build and maintain API layers for data acquisition and data services.
Automate data jobs that can run at scale.
Deliver email digests and narrative summaries beyond classic reports, dashboards, and analytics.
Knowledge of SPICE and row-level security.
Experience using AI tools to accelerate development.
Experience with MongoDB.
Experience with Docker and container deployments.
Experience with Service Bus.
Experience with pandas DataFrames.
End-to-end production experience spanning data acquisition through the presentation layer.
Exposure to data governance, including cataloging, lineage, and definitions.
Continuous integration and continuous delivery for BI assets.
Knowledge of BI solutions such as Power BI and Looker.
Knowledge of data lake or data warehouse solutions such as Snowflake and Databricks.
Experience automating quality assurance.
Experience with build tools such as Jenkins.
Experience with cloud operations, DevOps, and automation.
Experience building prediction models.
Experience building interactive chat-type solutions over existing data assets.
Knowledge of visualization best practices and user experience for analytics.

Job Description:

BI Data Engineer

Full stack engineer for BI / Reporting solution

Location: Markham, ON (Hybrid)

Employment Type: Full-Time

Department: Business Intelligence / Data Analytics

Reporting To: Director, BI / Analytics

Seniority Level: Intermediate (2–5 years)

Compensation & Role Details:

Expected Salary Range: The expected base salary range for this role is between $100,000 – $115,000 CAD, depending on experience and qualifications

Role Type: New Role

AI Disclosure: AI may be used during the hiring process.

Role Overview

We are seeking a BI Data Engineer to design, build, and optimize BI assets — dashboards, reports, and semantic data models — primarily in AWS QuickSight on top of SQL-based datasets. This is a hands-on BI role that involves building data models, data pipelines and a web presentation layer. Your day is spent turning business ask into governed, performing dashboards and reports served through web application and build / maintain SQL models behind them.

Key Responsibilities

BI Solution Development

Build interactive QuickSight dashboards (parameters, controls, calculated fields).
Implement data visualizations that clearly communicate business insights.
Apply security and data-governance standards across BI assets.

Data Analysis & Modeling

Write and optimize complex SQL for extraction, transformation, aggregation and performance tuning.
Design semantic layers and curated datasets aligned to reporting needs.
Monitor and troubleshoot BI solutions for accuracy, performance, scale and efficiency.

Data Pipeline Engineering

Contribute to data acquisition, wrangling, shaping and validate data quality and lineage for reporting.
Orchestrate and manage data shaping jobs that run in Cloud to maintain a high quality data model

Web Application Upkeep & Maintenance

Application layer built with OAuth, Node.JS, Express.JS, MongoDB, SQL and .NET

Must-Have Qualifications

2–5 years in a BI / reporting development role.
Strong SQL: complex joins, window functions, CTEs, aggregations, and query performance tuning.
Strong data wrangling, pipeline and basic web development skills. Experience with .NET, Java Script, Python and CSS.
Good understanding of data warehousing and dimensional modeling (star schemas, semantic layers).
Good AWS QuickSight experience. Knowledge of parameters, controls, calculated fields and dataset design.
Hands on AWS Cloud experience. Knowledge of AWS data services: S3, Lambda and IAM basics.
Hands on experience with Git and typical development workflows.
Comfortable with work needed to improve data quality & produce reports users can rely on
Good communication skills.

Nice-to-Have Skills

Maintaining web application, fixing defects and testing fixes
Experience with Google charts API
Building and maintaining API layer for data acquisition and data services
Automating data jobs that can run at scale
Experience delivering email digests, Narrative summaries that go beyond classic reports, dashboards, analytics
Knowledge of SPICE and row-level security
Experience using AI tools to accelerate development
Experience with Mongo DB
Experience with Docker and container deployments
Experience with Service Bus
Experience with pandas Data Frames
End to end experience going from data acquisition through presentation layer in a production setting
Data governance exposure (cataloging, lineage, definitions)
Continuous integration / Continuous Delivery (CI/CD) for BI assets.
Knowledge of BI solutions like Power BI, Looker
Knowledge of Data lake / Data warehouse solutions like Snowflake, DataBricks
Experience automating QA
Experience with build tools like Jenkins
Experience with Cloud Ops, Dev Ops and automation
Experience building prediction models
Building interactive chat type solutions over existing data assets
Best Visualization practices and UX for analytics

Key Competencies

Data Storytelling: Translates complex data into clear visuals and narratives.
Fast Learner: Curious and fast paced learner that can adapt to change;
Bias for Action: Ships iteratively, validate quickly and improve continuously.
Quality & Accuracy: High attention to detail; strong testing discipline. Security consciousness
Customer Focus: Collaborates with business partners to understand and deliver high-value insights.
Ownership & Scope Discipline: Proactive in monitoring and support; comfortable owning BI/reporting deliverables

Business Unit:

Jonas Club

Scheduled Weekly Hours:

37.5

Number of Openings Available:

Worker Type:

Regular

More About Jonas Software:

Jonas Software is a leading provider of enterprise management software solutions, serving a wide range of vertical markets including hospitality, healthcare, construction, education, personal care, fitness, leisure, moving and legal services, to name a few. Within these markets, Jonas is comprised of over 65 distinct brands, each a respected leader in its domain.

Jonas’ vision is to be the branded global leader across these verticals and to be recognized by customers and industry stakeholders as the trusted provider of “Software for Life.” We are committed to technology, product innovation, quality, and exceptional customer service.

Jonas Software supports over 60,000 customers in more than 30 countries. We employ over 6,000 skilled professionals, including industry experts and technology specialists. Across our broader network, we support a global workforce of more than 30,000 employees.

Headquartered in Canada, Jonas Software has a global footprint with offices around the world. We’re a 100% owned subsidiary of Constellation Software Inc., based in Toronto, publicly listed on the TSX (CSU.TO), and a member of the S&P/TSX 60 Index.

About the Company

Jonas Software

Long-term ownership of vertical software

Jonas Software manages a decentralized portfolio of over 160 independently run software companies across more than 40 vertical markets. It buys vertical market software (VMS) businesses and holds them long-term, allowing each company to keep its brand, leadership, and culture while Jonas provides capital, strategic oversight, and financial stability. Revenue comes from the ongoing operations of the portfolio’s companies, with the model focusing on deep industry expertise in nich es rather than restructuring or selling. Goal: grow value across the portfolio by supporting stable, niche-focused software companies for the long term, maintaining ownership stability instead of pursuing quick flips.

Company size: 1,001-5,000
Company stage: Not listed
Total funding: Not listed
Headquarters: Toronto, Canada
Founded: 1990

Recently Posted Jobs

Explore more opportunities at Jonas Software

See more jobs