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

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 Workcompany 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 PurposeRLI 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 & ResponsibilitiesDesign, build, and optimize end-to-end data pipelines across ingestion, transformation, modeling, and distribution layersEnsure changes to data pipelines and models are validated, documented, and communicated prior to releaseTranslate business requirements into scalable and maintainable technical solutionsContribute to solution design decisions within established enterprise architectural patternsEnsure data reliability, quality, and accessibility across systems and data products, including monitoring SLAs where appropriateTroubleshoot and resolve complex data and system issues, including root cause analysisOptimize performance, scalability, and cost efficiency of pipelines and data productsLeverage 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 objectivesCollaborate with other engineers through design collaboration and code reviewsEducation & ExperienceTypically requires a Bachelor’s degree in computer science, information systems, business administration, or a related field4+ years of relevant experience[OR] equivalent level of education and experienceExperience in Property & Casualty (P&C) Insurance is preferredNot considering visa sponsorship for this roleKnowledge, Skills, & CompetenciesAdvanced proficiency in SQL and strong engineering capability in PythonStrong experience with Git-based version control, including branching strategies, pull requests, and code review practicesHands-on experience with Snowflake or a similar cloud-native data platformStrong understanding of data modeling, data quality, and governance practicesExperience building and optimizing scalable, reliable data pipelines and curated data productsExperience with performance tuning, system optimization, and troubleshootingFamiliarity with AI-assisted development tools and integrating AI-enabled components where appropriateAbility to translate business problems into data solutionsComfortable with unstructured, semi-structured data, and APIsAutonomy & Execution: Operates independently while adhering to established engineering standards, driving work forward in complex and evolving environmentsEngineering Judgment: Applies critical thinking to solve complex challenges and anticipates scalability, performance, and integration risks earlyContinuous Improvement Mindset: Identifies opportunities to improve engineering practices, patterns, and overall solution qualityAI-Augmented Engineering: Uses automation and AI-assisted approaches to improve delivery speed, quality, and decision-makingCollaboration & Influence: Works effectively across engineering, analytics, and product teams; communicates technical decisions and tradeoffs clearlyMentorship & Team Development: Supports and mentors other engineers through hands-on collaborationCompensation OverviewThe base salary range for the position is listed below. Please note that the base salary is only one component of our robust total rewards package at RLI. The salary offered will take into account a number of factors including, but not limited to, geographic location, experience, scope & responsibilities of the role, qualifications/credentials, talent availability & specialization, as well as business needs. The below range may be modified in the future. Base Pay Range$96,264.00 - $137,657.00Total RewardsAt RLI, we're all owners. We hire the best and the brightest employees and allow them to share in the company's success through our Total Rewards. With the Employee Stock Ownership plan at its core, the Total Rewards program includes all compensation, benefits and perks that come with being an RLI employee.Financial IncentivesAnnual bonus plansEmployee stock ownership plan (ESOP)401(k) — automatic 3% company contributionAnnual 401k and ESOP profit-sharing contributions (Up to 15% of eligible earnings)Work & LifePaid time off (PTO) and holidaysPaid volunteer time off (VTO) to support our communitiesParental and family care leaveFlexible & hybrid work arrangementsFitness center discounts and free virtual fitness platformEmployee assistance programHealth & WellnessComprehensive medical, dental and vision benefitsFlexible spending and health savings accounts2x base salary for group life and AD&D insuranceVoluntary life, critical illness, & accident insurance for purchaseShort-term and long-term disability benefitsPersonal & Professional GrowthRLI 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:Training & certification opportunitiesTuition reimbursementEducation bonusesDiversity & InclusionOur goal is to attract, develop and retain the best employee talent from diverse backgrounds while promoting an environment where all viewpoints are valued and individuals feel respected, are treated fairly, and have an opportunity to excel in their chosen careers. We actively support, and participate in, initiatives led by the American Property Casualty Insurance Association that aim to increase diversity in the insurance industry. Cultivating an exceptional and diverse workforce to deliver excellent customer service reinforces our culture and is a key to achieving superior business results.RLI is an equal opportunity employer and does not discriminate in hiring or employment on the basis of race, color, religion, national origin, citizenship, gender, marital status, sexual orientation, age, disability, veteran status, or any other characteristic protected by federal, state, or local law.SummaryLocation: Peoria, IL; Chicago, ILType: Full time