BI Reporting Developer Analyst

Jonas Club Software•Markham, ON

73d

About The Position

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. 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. Jonas Club Software provides innovative, industry leading solutions for the club business. That’s what we do, but how we do it is what matters. Every interaction we have with a client is crucial to their overall experience. These interactions include sales calls, training sessions, support processes, and even the client experience when using our products. To put it simply, in order for us to deliver great client interactions, we need the best people all working together to deliver the ultimate in client experience. This is why we work so hard to find the right people to join our team. Before you apply for an opening with Jonas Club Software, here are a few things that you should know: We’re here for the long term: Jonas Club Software is a subsidiary of Constellation Software Inc. which is publicly traded on the Toronto Stock Exchange (TSX: CSU). This ensures our financial stability, and gives us the ability to focus on long term objectives. We’re expanding: We’re the largest provider of software, communication and service solutions to the club industry, and every year we acquire new clients and deliver innovative solutions. We love employee success: Internal growth is a strong focus within our business. We hire the best, and want to see them succeed. That’s why we love to promote from within, and offer multiple professional development initiatives for our employees. We believe in having fun: Customer Service Excellence Celebration Weeks Departmental Outings Company Holiday Parties Private On-Site Staff Fitness Facility Beach Volleyball Courts Staff Fitness Challenges Much More

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.