Share this Job

Business Intelligence Specialist Analytics

Date: Jun 18, 2022

Location: Thornhill, ON, CA, L3T 7P9

Company: CAA Club Group

About Us

As Canada's largest automobile association, we are passionate about keeping our Members safe-- whether they are on the road, at home, or travelling abroad. Meeting the diverse needs of our two-million Members requires high performing, forward thinking, and innovative people who work collaboratively to keep propelling our business forward. Life at CAA Club Group is fast paced, performance-driven and rewarding. We value our Associates' career growth and ongoing professional development-- and we regularly recognize their achievements and outstanding results. CAA Club Group (CCG) is known for providing stellar emergency roadside assistance to our motoring Members and non-Members. We work hard and play hard. We're about doing what's right and feeling good about it.

Who we are

We are seeking a highly motivated and career minded individual to join our team as a Business Intelligence Specialist on the development side in our Analytics department. 

Position Details

In this role, you will be working on things like:

• Analyze business requirements and develop proposed solution design & architecture
• 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
• Write complex SQL queries
• Create SQL execution packages and ensure data load integrity
• Build and maintain PowerBI elements including reports, dashboards and datasets
• Build and maintain SSRS reports
• Build and maintain solutions 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

• Undergraduate degree in Computer Science, Statistics, Mathematics, or other quantitative fields
• Completion of or willingness to complete Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Development Certification
• 3+ years of expert-level experience with BI tools (PowerBI, QlikView, QlikSense, Tableau)
• 3+ years of expert-level hands-on coding in SQL and DAX
• 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)
• Proficiency in business intelligence lifecycle
• Experience developing and implementing enterprise-scale reports and dashboards
• Ability to take complex data and visualize to identify and describe creative solutions to analytical and data problems
• Attention to detail and high aptitude for problem solving
• Good communication skills
• Familiarity with VBA, Google App Script (JavaScript), C+ and/or Oracle

Our Commitment

We are an equal opportunity employer and are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005 (AODA). CAA CCG will provide accommodations to job applicants with disabilities throughout the recruitment process. If you require an accommodation, please notify us and we will work with you to meet your needs.