Data Analyst

Brief Description

Arsenault provides industry-leading solutions for insurance brokers, and is hiring a Data Analyst to manage the data conversion process of Property and Casualty policy data for use in our products. As a Arsenault Data Analyst, you will be responsible for analyzing new datasets and creating business rules for transformation into our products. You will also be responsible for ensuring quality control throughout the transformation process.

What You Will Do

• SME for DSP (data share partner) data questions
• Analyze and assess new databases/datasets from data share partners
• Create business rules and functional requirements necessary to set up ETL processes to ingest new datasets, as well as recurring.
• Ensure quality and accuracy of the DSP datasets, this includes:

• Creating business logic and processes to QA new and re-occurring data loads
• Maintain data standards and structure by producing validation and quality assurance reports to ensure data quality and consistency.
• Identify, analyze, and interpret trends or patterns in data sets
• Interpret data and develop recommendations based on findings
• Interface with Arsenault clients and third parties as needed to obtain and interpret data
• Perform other tasks on projects as needed/assigned by management
• Overseeing a Philippine resource that works on QA.
• Handling any ad-hoc requests related to DSP data

• Create business rules and functional requirements necessary to modify existing DSP processes, as well as any new processes proposed by the data team
• Support products that depend on Property and Casualty data.
• Answer and address any related data issues
• Work with developers to support the team
  
  

Factors for Success

• BS/BA in information systems, business, economics or other related discipline, or equivalent combination of education and experience
• Strong technical orientation and experience with MS SQL Server 2014 or higher, PL SQL, relational databases, MS Excel, and DataStage (or similar ETL tools).
• Experience in identifying trends and patterns.
• Familiarity with property and casualty insurance data and general knowledge of insurance industry preferred.
• Experience in data mining techniques and procedures and ability to apply these techniques appropriately.
• Ability to present complex information in an understandable and compelling manner.
• Ability to create functional specifications.
• Experience working with BI tools (domo, micro strategy, etc.)
  
  

Company Background

Why pick Arsenault? Arsenault is a cutting edge, web-based SaaS company that has revolutionized the insurance industry by helping independent agencies leverage technology solutions to grow their business in employee benefits and property and casualty markets.