Senior Data Engineer: End-to-End Pipelines & AI Tools

RLI Corp.; Peoria (IL); On-site; USD 96,000 - 138,000; Full time

Benefits offered by this job

Health insurance

401(k) with ESOP

PTO & holidays

Hybrid work arrangements

Life insurance

Job summary

RLI Corp, a leading specialty insurer, is seeking a Senior Data Engineer to design and deliver scalable data solutions across ingestion, transformation, and distribution.

You will partner with analytics and product teams to translate business needs into reliable data products, while embracing AI-assisted tooling to accelerate delivery.

This role requires 4+ years of experience, a strong SQL/Python background, and a collaborative, agile mindset.

Qualifications

• Bachelor’s degree in computer science, information systems, or related field.
• 4+ years of relevant experience in data engineering.
• Experience in Property & Casualty (P&C) Insurance is preferred.

Responsibilities

• Design, build, and optimize end-to-end data pipelines across ingestion, transformation, modeling, and distribution.
• Translate business requirements into scalable technical solutions.
• Ensure data reliability, quality, and accessibility across systems and data products, including monitoring SLAs where appropriate.
• Troubleshoot and resolve complex data and system issues, including root cause analysis.
• Collaborate with other engineers through design collaboration and code reviews.

Skills

SQL

Python

Git version control

Snowflake

Data modeling

Data quality

Governance

Performance optimization

AI-assisted development tools

APIs

Education

Bachelor’s degree in computer science / information systems / related field

Tools

Snowflake

Job description

RLI Corp, a leading specialty insurer, is seeking a Senior Data Engineer to design and deliver scalable data solutions across ingestion, transformation, and distribution.

You will partner with analytics and product teams to translate business needs into reliable data products, while embracing AI-assisted tooling to accelerate delivery.

This role requires 4+ years of experience, a strong SQL/Python background, and a collaborative, agile mindset.