Senior Data Engineer

RLI Insurance Company

Data Engineer designing scalable data solutions for analytics at RLI. Collaborating with business stakeholders and delivering high-value technical solutions in an agile environment.

Posted 5/9/2026full-timePeoria • Illinois • 🇺🇸 United StatesSenior💰 $96,264 - $137,657 per yearWebsite

Tech Stack

Tools & technologies

CloudPythonSQL

About the role

Key responsibilities & impact

Design, build, and optimize end-to-end data pipelines across ingestion, transformation, modeling, and distribution layers
Partner closely with team members and stakeholders to ensure solutions address customer needs, deliver measurable business value, and align to product objectives
Translate business requirements into scalable and maintainable technical solutions
Contribute to solution design decisions within established enterprise architectural patterns
Leverage AI-assisted engineering tools to accelerate development, automate tasks, and improve documentation (with validation of outputs)
Ensure changes to data pipelines and models are validated, documented, and communicated prior to release
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
Optimize performance, scalability, and cost efficiency of pipelines and data products
Collaborate with other engineers through design collaboration and code reviews

Requirements

What you’ll need

Bachelor’s degree in Data Analytics, Data Engineering, Data Science, or related field
4+ years of relevant experience in data engineering or related disciplines
Advanced proficiency in SQL and strong engineering capability in Python
Hands-on experience with Snowflake or a similar cloud-native data platform
Strong experience with Git-based version control, including branching strategies, pull requests, and code review practices
Strong understanding of data modeling, data quality, and governance practices
Experience building and optimizing scalable, reliable data pipelines, and curated data products
Experience with performance tuning, system optimization, and troubleshooting
Familiarity with AI-assisted development tools and integrating AI-enabled components where appropriate
Ability to translate business problems into data solutions
Comfortable with unstructured, semi-structured data, and APIs
Experience in the insurance or financial services industries is a plus
Experience with Snowflake Intelligence and Row Zero is a plus

Benefits

Comp & perks

Annual bonus plans
Employee stock ownership plan (ESOP)
401(k) — automatic 3% company contribution
Annual 401k and ESOP profit-sharing contributions (Up to 15% of eligible earnings)
Paid time off (PTO) and holidays
Paid volunteer time off (VTO) to support our communities
Parental and family care leave
Flexible & hybrid work arrangements
Fitness center discounts and free virtual fitness platform
Employee assistance program
Comprehensive medical, dental and vision benefits
Flexible spending and health savings accounts
2x base salary for group life and AD&D insurance
Voluntary life, critical illness, & accident insurance for purchase
Short-term and long-term disability benefits
Training & certification opportunities
Tuition reimbursement
Education bonuses

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythondata modelingdata qualitydata governancedata pipelinesperformance tuningsystem optimizationtroubleshootingAI-assisted development tools

Soft Skills

collaborationcommunicationproblem-solvingstakeholder engagementdesign collaborationcode reviewcustomer focusdocumentationroot cause analysisbusiness translation

Certifications

Bachelor’s degree in Data AnalyticsBachelor’s degree in Data EngineeringBachelor’s degree in Data Science