Senior Data Engineer – Snowflake

RLI Insurance Company

. Design, build, and optimize end-to-end data pipelines across ingestion, transformation, modeling, and distribution layers .

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

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and optimizing data pipelines, ensuring data quality and reliability while leveraging AI-assisted tools for enhanced efficiency. Proficient in translating business requirements into scalable technical solutions within cloud-native environments.

Highest-signal resume keywords

Advanced Proficiency In SQLStrong Engineering Capability In PythonHands-On Experience With SnowflakeExperience Building Scalable Data PipelinesStrong Understanding Of Data Modeling

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

Data Pipeline DesignData TransformationData ModelingPerformance TuningSystem OptimizationRoot Cause AnalysisData Quality GovernanceAutomation TechniquesAI-Assisted Development ToolsAPI Integration

Soft Skills

Critical ThinkingEffective CommunicationCollaborationMentoring

Tools & Technologies

GitCloud-Native Data PlatformsAI-Assisted Engineering Tools

Industry Keywords

Property & Casualty InsuranceData ReliabilityData AccessibilitySLA Monitoring

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
Validate, document, and communicate changes to data pipelines and models prior to release
Translate business requirements into scalable and maintainable technical solutions
Contribute to solution design decisions within established enterprise architectural patterns
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
Leverage AI-assisted engineering tools to accelerate development, automate tasks, and improve documentation, with validation of outputs
Partner with team members and stakeholders to address customer needs, deliver measurable business value, and align with product objectives
Collaborate with engineers through design collaboration and code reviews
Operate with autonomy and contribute to the evolution of RLI's data platform
Report to a Data Engineering Manager

Requirements

What you’ll need

Bachelor's degree in computer science, information systems, business administration, or a related field, or equivalent level of education and experience
4+ years of relevant experience
Candidates must be authorized to work in the US without company sponsorship
Advanced proficiency in SQL
Strong engineering capability in Python
Strong experience with Git-based version control, including branching strategies, pull requests, and code review practices
Hands-on experience with Snowflake or a similar cloud-native data platform
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
Comfort with unstructured, semi-structured data, and APIs
Experience in Property & Casualty (P&C) Insurance is preferred
Autonomy while adhering to established engineering standards
Critical thinking to solve complex challenges and anticipate scalability, performance, and integration risks
Ability to improve engineering practices, patterns, and solution quality
Ability to use automation and AI-assisted approaches to improve delivery speed, quality, and decision-making
Ability to communicate technical decisions and tradeoffs clearly
Ability to support and mentor other engineers

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