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.
We work hard and play hard. We're about doing what's right, and feeling good about it
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
Experience with BI tools such as PowerBi, QlikView and Tableau
Experience with SQL Server 2008 / 2012, SSRS, SSIS
Experience working with SAP BI / BW, Bex Queries
Proven expertise on data warehouse projects
Knowledge of conceptual and physical data models.
Experience with Microsoft Office Suite (Excel, Access, Visio, PowerPoint)
Please note : Internal applicants are asked to formally express their interest by applying online no later than 10 business days of position being posted.
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