BI Reporting Developer Analyst

Jonas Software•Markham, ON

73d

About The Position

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.

Requirements

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 Haves

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.

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.