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.