Data Analyst - Remote

Arsenault; Houston (TX); Remote; USD 60,000 - 80,000; Full time

Job summary

A leading SaaS company in Texas is seeking a Data Analyst to manage the data conversion process of Property and Casualty policy data. The role requires analyzing datasets, ensuring data quality, and creating business rules for efficient ETL processes. Candidates should have a BS/BA in relevant fields and strong experience with SQL, DataStage, and data analysis. This position is crucial for enhancing data-driven solutions in the insurance industry.

Qualifications

• Strong technical orientation is critical for managing databases.
• Experience with relational databases is necessary.
• Ability to present complex information clearly.

Responsibilities

• Analyze and assess new datasets from partners.
• Create business rules for ETL processes.
• Ensure quality and accuracy of datasets.
• Interface with clients to interpret data.
• Support property and casualty data-related products.

Skills

Data analysis

SQL

Data quality assurance

Trend identification

Presentation skills

Education

BS/BA in information systems, business, or related discipline

Tools

MS SQL Server

DataStage

MS Excel

BI tools (Domo, Microstrategy)

Job description

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

• 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.