Data Analyst and Software Support

Family Insurance Solutions

  • Vancouver, BC
  • 58.100-106.900 $ par an
  • Permanent
  • Temps-plein
  • Il y a 22 jours
Job Type Regular Full-Time
Remote Type Hybrid
Location Vancouver, Canada
Posting Range $58,100 - $106,900Love 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?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 the creation of the bank file and the creation and merging of the customer and payment transaction files.
  • 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
  • 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
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: .

Family Insurance Solutions