About Us 

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 is a Glassdoor Best Places to Work company with a strong, successful background. For decades, our financial track record has been stellar — a testament to our culture and validation of our reputation as an excellent underwriting company.

Position Purpose 
RLI is seeking a collaborative and driven Data Engineer to join our Data & Analytics team. You will be responsible for designing, building, and delivering scalable, end-to-end data solutions—from ingestion through data product creation and distribution to consumers via self-service and other analytic/reporting applications.

You will partner with team members and business stakeholders to understand use cases and key requirements and translate them into high-value solutions, aligned to our strategy, vision and business priorities. You will deliver work iteratively, refining solutions based on feedback and evolving requirements. You will contribute to solution design within established architectural patterns while taking a product-oriented approach—balancing speed and quality to continuously improve business impact.

In this role, you will design and deliver value-driving decision-support solutions, influence best practices, and contribute to the evolution of our data platform.

If you're passionate about data, embrace new challenges and continuous learning, and thrive in an agile, fast-paced environment, we’d love to hear from you!

Principal Duties & Responsibilities

• 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 

Critical Skills 

• 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,