Sr. Data Engineer

RLI Corp. - Peoria, IL

Full-time - Mid Level

Hybrid - Peoria, IL

Insurance Carriers and Related Activities

About the position

The Sr. Data Engineer at RLI is responsible for designing, developing, and integrating data pipelines and assets within the enterprise data platform. This role ensures data accessibility, reliability, and security to support analytics and reporting across the organization, utilizing both on-premises and cloud technologies while adhering to best practices in data governance and quality.

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.

Requirements

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

Nice-to-haves

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

Benefits

• 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
• 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 insurance for purchase
• Critical Illness & Accident insurance
• Short-term and long-term disability benefits