BI Data Engineer

Perseus Group; Markham; Hybrid; CAD 100,000 - 115,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

Jonas Software in Markham, ON is seeking a BI Data Engineer to design, build, and optimize BI assets, dashboards, and semantic data models using AWS QuickSight on SQL data. This hands‑on role focuses on data pipelines, modeling, and a web presentation layer, delivering governed dashboards and reports from production data.

The candidate will craft data pipelines, optimize SQL, and collaborate with stakeholders to translate business asks into reliable analytics, with hybrid work and a strong focus

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, JavaScript, Python and CSS.
• Good understanding of data warehousing and dimensional modeling.
• 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.
• Security and governance awareness in BI assets.

Responsibilities

• BI Solution Development: Build interactive dashboards and semantic models.
• Data Analysis & Modeling: Write and optimize SQL for reporting needs.
• Data Pipeline Engineering: Manage data shaping jobs and data quality.
• Web Application Upkeep & Maintenance: Maintain OAuth, Node.js, MongoDB-based layers.

Skills

SQL proficiency

Data wrangling

Python

Git workflows

CI/CD

Tools

AWS QuickSight

.NET

Node.js

MongoDB

Power BI

Snowflake

DataBricks

Docker

Job description

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

1

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. At Jonas we have long realized that our greatest asset is our employee base. As such we strive to provide our team with a fantastic working environment and an enriching career, which we know will translate into world class service to our valued clients. This allows Jonas Software to maintain and extend our lead as the premier software and services provider in each of our markets. If being part of a growing organization that moves at a fast pace and constantly strives to get better each and every day is what you are looking for, then we want to hear from you. Everyone has heard the sports analogy "to be the best, you have to beat the best"; well at Jonas Software we have tweaked that slightly to fit vertical market software. We believe to be the best you have to hire and retain the best!!! Jonas Software is an Equal Opportunity Employer. If you need accommodation for a disability at any stage of the application process or want more information on our accommodation policies, contact recruitment at [e-mail] or 905-470-4600. Jonas Software and its subsidiaries will never request payment, banking information, or sensitive personal documents from candidates at any stage of the application or interview process. Any such requests should be treated as fraudulent. If you receive suspicious communication claiming to represent Jonas Software or one of our subsidiaries, please contact us at [e-mail].