Business Intelligence Analyst
CAA Manitoba
Winnipeg, Manitoba, Canada
8d ago

Description

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.

About Us

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.

About You

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

    Benefits

    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

    Apply
    Add to favourites
    Remove from favorites
    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