Jonas Software
BI Data Engineer
- Compensation
- CA$100K–CA$115K / yr
- Location
- Canada - Markham - Ontario
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 2+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 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
- 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.
Full description
##
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 concepts (star/snowflake schemas, dimensional modeling).