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. Our insurance subsidiaries are rated A+ “Superior” by AM Best company and A “Strong” by Standard & Poor’s. Check out our strong financial track record here.

Position Purpose

Under general management, the Sr. Data Engineer will be responsible for designing, developing, and integrating data pipelines and assets within our enterprise data platform. Your work will ensure data accessibility, reliability, and security to support analytics and reporting across the organization. In this role, you will work with both on-premises and cloud technologies while adhering to best practices in data governance and quality. If you're passionate about data, adaptable to new challenges, and thrive in an agile, fast-paced environment, we’d love to hear from you!

Principal Duties & Responsibilities

• Create, maintain, and optimize data workflows from development to production, ensuring high performance, scalability, and reliability.

• Maintain data availability and ensure compliance with RLI’s security standards and best practices.

• Perform root-cause analysis and resolve issues related to technology, processes, or resources.

• Develop and enforce data integration and data quality practices to maintain consistency across data sources.

• Automate the integration, testing, and deployment of code to support continuous delivery of high-quality solutions.

• Work closely with data architects, product managers, data analysts, and developers in an agile team environment, delivering iterative improvements.

Education & Experience

• Typically requires a Bachelor’s degree in computer science, information systems, business administration, or a related field

• 4+ years of relevant experience

• [OR] equivalent level of education and experience

• Experience in Property & Casualty (P&C) Insurance is preferred

• Not considering visa sponsorship for this role

Knowledge, Skills, & Competencies

• Strong ability to write and optimize complex SQL queries to ensure efficient data processing, integration, and analytics.

• Experience designing, deploying, and managing scalable data infrastructure on Microsoft Azure, including services like Azure Data Lake, Azure SQL Database, and Azure Blob Storage.

• Expertise in automating data workflows using Informatica Data Management Cloud (IDMC) or similar tools for data extraction, transformation, and loading.

• Hands-on experience building and maintaining data warehouses using Snowflake or similar platforms, ensuring optimized data storage and retrieval for analytics.

• In-depth understanding of data integration, quality practices, and ensuring consistency across data sources through well-defined workflows.

• Proficiency in Python or similar languages (e.g., Java, Scala) for developing and optimizing data processing tasks to support scalable data solutions is preferred.

• Experience in designing and implementing data models and schemas that ensure efficient storage, integrity, and accessibility for analytical needs is preferred.

• Familiarity with CI/CD tools