Sr. Data Engineer - Snowflake (Peoria, IL or Chicago, IL)

RLI is seeking a collaborative and driven Senior Data Engineer to join our Data & Analytics team. Reporting to a Data Engineering Manager, this role is responsible for designing, building, and delivering scalable, end-to-end data solutions-from ingestion through data product creation and distribution., * Ensure changes to data pipelines and models are validated, documented, and communicated 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 closely with team members and stakeholders to ensure solutions address customer needs, deliver measurable business value, and align to product objectives
• Collaborate with other engineers through design collaboration and code reviews, * 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
• Autonomy & Execution: Operates independently while adhering to established engineering standards, driving work forward in complex and evolving environments
• Engineering Judgment: Applies critical thinking to solve complex challenges and anticipates scalability, performance, and integration risks early
• Continuous Improvement Mindset: Identifies opportunities to improve engineering practices, patterns, and overall solution quality
• AI-Augmented Engineering: Uses automation and AI-assisted approaches to improve delivery speed, quality, and decision-making
• Collaboration & Influence: Works effectively across engineering, analytics, and product teams; communicates technical decisions and tradeoffs clearly
• Mentorship & Team Development: Supports and mentors other engineers through hands-on collaboration

• Advanced proficiency in SQL and strong engineering capability in Python
• Strong experience with Git-based version control, including branching strategies, pull requests, and code review practices

We’re not like other insurance companies. From our specialty products to our business model, our culture to our results - we’re different. Different is who we are, and how we work, interact, deliver and succeed together. Creating a different and better insurance experience doesn’t just happen. It takes focus and a shared passion for going beyond the expected to forge relationships and deliver care that makes a difference. This approach rises from and is supported by our talented, ethical and smart team of employee owners united around a single purpose: to work alongside our customers and partners when they need us, in unexpected ways, with exceptional results. Apply today to make a difference with us., RLI encourages its employees to pursue professional development work in insurance and job-related areas. We make a commitment to employees to provide educational opportunities that help them enhance their skills and further their career advancement. RLI fosters a true learning culture and encourages professional growth through insurance courses, in-house training and other educational programs. RLI covers the cost for most programs and employees typically earn a bonus upon successful completion of approved courses and certifications. Our personal and professional growth benefits include