Intermediate Business/Ratabase Analyst

Job description

The Intermediate Business Analyst is responsible for handling needs assessments to align technology with the Commercial Insurance business strategies. You will bring both system knowledge and analytical skills in the implementation of rating and system modifications using the enterprise rating system (Ratabase).

The candidate will manage the planning and the implementation of Rate Changes across all Commercial insurance systems for Commercial Auto and Commercial P&C, and will apply proven communication, and problem-solving skills in this endeavour.

Key Responsibilities:

· 
Development of underwriting rules and rate change logic in Ratabase

· 
Review, analyze, debug, modify and test Ratabase code to fix production incidents

· 
Planning and Implementation Rate changes

· 
Query databases to collect, interpret and analyze data (SAS, SQL, Access)

· 
Write technical documents to describe configuration of applications and operating procedures to liaison with 3rd party web services

· 
Build systems models, specifications, diagrams, and charts

· 
Work closely with the Team Leader, and Business Stakeholders to understand the functional and system requirements.

· 
Translate business issues/challenges and objectives into viable quality technical and user documentation and be able to recommend alternative solutions to customers.

· 
Identify impacts on business processes based on detailed solutions and strategies.

· 
Be able to identify when changes to the policy systems will affect other downstream systems (i.e. Claims, Case Manager, Publishing System etc)

· 
Test all changes prior to implementation to ensure quality and accuracy.

· 
Be able to provide estimates for all projects and tasks assigned.

· 
Follow Agile methodology for all system implementations, including use of JIRA and attending daily scrums.

· 
Identify and recommend process improvements in the department.

· 
Ensure delivery of work meets customer happiness through the use of project management practices including change and release management and retrospective reviews.

Qualifications, Skills and Experience

· 
3-4 years insurance/underwriting experience is an asset

· 
Experience with Agile delivery methods

· 
Experience in being responsible for the design, development, and implementation of software

· 
Ability to effectively prioritize and execute tasks in a fast paced environment

· 
Demonstration of Project Management skills

· 
Superb communication and interpersonal skills

· 
Strong analytical and problem solving skills

· 
Expert knowledge of Microsoft Word, Excel, Visio

· 
Good background in Data Base design in Microsoft SQL and Access

· 
Experience using statistical packages for analyzing data (example: Excel, SAS, Access, Python)

· 
Experience using Visual Basic

· 
Knowledge of industry tools and standard methodologies e.g. SDLC, Agile, use cases, JIRA, Confluence

· 
Solid understanding and knowledge of and experience with reporting packages (Business Objects, databases (SQL, etc), programming (C++, Javascript, ETLs)

· 
Ratabase Programming experience is a huge advantage for this role

· 
Self-motivated with the ability to prioritize, meet timelines and handle changing priorities

· 
College/University Degree or diploma in Systems Analysis and Design, Computer Technologies or related field

Additional Information

Aviva Canada is committed to providing accommodations for people with disabilities during all phases of the hiring process including the application process. If you require an accommodation because of a disability, we will work with you to meet your needs. Applicants need to make their needs known in advance. If you are selected for an interview and require an accommodation, you are encouraged to advise the Talent Acquisition Partner who will consult with you to determine an appropriate accommodation.