Business Analytics/ Business Intelligence Specialist

**Job Type **Regular Full-Time
**Remote Type **Hybrid
**Location **Vancouver, Canada
**Posting Range **$55,800 - $102,800

**Love 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.

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

**Pay range for this role is $55,800 - $102,800**

**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