Business Intelligence Analyst (ON)

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

Who We Are:
• 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
• Write complex SQL queries
• 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

Who You Are:

• Undergraduate degree in Computer Science, Statistics, Mathematics, or other quantitative fields
• 1+ years of experience with BI tools (SSRS, PowerBI, QlikSense)
• 1+ years of hands-on coding in SQL and DAX
• 1+ years of experience with Microsoft Visual Studio 
• 1+ years of experience designing/developing and deploying Microsoft SQL Server Integration packages is preferred 
• 1+ years of experience with query debugging, optimization and performance tuning in a big data environment
• Advanced knowledge of Microsoft Office products (Word, Excel, and PowerPoint)
• 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
• Ability to critically think and bring an outside of the box lens to problems
• Good communication skills

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). 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.

As an organization we are focused on Member safety, which includes the safety and well-being of our Associates. Therefore, you must be and remain fully vaccinated as a condition of employment.