Business Intelligence Specialist Analytics (with Qlik and/or SSIS experience)
Top Benefits
About the role
Job description:
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 2.5M+ Members requires high performing, forward thinking, and innovative people who work collaboratively to keep propelling our business forward.
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!
Position Details
What You Will Do:
⦁ 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
Who You Are:
⦁ Undergraduate degree in Computer Science, Statistics, Mathematics, or other quantitative fields
⦁ 1+ years of Qlik Sense mandatory (Geo analytics experience is strongly preferred)
⦁ 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)
⦁ Experience with C# and .NET is considered an asset
⦁ 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 all applicable Provincial Human Rights and Accessibility Legislation. 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.
About CAA Club Group
For close to 120 years, we have been innovative leaders committed to meeting and exceeding the needs of Canada’s motorists and travellers.
CAA Club Group of Companies (CCG) is comprised of two automobile clubs—CAA South Central Ontario and CAA Manitoba— that provide Roadside Assistance, travel, insurance service and Member savings for our over 2.5 million Members. Our organization also includes CAA Insurance Company, a national property and casualty insurance company, Orion Travel Insurance Company, a nationwide trusted travel insurer, Echelon Insurance, a leading specialty insurer and CCG Advisory Services, a new company providing Ontarians with trusted advice on life, critical illness, and disability insurance.
Business Intelligence Specialist Analytics (with Qlik and/or SSIS experience)
Top Benefits
About the role
Job description:
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 2.5M+ Members requires high performing, forward thinking, and innovative people who work collaboratively to keep propelling our business forward.
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!
Position Details
What You Will Do:
⦁ 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
Who You Are:
⦁ Undergraduate degree in Computer Science, Statistics, Mathematics, or other quantitative fields
⦁ 1+ years of Qlik Sense mandatory (Geo analytics experience is strongly preferred)
⦁ 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)
⦁ Experience with C# and .NET is considered an asset
⦁ 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 all applicable Provincial Human Rights and Accessibility Legislation. 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.
About CAA Club Group
For close to 120 years, we have been innovative leaders committed to meeting and exceeding the needs of Canada’s motorists and travellers.
CAA Club Group of Companies (CCG) is comprised of two automobile clubs—CAA South Central Ontario and CAA Manitoba— that provide Roadside Assistance, travel, insurance service and Member savings for our over 2.5 million Members. Our organization also includes CAA Insurance Company, a national property and casualty insurance company, Orion Travel Insurance Company, a nationwide trusted travel insurer, Echelon Insurance, a leading specialty insurer and CCG Advisory Services, a new company providing Ontarians with trusted advice on life, critical illness, and disability insurance.