Designs, builds, and optimizes scalable end-to-end data pipelines and curated data products using Snowflake, SQL, and Python. Translates business needs into reliable technical solutions, ensuring data quality, governance, performance, and cost efficiency. Troubleshoots complex issues, contributes to architectural decisions, uses AI-assisted engineering tools, and collaborates with engineering, analytics, product, and business stakeholders. The role also includes code reviews, documentation, mentoring, and influencing data engineering best practices.
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 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.
You will partner with team members and business stakeholders to understand customer needs and translate them into high-value solutions aligned to product objectives, delivering work iteratively and refining solutions based on feedback and evolving requirements. Operating with a high degree of autonomy, 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 solutions, influence best practices, and contribute to the evolution of our data platform.
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
Education & Experience
Knowledge, Skills, & Competencies
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.
You will partner with team members and business stakeholders to understand customer needs and translate them into high-value solutions aligned to product objectives, delivering work iteratively and refining solutions based on feedback and evolving requirements. Operating with a high degree of autonomy, 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 solutions, influence best practices, and contribute to the evolution of our data platform.
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!
- Not Considering Visa Sponsorship for this position.
- Candidates must be authorized to work in the US without company sponsorship. The company will not support the STEM OPT Training Plan endorsement for this position.
Principal Duties & Responsibilities
- Design, build, and optimize end-to-end data pipelines across ingestion, transformation, modeling, and distribution layers
- 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
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
- 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
- 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
- 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
- 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
RLI Insurance Company Chicago, Illinois, USA Office
Chicago, United States
Similar Jobs
Insurance
Data Engineer will develop and support data warehouse projects, analyze data integrations, work with ETL tools, and improve processes while collaborating with team members.
Top Skills:
AdfInformaticaSQLSQL ServerSsisSynapse
Food • Retail • Agriculture • Manufacturing
Leads McCain’s North American campus recruiting and early careers strategy, including internships, co-ops, rotational programs, and entry-level hiring. Builds university and stakeholder partnerships, oversees recruiting operations, metrics, budgets, candidate experience, and talent conversion. Manages and develops a team of campus recruiting professionals while strengthening employer branding and program effectiveness.
Top Skills:
Ai-Enabled Recruiting ToolsApplicant Tracking Systems (Ats)Candidate Relationship Management (Crm) PlatformsExcelMicrosoft Powerpoint
Machine Learning • Payments • Security • Software • Financial Services
Provides enterprise technology support through phone, ticketing, and potentially chat channels. Troubleshoots hardware, software, network, access, and application issues; manages incidents and escalations; documents resolutions in ServiceNow or similar ITSM tools; analyzes trends and operations data; supports knowledge management, training, process improvement, and automation; and coaches junior analysts while maintaining customer service, security, and confidentiality standards.
Top Skills:
Call Center TechnologiesHardware InfrastructureItsmNetworkingServicenow
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
