Business Analytics Specialist

Location: Vancouver, British Columbia, Canada
Date Posted: 06-02-2019
Business Analytics Specialist

Reporting directly to the Manager Rating and Reporting, the Business Analytics Specialist will work closely with other team members to provide analysis, create reports and present actionable business insights to drive growth and profit.  Your daily activities will include identifying trends, analyzing loss data, and maintaining BI data assets.


Who We Are

Family Insurance provides personal property and auto insurance protection for British Columbians and is a managing general agent for Economical Insurance. Founded in 1871, Economical Insurance is one of the largest insurance companies in Canada and is 100% Canadian owned. 

Our mission is to be the insurance partner Canadians choose to protect what they value most. We strive to be a provider of choice for auto and home insurance and an employer of choice in our industry.

Why You’ll Like It Here

  • An incredible team of smart, collaborative, and supportive people to work with
  • Great benefits, including tuition reimbursement, RRSP matching and fitness subsidies
  • We are a company that values community, wellness and work-life balance.  We offer personal leave, paid volunteer days and additional paid time off throughout the year

Specific Responsibilities
  • Translate general business questions into analytic requirements and deliver meaningful insights and recommendations to solve business problems
  • Perform complex data queries to transform operational data into insightful business metrics for internal customers
  • Develop and analyze financial assumptions used in the insurance rating processes by using various insurance and mathematical concepts (e.g., regression analysis)
  • Maintain rating tables in the Point of Sale (POS) database and in all other database environments (e.g. MIS, development, and quality assurance)
  • Provide rating analysis support for all system projects involving changes to Family's proprietary rating engine, its business rules, and/or data tables, as well as supporting the programming, testing and implementation of Family's strategic rating
  • Maintain BI assets and corporate performance reporting
  • Work directly with data, from initial extraction through preliminary analysis to results validation
  • Analytical projects will range from proactive, complex, longer term deliverables to very short-fused, reactive, quick-and-dirty insights we can provide “just-in-time” in order to impact a decision that will be made immediately

  • Strong statistical analysis skills, including the ability to communicate somewhat complex quantitative analysis in layman’s terms, and tell succinct, impactful stories to senior management without overwhelming them with data and details
  • Comfortable with ambiguous requests from management, and able to effectively turn them into detailed work plans and contracted deliverables that meet customers’ needs
  • Excellent analytical and problem solving skills, including the ability to identify the appropriate metrics to measure performance.
  • Ability to take initiative, set deadlines and manage projects to a timely and successful conclusion.
  • Perform well in a busy operation and remain calm under pressure.
  • Adaptable and able to manage change in a fast paced and fluid environment
  • Team player who is professional, friendly and courteous in all interactions, whether with customers or co-workers.
  • See the Big Picture—you want to understand the business problem you are trying to address and the data needed before you begin to build a report or dashboard.

  • Bachelor's degree in a related field (i.e. Statistics, Actuarial, Risk Management or Mathematics).
  • Minimum 3 years working experience in a similar role ideally within the Property & Casualty insurance or similar industry.
  • Proficiency with relational database concepts and SQL.
  • Experience with data visualization tools (i.e. SSRS, Tableau).
  • Expertise using MS Word, MS Excel, particularly data modeling and spreadsheet analysis skills.
  • Familiar with BI concepts, including data warehouse, OLAP, SSIS
Qualified candidates are asked to please submit a cover letter outlining your suitability for this opportunity and a copy of your resume.

Family’s office is located in the picturesque Coal Harbour area of downtown Vancouver, close to the seawall, Stanley Park, and public transit. The company offers a supportive and collaborative work culture with great employee perks.

We would like to thank all candidates for showing interest in this role and our company; however only those selected for further consideration will be contacted.

this job portal is powered by CATS