Job Type Regular Full-Time
Remote Type Hybrid
Location Vancouver, Canada
Posting Range $58,100 - $106,900
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.
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 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 and Business Intelligence, the incumbent is responsible for the accuracy and integrity of the Company's proprietary data.
Responsibilities

• Triage and analyze data issues reported from Family's business units in a timely and appropriate manner
• Resolve data issues by creating SQL scripts that may be tested in a support environment and executed against the production environment
• Engage Development and QA team members as required to assist in production issues.
• Create, maintain and review database diagnostics, resolving and documenting identified data errors
• Provide regular proactive analysis of Family's production databases to ensure data integrity
• Initiate change requests for data fixes for promotion to the production system
• Develop and maintain data structure knowledge in order to perform functions of role effectively and efficiently, including maintenance of the central repository of metadata (data dictionary)
• Ensure continuity across the Data Management Team (DMT) by scheduling and chairing quarterly meetings. Distribute minutes at the completion of each meeting.
• Mentor and train DMT members.
• Document the DMT processes and procedures
• Ensure audit requirements with regards to data maintenance are strictly adhered to by all members of the DMT and notify management of any deviation to audit requirements Provide advice, assistance and quantitative analysis (decision making support) to the Business Support Services team.
• Participate in the test preparation and execution of project specific data changes as requested.
• Analyze and prepare broker/branch transfer scripts when requested by Marketing. Co-ordinate execution of the scripts with TSG and MIS teams.
• Support the Company's EFT process through designing, developing and maintaining automated scripts to identify, troubleshoot and resolve issues related to Electronic Funds Transfer (EFT) processes.
• Execute test cases using manual testing.
• Maintain and update automation processes
• Manage defects through the defect workflow

What you bring to the role?
Experience & Educational Qualifications

• Typically holds a technical or college diploma in Information Systems, Computer Science, or some other related area of study or equivalent in experience.
• Must be proficient with MS Office Suite
• Minimum of 2 years' experience working with Structure Query Language (SQL), preferably with SQL Server
• Experience with Power Automate, UIPath or equivalent automation tool
• Previous experience in the Financial Services or Insurance industry is an asset
• Basic accounting knowledge
• Prior experience with PowerDesigner would be an asset
• Ability to analyze and solve complex problems
• Desire for quality and attention to detail
• Excellent documentation skills
• Excellent operational and organizational skills
• Strong interpersonal skills
• Ability to communicate with both technical and non-technical people
• Ability to work as part of a team
• Ability to work under pressure and within timelines

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?

• 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, and 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 as a single 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: [email protected].