BI Data Engineer: Dashboards & Data Pipelines (Hybrid)

Jonas Software; Markham; Hybrid; CAD 100,000 - 115,000; Full time

Job summary

Jonas Software is seeking a BI Data Engineer to design, build, and optimize BI assets like dashboards and semantic data models. The role focuses on AWS QuickSight atop SQL-based datasets and involves data pipelines, modeling, and a web presentation layer.

You will turn business asks into governed, high‑quality dashboards and reports, maintaining SQL models and an application layer with Node.js, Express.js, MongoDB, SQL and .NET. Hybrid work in Markham, ON with 37.5 weekly hours.

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 (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.

Responsibilities

• 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.

Skills

Strong SQL

Data wrangling

Web development basics

Git workflows

AWS QuickSight

Data modeling

.NET

JavaScript

Python

SQL performance tuning

MongoDB

Tools

Node.js

Express.js

MongoDB

SQL

.NET

AWS

Git

Job description

Jonas Software is seeking a BI Data Engineer to design, build, and optimize BI assets like dashboards and semantic data models. The role focuses on AWS QuickSight atop SQL-based datasets and involves data pipelines, modeling, and a web presentation layer.

You will turn business asks into governed, high‑quality dashboards and reports, maintaining SQL models and an application layer with Node.js, Express.js, MongoDB, SQL and .NET. Hybrid work in Markham, ON with 37.5 weekly hours.