Business Analytics/ Business Intelligence Specialist – Family Insurance Solutions

Title of the Job: Business Analytics/ Business Intelligence Specialist

Location: Vancouver, BC

Job Description: Job Type Regular Full-Time
Remote Type Hybrid
Location Vancouver, Canada
Posting Range $55,800 – $102,800Love What You Do
Family is part of Definity, a Canadian, multi-channel, property, and casualty insurance company whose success is founded on our family of companies’ long history of delivering a superior experience for those who count on us. We’re proud to help our customers, broker partners, employees, and communities adapt and thrive in a world of constant change. Our success in transforming into a digital leader in our industry is driven by a talented and engaged team with a passion for innovation and high performance.To us, a seamless user experience is as important as the people behind it. That’s why we hire the most service-oriented individuals in BC and empower them with the tools they need to wow both our broker network and their clients. If a vibrant atmosphere with great people and an ambitious culture sounds like your kind of fit, apply to join us today.Our ambition is to be one of Canada’s leading and most innovative P&C insurers. Come be a part of our journey, and love what you do.Family offers a flexible, hybrid work experience where employees work from the office and virtually depending on the type of work they are doing and who they are working with. Bring your true self and be a part of our journey. It’s better here.What can you expect in this role?
Reporting directly to the Director, Data Management, Analytics & Business Intelligence, the Business Analytics/ Intelligence 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.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 all other database environments, e.g., MIS, Development, and Quality Assurance. Follow audit procedures to apply rigorous testing and deploy rates implementation in collaboration with the pricing actuary team.
• 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, long-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.

What you bring to the role?
Experience & Educational Qualifications

• 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 validation and large dataset testing techniques.
• Experience with data visualization tools (i.e. SSRS, Tableau).
• Expertise using MS Word, and MS Excel, particularly data modeling and spreadsheet analysis skills.
• Familiar with BI concepts, including data warehouse, OLAP, SSIS
• 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.

Actual salary for the role may vary depending on the work location of the successful candidate and other factors including but not limited to, skills, education, experience, working conditions and the local labour market. In addition to base pay, eligible employees may participate in various incentive plans which are paid out at the company’s discretion and subject to individual and company performance.We also take potential into consideration. If you don’t have this exact experience, but you know you have what it takes, be sure to give us more insight through your application and cover letter.What’s in it for you?

• Hybrid work schedule for most roles
• Company share ownership program
• Retirement savings program with company-matched RRSP contributions
• Generous time away, including vacation, personal leave, and birthday leave.
• Paid volunteer days and company matching on charitable donations.
• Competitive salary and benefits, including educational resources, tuition assistance, and paid time off to study for exams.
• Focus on inclusion with employee groups, access to BIPOC counsellors, access to programs for working parents.
• Wellness and recognition programs
• Discounts on products and services

You must be legally entitled to work in Canada. Qualified candidates are asked to please submit a cover letter outlining their suitability for this opportunity and a copy of their resume in one document.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.Our inclusive work environment welcomes diversity and supports accessibility. If you require accommodation at any time during the recruitment process, please let us know by contacting:

Company Name: Family Insurance Solutions

Salary: $55800 – 102800 per year

Apply for the job!