About Our Business Intelligence Analyst Role
As our Business Intelligence Analyst, you will extract and analyze sales and operational data that show market trends, sales performance, operational and promotional performance for existing services, and assess new business opportunities.
Minus the red capes and tights, our Business Intelligence team get to be the hero to our internal customers by providing the data necessary to make stronger business decisions.
At the heart of our business is our desire to provide our Members with peace of mind and quality service through our roadside assistance, automotive, insurance, travel and rewards businesses.
We continuously strive to enhance our value to Members and Associates and ensure we are socially responsible.
If you were to witness this team in their natural habitat, you might experience a silent determined concentration which at times can morph into constructive collaboration or raucous laughter.
We work hard but take time to have fun.
If you are curious and explorative by nature, love getting your hands on data and translating it into impactful results, this could be a great opportunity to join our family! To learn more about CAA, visit us online at www.caamanitoba.com.
If you meet our requirements and are interested in exploring a career with us, please submit your application at the earliest.
Thank you to all who apply but only candidates considered for an interview will be contacted.
In this role, you will be working on things like :
Meet with lines of business units and understand their needs and gather solution requirements
Develop reports, dashboards and KPIs
Design, develop and publish fully automated reporting solutions
Provide Ad-hoc analysis, reporting, and presentation materials to support the decision making of executives.
Provide solutions support - Investigate reporting / data anomalies within the figures
Provide analytical support for various initiatives to lines’ of business.
Work with the business units to identify opportunities to standardize and streamline the flow of data and reports. Find opportunities within their processes
Design and develop ETL processes using SQL Server Integration Services. Automate data loads and extracts. Perform manual loads where automation is not possible.
Design and develop normalized relational databases utilizing best practices methodologies to minimize resources consumption
Monitor LOB changes and perform report updates as needed
Apply data management best practices and ensure data accuracy and completeness
Monitor and tune database for optimum performance. Manage database objects to ensure resource consumption does not exceed available limits
Manage security rights to ensure that users have the right to access to the right information
Regularly monitor industry best practices and determine if they can be applied within our infrastructure.
Post-secondary education completion, coupled with 2 years of analytical experience
Strong analytical and conceptual skills; ability to create original concepts / theories for a variety of stakeholders.
Strong problem solving, mathematical and analytical skills including data validation skills
Excellent communication skills, proven ability to discuss BI solutions at the appropriate level of detail with all levels of the organization
Ability to adjust to changing priorities and participation in multiple projects
Knowledge of conceptual and physical data models.
Experience with Microsoft Office Suite (Excel, Access, Visio, PowerPoint)
Candidates with some or all these skills will be considered to have a competitive edge
Experience with BI tools such as PowerBi, QlikView and Tableau
Experience with SQL Server 2008 / 2012, SSRS, SSIS
Experience working with SAP BI / BW / BPC, Bex Queries
Proven expertise on data warehouse projects
We are an equal opportunity employer and are committed to providing employment accommodations. CAA Club Group 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.
CAA is a progressive organization with a diverse workforce which offers the opportunity for career development and professional growth, competitive salaries, and a fun working environment that values work / life balance