Business Analyst, Actuarial

  • 36208
  • Life - Actuarial
  • |
  • Ontario, Canada
  • |
  • Nov 11, 2019
Insurance
RESPONSIBILITIES
  • Plan and coordinate the quarterly and annual bulk issuance of all Experience Rating programs. Incorporate any program change and testing, as required, to ensure that the information provided is accurate and statements are issued in a timely manner.
  • Balance Cost Information System on a daily, weekly, monthly and annual basis to ensure that the information provided on the Accident Cost statements is accurate and statements are issued in a timely manner.
  • Identify, develop and test changes/enhancements to experience rating systems in response to directives, changes in legislation and policy, changes or enhancements to feeder systems and continuous incentive improvement initiatives. This includes identifying and defining business requirements, developing project plan, testing and implementing plan, creating and maintaining problem logs.
  • Create/update training or procedure documentation and communicating change to the appropriate individuals.
  • Conduct a post-implementation review to ensure overall success of the change.
  • Provide specialized professional expert advice relating to experience rating plans/processes to company management and staff by: educating on the electronic file transfer process, conducting data profiling of existing data and source-to-target mapping, such as Quality Profile Report to ensure data integrity and quality of experience rating plans.
  • Provide business support, advice and knowledge on data and data sources in response to data requests by management, other business areas within the company and/or external clients.
  • Compiling and transforming diverse data into appropriate form for interpreting and synthesizing in order to draw conclusions.
  • Creating data request statistical reports to assist management in the decision-making process.
  • Creating, developing and producing comprehensive ad hoc and regular reports as well as data extractions including selecting the most appropriate data source.
  • Executing data requests by creating data requirements, writing programs/queries from multiple data sources, building data sets, validating data, analyzing, designing, building and enhancing reports.
  • Providing basic explanations of data findings, analysis and statistical methodologies and measurements.
  • Act as the subject matter expert on the business rules, processes and systems of the Actuarial Services Division to ensure business needs are being met.
  • Providing problem resolution and system maintenance by investigating issues, determining problem scope and providing solutions.
  • Directing Information Technology Cluster on where and how to correct problems within various job streams.
  • Creating and managing changes via the change control process.
  • Providing input to management on business processes, outlining needs, solutions, benefits, impacts, alternatives and options for new business processes, improvements, fixes or enhancements.
  • Acting as a security administrator for the Actuarial Services Division.
  • Assist the Senior Business Analyst with: client education and end user support on related data-marts by identifying training needs, participating in developing and delivering training/information sessions to increase client awareness and understanding of company data and data extraction mining tools, predictive modeling by compiling data, ensuring data validity and accuracy in order to understand the overall performance of the business to support decision making.
  • Develop and maintain Experience Rating Access databases to support Experience Rating & Cost Allocation business activities and transactions for statistical reporting purposes.
  • Perform other related duties as required or assigned.
QUALIFICATIONS
  • University completion at undergraduate level with a specialty focus on mathematics, statistics, computer science or social science.
  • Two years’ prior experience in business analytics.