Business Intelligence Analyst
CAA Ontario
Thornhill, ON, CA
9d ago

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.
  • Job Requirements

  • 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

    Apply
    Add to favourites
    Remove from favourites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form