Business Intelligence Analyst
Western Financial Group
Okotoks, AB
For 100 years Western Financial Group, a Canadian insurance brokerage has listened to and cared for over 1,000,000 customers. A career at Western will challenge you while offering opportunities for continuous development.


Use your technical and analytical expertise to support strategic business decisions.

Reporting to the Manager, Business Intelligence and working closely with a small team of a Business Intelligence Analyst, Data Scientist and an Application Developer, you will be responsible for providing and delivering information and support strategic business decisions. You will also work in multiple data sources and data models to develop advanced reporting and business intelligence analytics.


Write complex SQL queries to extract and integrate data from multiple database sources (structured and unstructured data)
Develop clear and concise data visualizations and written interpretations for communication of results to Senior Leadership
Create and develop reports that help support the analysis of business trends for the business units
Design and develop dashboard and reporting solutions to enable management to analyze information and improve decision making
Supports, maintains and improves automated collection and analysis capabilities
Consulting directly with business user and decision-makers to gather requirements and define scope of information needed
Perform large-scale data analysis, respond to ad hoc questions and share analysis results for feedback

Our Team Environment

We work together every day to build authentic relationships with our internal clients and with each other. We enjoy a fast-paced, multi-faceted, and highly collaborative team environment. We value strong math, business, analytical and critical thinking skills that lead to professional communication and accurate analysis of the business.

Bachelor’s degree in Computer Science, Business, Information Management or equivalent
5+ years of work or combined with business intelligence, data mining, and designing analysis
Strong background in all aspects of database technology
Expertise creating dashboards and insightful reports using Cognos Analytics , as well as other reporting tools
MS Office; with an emphasis on Excel – Good use of formatting, formulas, Pivot tables and charts
Insurance industry experience is an asset but not required

Hours: Full-time/37.5 hours/week

Location: High River, AB

Requisition #: 56517

Western provides our employees with a competitive compensation package. Full time: 3 weeks’ vacation plus paid personal days, Company Matched investment and saving programs, extended health and dental benefits, including a Health Care Spending Account, 50% premium paid.

Western Financial Group has its own charitable foundation, check it out here, Western Communities Foundation .