BI Data Engineer

Jonas Club Software; Markham; On-site; CAD 70,000 - 90,000; Full time

Job summary

A technology solutions provider is seeking a Development Analyst for their Business Intelligence team in Markham, Canada. The role involves designing and optimizing BI assets using AWS QuickSight and SQL to transform data into actionable insights. Key responsibilities include developing interactive dashboards, performing complex data analysis, and collaborating with stakeholders. Candidates should have 2–5 years of experience in BI roles and strong SQL skills. This position ensures business decisions are data-driven and efficient.

Qualifications

• 2–5 years in BI/Reporting roles with measurable delivery.
• Hands-on experience with AWS QuickSight.
• Strong analytical and communication skills.

Responsibilities

• Build interactive dashboards using AWS QuickSight.
• Optimize SQL for data extraction and transformation.
• Collaborate with business users to gather reporting requirements.

Skills

SQL (complex joins, window functions, CTEs)

AWS QuickSight

Data Analysis

Strong analytical skills

Stakeholder management

Tools

AWS data services (Athena, Redshift, RDS, S3)

ETL tools (Glue, dbt)

Job description

Role Overview

We are seeking a Development Analyst to join our Business Intelligence and Reporting team. You will design, build, and optimize BI assets—dashboards, reports, data models—primarily using AWS QuickSight and SQL, turning data into actionable insights that drive business decisions. If you thrive at the intersection of data, visualization, and stakeholder collaboration, this role is for you.

Key Responsibilities

• BI Solution Development:
  • Build interactive dashboards in AWS QuickSight (including parameters, controls, calculated fields, and narratives).
  • Implement data visualizations that effectively communicate business insights.
  • Implement row‑level security and data governance standards across BI assets.
• Data Analysis & Modeling:
  • Write and optimize complex SQL for data extraction, transformation, aggregation, and performance tuning.
  • Design semantic layers and curated datasets aligned to reporting needs.
• Requirements Gathering:
  • Collaborate with business users to understand reporting requirements.
  • Translate business needs into technical specifications.
  • Contribute to ETL specifications and unit testing for data quality and lineage.
• Performance Optimization:
  • Ensure dashboards and queries are optimized for performance and scalability.
  • Monitor and troubleshoot BI solutions for accuracy and efficiency.
• Documentation & Standards:
  • Maintain documentation for BI processes, data models, and dashboards.
  • Adhere to data governance and security standards.

Must‑Have Qualifications

• 2–5 years in BI/Reporting roles with measurable delivery of dashboards and analytics.
• Strong SQL: complex joins, window functions, CTEs, aggregations, performance optimization.
• Hands‑on experience with AWS QuickSight (visual types, RLS, parameters, datasets, SPICE).
• Working knowledge of AWS data services (Athena, Redshift, RDS, S3, Glue/IAM basics).
• Solid understanding of data warehousing concepts (star/snowflake schemas, dimensional modeling).
• Strong analytical, communication, and stakeholder management skills.
• Experience using AI tools to accelerate development.

Nice‑to‑Have Skills

• Experience with ETL tools (Glue jobs, dbt, or similar) and CI/CD for BI assets.
• Scripting (Python) for data wrangling or automation.
• Exposure to data governance (cataloging, lineage, definitions), and security (IAM/RLS).
• Knowledge of performance tuning in QuickSight (SPICE capacity, query pushdown, visuals optimization).
• Familiarity with visualization best practices and UX for analytics.

Key Competencies

• Data Storytelling: Can translate complex data into clear visuals and narratives.
• Customer Focus: Collaborates with business partners to prioritize high‑value insights.
• Bias for Action: Ships iteratively, validates quickly, and improves continuously.
• Quality & Accuracy: High attention to detail; strong testing discipline.
• Ownership: Proactive in monitoring, documentation, and support.

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.