Business Intelligence Specialist Development

CAA Club Group; Area E (Thornhill); On-site; CAD 75,000 - 110,000; Full time

Benefits offered by this job

Wellness program

Education reimbursement

Discounts on products/services

Travel incentives

Defined contribution plan

Personal spending account

Job summary

CAA Club Group is seeking a Business Intelligence Specialist with strong Qlik and/or C# experience to drive data insights across Membership Operations. You will design, build, and deploy BI solutions, including PowerBI and Qlik dashboards, data models, and automated data pipelines.

The role emphasizes collaboration with Analysts and business partners, developing EDW data elements, and maintaining documentation.

Qualifications

• 3+ years of expert-level experience with BI tools (PowerBI, Qlik Sense).
• 3+ years of expert-level hands-on coding in SQL and DAX.
• 3+ years of experience with Microsoft SQL Server architecture, administration and management.
• 3+ years of experience with Microsoft Visual Studio.

Responsibilities

• Build and maintain PowerBI dashboards and datasets.
• Develop and maintain Qlik applications (front-end and backend).
• Design, develop and deploy SQL Server Integration packages (SSIS).
• Write and optimize complex SQL queries and data loads.
• Create data feeds to support business processes and KPI development.

Skills

PowerBI

Qlik Sense

SQL

DAX

Tools

Microsoft Visual Studio

SQL Server Integration Services

SQL Server Management Studio

Team Foundation Server

Job description

Career Opportunities: Business Intelligence Specialist (with Qlik and/or C# experience) (8318)

Requisition ID8318-Posted07/24/2026-Analytics-Membership Operations-THORNHILL-Contact Centre-CAA Club Group-Mid-Career-0 - 10%-Full Time- Job Location (country) (1) - Job Location (region) (1)

At CAA Club Group, we are passionate about keeping our Memberssafe - whether they are on the road, at home, or travelling abroad.As atrusted Member-based organization, we provide products and services that are essential to Members’ safety and peace of mind. With over 2.6 million Members across Ontario and Manitoba, we advocate on issues such road safety and infrastructure, the environment, seniors’ mobility, and consumer protection. Associates share in each other’s successes, drive change and support each other while cultivating a great working environment to deliver on what is best for our Members. CAA Club Group is a member of the CAA Club Group of Companies.

Who we are

Are you ready to join an award-winning, purpose-driven culture? Welcome to the CAA Club Group of Companies (CCG), where purpose leads to passion!

At CCG, we are committed to delivering an exceptional Associate experience. We offer:

• Work-life harmony with access to an award-winning holistic wellness program,
• Continuous learning through our robust corporate curriculum and education reimbursement program,
• Incredible rewards, travel incentives, and product and service discounts,
• Pay-for-performance and best-in-class recognition programs, and
• Competitive benefits that include a defined contribution plan, personal spending account, and so much more.

Join our growing team where everyone belongs!

What You Will Do:

• Liaise with other CSS units in identifying, understanding, and articulating business intelligence aspects for major projects/initiatives
• Read and interpret database schema and analyze business requirements
• Liaise with Business Analysts and line of business partners to probe and ask clarifying questions
• Develop and document proposed solution design & architecture
• Demo completed solutions to ensure business partners questions are addressed prior to sign off
• Extract, transform and analyze complex data elements from a variety of database servers and systems with focus on development/deployment of automated solutions
• Develop, test and deploy SQL Server Integration packages, wite SQL queries, Create SQL execution packages and ensure data load integrity, Utilize SQL Server Agent
• Complete fulsome testing of all solutions including documentation of test evidence
• Complete service requests for the promotion of solutions from the Development to Production environments in line with business intelligence lifecycle.
• Create comprehensive and automated BI solutions to utilize data infrastructure, EDW and external data sources
• Build and maintain PowerBI elements including reports, dashboards and datasets
• Build and maintain Qlik applications including front-end design and backend cube development
• Build and maintain data feeds to support business process including compensation models, voice of the customer invitation files and feeds as required by business vendors
• Provide support to the business in target setting and KPI development
• Document and track work effort and hours using the work management tool
• Proactively identify opportunities for business process improvement
• Create technical documents for all newly built solutions
• Keep current on emerging tools and techniques and grow knowledge of the business
• Create and maintain solution diagrams and database dictionaries
• Utilize CTRL-M for job scheduling
• Serve as Subject Matter Expert (SME) on EDW Data elements
• Maintain all solutions within Team Foundation Server

Who You Are:

• 3+ years of expert-level experience with BI tools (PowerBI, Qlik Sense)
• 3+ years of expert-level hands-on coding in SQL and DAX
• 3+ years of experience with Microsoft SQL Server architecture, administration and management
• 3+ years of experience with Microsoft Visual Studio
• 3+ years of experience designing/developing and deploying Microsoft SQL Server Integration packages
• 3+ years of experience with query debugging, optimization and performance tuning in a big data environment
• Advanced knowledge of Microsoft Office products (Word, Excel, PowerPoint and Access)
• Ability to take complex data and visualize to identify and describe creative solutions to analytical and data problems
• Ability to develop analytical frameworks and generate / communicate business insights
• Attention to detail and high aptitude for problem solving

Please note, salary range is not inclusive of total compensation. The expected salary range for this position will be impacted by factors such as the successful candidate’s skills, experience and working location, as well as the specific position’s business line, scope and level. Candidates with salary expectations outside of the range are encouraged to apply.

Our Commitment

We are an equal opportunity employer and are committed to providing employment accommodationin accordance withall applicable Provincial Human Rights and Accessibility Legislation.CCG will provide accommodations to job applicants with disabilities throughout the recruitment process.If you requirean accommodation, pleasenotify usand we will work with you to meet your needs.