Business Intelligence Analyst
Date: Feb 28, 2023
Location: Winnipeg, MB, CA, R3G 3H7
Company: CAA Club Group
About Us
As our Business Intelligence Analyst at CAA Club Group of companies, 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. Our Business Intelligence team get to be the “hero” to our internal customers by providing the data necessary to make stronger business decisions.
Who we are
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. CAA Club Group (CCG) is known for providing stellar emergency roadside assistance to our motoring Members and non-Members. We work hard and play hard. We're about doing what's right and feeling good about it.
Position Details
Duties/Responsibilities
Create comprehensive and automated BI & Reporting solutions, while focusing on the front-end interface in Power BI
Participate in the stakeholder requirement workshops/meetings and ensure business requirements are adequately captured in SOW
In collaboration with BI Developer, support development of data solutions, including data models, data lifecycle management, data access and reporting elements
Analyze complex data sets from various database servers and systems to identify insights and trends shaping in each LOB, functional area, and CCG enterprise
Translate analysis into self-serve Power BI dashboards, including visuals, slicers, and measures with a focus on storytelling and user experience
In collaboration with BI Developer, create mockup reports for proof-of-concept reviews
Support lines of business in a variety of analytical needs including development of robust analytical plans, statistical analysis, key performance indicators, benchmarking, data visualizations, routine, and ad hoc reporting
Utilize machine learning techniques to proactively identify opportunities for transforming descriptive to predictive analytics
Provide analytics support on key projects/initiatives aligned to business or organizational strategies
Create technical documents for all newly built data/reporting solutions
Support end-user training, testing, documentation, and roll-out of reports
Keep current on emerging tools and techniques and grow knowledge of the business
Maintain confidentiality related to all sensitive data
Review SQL queries, DAX expressions, integration packages and Business Intelligence solutions
Coordinate and assist with the implementation of processes aligned with enterprise frameworks/methodologies for data management and reporting standards and ensure data quality and requirements are developed
Serve as a subject matter expert across Finance and assist users with reporting and analysis activities and tools, including ad hoc reporting
Maintain knowledge of business processes and application design and understand cross-functional business relationships and their use of information
Provide technical guidance, support, and expertise to the team
Recommend training in coordination with the Manager, BI
Complete effort estimation on all new requests
Identify process improvement opportunities to streamline and enhance efficiencies
Develop & maintain standard operating procedures (SOP)
Work in conjunction with other internal teams on collaborative projects, including data analytics initiatives
Collaborate with business and enablement areas to identify new data sources to incorporate into various analysis, as well as innovative analytical/statistical techniques (predictive, simulation, optimization models) that will generate new insights
Support the Finance BI Technical Lead in the development of use cases related to predictive modeling
Our Commitment
Get ready to drive your career 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 are caring. We are leaders. We are innovators. We are collaborative. We work hard and play hard. We're about doing what's right and feeling good about it.
We are an equal opportunity employer and are committed to providing employment accommodation in accordance with the Manitoba Human Rights Code and the Accessibility for Manitobans with Disabilities Act, 2013 (AMA). CAA 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.
As an organization we are focused on Member safety, which includes the safety and well-being of our Associates. Therefore, you must be and remain fully vaccinated as a condition of employment.