Data Analyst - Remote - job 2 of 2

Zywave 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 Zywave 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 Zywave 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.)
  

Why work at Zywave?

Zywave is a cutting-edge SaaS company that has led the digital revolution of the insurance industry over the last 25 years. We continue to make waves by launching new product functionality and integrations to deliver a world-class customer experience. Since 2020, Zywave has acquired seven insurtech companies representing over 1,100 employees globally. With our remote-first environment and core values that encourage employees to grow, belong and transform professionally there are endless opportunities to build new skills and relationships. Why wait to hop aboard the rocket ship? Get onboard now!

#LI-CS1