Data Analyst – Duck Creek Technologies (Policy, Claims, Billing & Clarity)

Senior Data Analyst – Duck Creek Technologies (Policy, Claims, Billing & Clarity)

Location: USA – Remote (Work in Pacific Time)
Duration:- 6-12 Months+
Industry: Property & Casualty Insurance

Role Overview

We are seeking an experienced Senior Data Analyst with deep domain expertise across the core Duck Creek Suite (Policy, Claims, and Billing) and Duck Creek Clarity. In this role, you will bridge the gap between core insurance processing systems and downstream enterprise analytics, designing robust data models, building reporting frameworks, and unlocking critical business insights across underwriting, policy administration, billing operations, and claims management.

Key Responsibilities

Duck Creek Data Modeling & Extraction: Design, develop, and optimize data models utilizing the Duck Creek Suite (Policy, Billing, Claims) schema and Duck Creek Clarity data stores (Operational Data Store and Analytical Data Store).

Clarity Pipelines & Analytics: Leverage Duck Creek Clarity to ingest, transform, and expose operational and transactional data for business intelligence, statutory reporting, and executive dashboards.

Cross-Functional Analytics: Partner with Underwriting, Actuarial, Claims, and Finance stakeholders to translate complex business requirements into clear analytical definitions, KPIs, and visualizations.

Data Quality & Reconciliation: Establish automated data quality frameworks and reconciliation pipelines between Duck Creek source applications (Transact/Server), Clarity data layers, and target enterprise data warehouses.

SQL & Pipeline Optimization: Author high-performance SQL queries, views, and ETL/ELT procedures to support high-volume, low-latency reporting environments.

Documentation & Governance: Maintain comprehensive data dictionaries, data lineage documentation, and governance standards for all Duck Creek entities and attributes.

Qualifications & Experience

Core Experience: 5+ years of data analysis experience in the Property & Casualty (P&C) insurance industry.

Duck Creek Mastery: Direct, hands-on experience working with data structures across Duck Creek Policy, Duck Creek Claims, and Duck Creek Billing.

Clarity Expertise: In-depth knowledge of Duck Creek Clarity architecture, data mapping, out-of-the-box feeds, and schema customization.

Technical Skills:

Advanced SQL proficiency (window functions, stored procedures, complex joins, and query optimization).

Hands-on experience with modern cloud data platforms (e.g., Snowflake, BigQuery, AWS Redshift, or Azure Synapse).

Proficiency with BI/visualization tools (Power BI, Tableau, or Looker).

Familiarity with XML/JSON payloads used in Duck Creek integrations.

Insurance Domain Knowledge: Solid understanding of core P&C metrics, including written/earned premium, loss ratios, loss development, combined ratio, reserve changes, and billing collection cycles.

Communication: Proven ability to present complex technical and analytical concepts clearly to non-technical business leaders and technical engineering teams.

Preferred Qualifications

Prior experience migrating legacy reporting systems to Duck Creek Clarity.

Familiarity with Duck Creek Insights or integration with cloud-native ETL tools (e.g., dbt, Azure Data Factory).

Professional certifications in Duck Creek Technologies or insurance data frameworks.

Back to blog

Other Jobs To Apply

Scaled Account Management Lead

Remote Motion Designer: Brand Storytelling & Campaigns

Remote RN Care Manager - Texas (Telephonic) Job at Molina Healthcare in Austin

Analyst, Trading Operations - Overnight Hours

Solutions Consultant, Post Sales, Strategic

Senior Commercial Pricing & Profitability Advisor

Director, Payment Integrity (Pre-Pay Edits) - REMOTE

Remote Revenue Enablement Leader (GTM)

Principal Implementation Specialist

Practice Engagement Manager

100% Remote Security Consultant with Cloudflare Zero Trust / Cloudflare Access / ZTNA

Manager, Global Process Lead, Finance (remote)

Manager, Life Underwriting (Remote)

Regional Marketing Manager, Southeast

Associate Sr. Counsel, Claim - Remote

Client Support Specialist - Greater Portland, OR Area (REMOTE)

Package Project Lead 3

VIP Account Manager, Pennsylvania

Staff Researcher, Payment Experiences & Pricing

Clinical Applications Specialist - Patient Monitoring - Chicago

FULLY REMOTE - Bankruptcy Attorney - Chapters 7, 11 & 13

Global Commercial Partner Practice Development & Activation Lead

Sr. Solutions Architect - Strategic Central/East (Presales)

Manager, Configuration Management Analyst - Configuration Control Board Administrator (Remote)

Senior Solutions Engineer - Federal Civilian

Customer Success Manager II, Federal Government Strategic Accounts (Remote Eligible)

Banking Risk Mitigation Lead, Cash App

Social Media Manager, Growth Marketing

Sr. MicroStrategy Developer | Remote

Senior Manager, Total Video Media

Lead Product Designer (Design System Specialist)

Senior Manager, Trust and Safety Operations (Americas)

Lead, HRIS

Director - Americas Life Sciences Vertical at Siemens: 100% Remote (GA, ON, Canada)

Patient Access Representative - Remote

Remote Scheduling Coordinator | Entry Level

Farm Operations Manager (Remote Support)

Remote Chat Support Assistant – No Phone Calls – Flexible Home‑Based Role with reputed company – Customer Service Excellence & Growth Opportunities

[Remote] IT Project Coordinator, Healthcare - Remote

Computational Bioscience Expert (Python), Remote- Contract

Data Scientist/Engineer - Junior (Remote)

Recruiter - Search Consultant - Headhunter - REMOTE

Remote Medical Billing/Coding Specialist

Manager, Enterprise Sales - SDR Team (Remote, US)

Physicians - Accounts Receivable Associate Specialist

Remote Recruiter

Research Assistant: Remote-First Growth & Impact

Remote Claims Representative - 630669D

Salesforce Sales Executive - Healthcare (Remote role)

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...