Sr. Data Engineer

Posted 5 Days Ago
Peoria, IL
Mid level
Insurance
The Role
The DataOps Analyst plays a crucial role in enabling data engineers and data analysts by designing, evaluating, and testing data infrastructure configurations. Responsibilities include administration of data lake, monitoring capacity consumption, data classification, lifecycle management, and data governance.
Summary Generated by Built In

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 (e.g., Azure DevOps), and version control systems (e.g., Git) to automate deployments and manage code changes is preferred.
  • Basic knowledge of implementing data governance practices and securing data pipelines in production.
  • Exposure to MongoDB, AWS, API data formats (e.g., XML, JSON), Kafka, and an understanding of AI/ML algorithms is preferred.
  • Proactively seeks out new trends and learning opportunities.
  • Effective communicator who works well with both technical and non-technical team members across distributed teams.
  • Strong ability to troubleshoot, analyze, and resolve complex issues.
  • Comfortable handling changing data sources, tools, and business requirements in a fast paced environment.

Personal & 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:

  • Nationwide employment opportunities
  • Training & certification opportunities
  • Tuition reimbursement
  • Education bonuses

Diversity & 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.Total 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 Incentives

  • Employee stock ownership plan (ESOP)
  • 401(k) — automatic 3% company contribution
  • Annual discretionary 401k and ESOP profit-sharing contribution (up to 15% of base salary)
  • Annual bonus plans

Work & Life

  • 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

Health & Wellness

  • Comprehensive medical, dental and vision benefits
  • Flexible spending and health savings accounts
  • 2x Base Salary for Group Life and AD&D insurance
  • Voluntary life insurance for purchase
  • Critical Illness & Accident insurance
  • Short-term and long-term disability benefits

Top Skills

Business Objects
Informatica
MongoDB
Power BI
Snowflake
Ssrs
The Company
HQ: Peoria, IL
1,129 Employees
Hybrid Workplace
Year Founded: 1965

What We Do

RLI is a U.S.-based specialty insurer that serves niche property, casualty and surety markets. We provide peace of mind to the customers we serve by safeguarding their assets and helping them manage risk. We hire smart, ethical people, make them owners of the business and give them the freedom to succeed. These are the principles that drive our success, and they’re the reasons we have been successful for more than 50 years.

We believe in a different way of doing business and RLI is not what you’d expect from a typical insurance company. Our creative and collaborative workplace is cultivated by employee owners empowered to make good decisions for customers and the business.

We have a reputation for niche expertise, superior service and an entrepreneurial culture. In the industry and among our peers, we’re known for:

The best and brightest people in the industry who build strong relationships and provide outstanding service.

An underwriting focus so we perform well in all market cycles.

Our empowered, creative ownership culture.

A customized approach to developing insurance products to meet very specific needs.

Proven financial strength.

Similar Jobs

West Monroe Logo West Monroe

Senior Data Engineer, DataBricks (US)

Cloud • Professional Services • Security • Analytics • Consulting • Utilities • Renewable Energy
Hybrid
Chicago, IL, USA
2000 Employees
120K-139K Annually

Takeda Logo Takeda

Senior Data Engineer/Manager

Healthtech • Software • Analytics • Biotech • Pharmaceutical • Manufacturing
Hybrid
Bannockburn, IL, USA
50000 Employees
133K-209K Annually

CNA Logo CNA

Sr. Data Engineer-GCP

Cloud • Insurance • Professional Services • Analytics • Cybersecurity
Remote
Hybrid
Chicago, IL, USA
7000 Employees

Capital One Logo Capital One

Senior Data Engineer (Python, Spark, AWS)

Fintech • Machine Learning • Payments • Software • Financial Services
Hybrid
Chicago, IL, USA
55000 Employees
154K-176K Annually

Similar Companies Hiring

Flume Health Thumbnail
Software • Insurance • Healthtech
US
22 Employees
Spark Advisors Thumbnail
Software • Sales • Other • Insurance • Healthtech
New York, NY
73 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account