Business Intelligence Specialist Analytics (with Qlik and/or SSIS experience)

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.