Insurance Data Analyst: SQL & Duck Creek Expert

Jobtailor; Illinois; On-site; USD 70,000 - 110,000; Full time

Job summary

Jobtailor is seeking a Business Analyst to elicit and document requirements across the insurance domain. You will translate needs into functional specs, source-to-target mappings, and user stories for data and reporting solutions.

You will profile and analyze data using SQL, map Duck Creek XML to Insights staging tables, and collaborate with developers and data engineers to ensure solutions meet requirements. Strong communication and P&C insurance experience are essential.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or similar technology-related field with 2+ years of related experience.
• In lieu of a bachelor’s degree and 2 years of experience, we will consider a candidate with 7+ years of related experience.
• Demonstrated experience as a Business Analyst, with proven requirements-gathering and process-analysis skills.
• Hands-on knowledge of the Duck Creek Policy platform.
• Knowledgeable in Extract Mapper tool from Duck Creek.
• Working knowledge of the Duck Creek Insights data warehouse.
• Significant experience in the P&C insurance industry.
• Proficiency in writing SQL queries for data analysis and validation.
• Excellent oral and written communication skills.
• Must be authorized to work in the United States and must not require, now or in the future, VISA sponsorship for employment purposes.

Responsibilities

• Elicit, analyze, and document business and data requirements from stakeholders across the insurance organization.
• Translate business needs into clear functional specifications, source-to-target mappings, and user stories for data and reporting solutions.
• Profile, validate, and analyze data by writing SQL queries against source systems and the Insights warehouse.
• Interpret Duck Creek policy XML data structures and map these to Insights staging tables and columns.
• Partner with developers and data engineers to ensure delivered solutions meet documented requirements.
• Facilitate stakeholder meetings, present findings, and produce documentation tailored to technical and non-technical audiences.
• Support data quality, governance, and reporting initiatives within the Data Management organization.
• Assist support team in analysis of data issues.
• Perform other duties as needed.

Skills

Requirements gathering

Process analysis

SQL queries

Stakeholder communication

Data quality

Documentation

Data analysis

Education

Bachelor’s degree in Computer Science/Information Systems

Tools

Duck Creek Policy platform

Extract Mapper

Duck Creek Insights data warehouse

Job description

Jobtailor is seeking a Business Analyst to elicit and document requirements across the insurance domain. You will translate needs into functional specs, source-to-target mappings, and user stories for data and reporting solutions.

You will profile and analyze data using SQL, map Duck Creek XML to Insights staging tables, and collaborate with developers and data engineers to ensure solutions meet requirements. Strong communication and P&C insurance experience are essential.