BI Data Engineer

Job Description: Role Overview We are seeking a BI Data Engineer 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. 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. 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 (), and a member of the S&P/TSX 60 Index.