Business Intelligence Consultant Analytics - Jobs in Thornhill, ON

Job Description

About UsAs 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 areWe are seeking a highly motivated and career minded individual to join our team as a Business Intelligence Consultant on the analytics side in our Analytics department.Position DetailsIn this role, you will be working on things like:

• Analyze complex data elements from a variety of database servers and systems
• Write complex SQL queries and create AdHoc reporting as required
• Focusing on business challenges, apply statistical methodology to complex problems selecting the most appropriate tools/models and build hypotheses for solving those challenges
• Recommend operational system enhancements to improve data quality and analytical accuracy
• Support lines of business in a variety of analytical needs including development of robust analytical plans, statistical analysis, key performance indicators, benchmarking, data visualizations, routine and ad hoc reporting
• Provide analytics support on key projects/initiatives aligned to business or organizational strategies
• Create comprehensive and automated BI & Reporting solutions to utilize data infrastructure, EDW and external data sources
• Utilize machine learning techniques to proactively identify opportunities for business process improvement
• Build and maintain PowerBI elements including reports, dashboards and datasets
• Investigate and document root cause for any data-related business process failure and assist in fix design and implementation
• Provide technical guidance, support, and expertise to the team including assessing Associate work, providing feedback and documenting coaching notes

JOB REQUIREMENTS:

• 5+ years of expert-level experience with BI tools (PowerBI, QlikView, QlikSense, Tableau)
• 5+ years of expert-level hands-on coding in SQL and DAX
• 5+ years of experience with Microsoft SQL Server architecture, administration and management
• 5+ years of experience with Microsoft Visual Studio
• 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
• Ability to develop analytical frameworks and generate / communicate business insights
• Attention to detail and high aptitude for problem solving
• Good communication skills
• Familiarity with VBA, Google App Script (JavaScript), C+ and/or Oracle
• Proficiency with R or Python is an asset

Our CommitmentWe 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.