Data Engineer (Remote)
Peoria, IL, USA
Posted on Saturday, August 6, 2022
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.
Under general management, RLI is seeking an energetic and collaborative Data Engineer responsible for the design, development, testing, and integration of data pipelines and curated data assets within our enterprise data platform to serve our analytics and reporting needs. You must follow industry best practices for data governance, security and quality, stay current on the latest innovations, and be comfortable working with on-prem and cloud technologies. This person will report to the Director, Technology within our Data & Analytics practice.
Note: No Visa Sponsorships Provided For This Position
Principal Duties & Responsibilities
Designs and builds data pipelines: Create, maintain, and optimize workloads from development to production.
Responsible for the accessibility and reliability of organizations data, conforming to RLI security standards and practices .
Understands data classification, lifecycle and protective processes to ensure extensible, scalable, reliable and secure transfers of data.
Executes analysis and remediation of root causes, including deficiencies in technology, process, or resource capabilities.
Develops and enforces RLI and industry best practices for data integration and data quality.
Performs coding, debugging, testing, and troubleshooting throughout the development process.
Continuously deploys software by automating integration, test, and deployment of code.
Works in agile delivery model alongside data architects, product management, data analysts, and other developers.
Education & Experience
Typically requires a Bachelor’s degree in computer science, information systems, business administration or related field
4+ years of relevant experience
[OR] equivalent level of education and experience
Knowledge, Skills, & Competencies
Experience with Informatica Intelligent Cloud Services moving large data sets to Azure or AWS from on-prem and other cloud solutions.
Experience working with structured and unstructured data and big data cloud platforms including Snowflake, MongoDB, BigQuery, etc.
Working knowledge in SQL.
Technical understanding of data modeling, integration, architecture, virtualization, warehousing, transformations and quality techniques within Informatica IICS or IDMC.
Working knowledge of Git repositories (bitbucket, GitHub), CI/CD (Jenkins, Azure DevOps) and software development tools.
Basic experience in working with data governance and data security in moving data pipelines into production.
Strong analytical, problem solving, and organizational skills.
Effectively communicates, verbally and written, findings and recommendations within a distributed operating environment.
Experience working with onshore and offshore development teams with strong listening and interpretation skills.
Must be highly adaptable, resolve ambiguity, and demonstrate intellectual curiosity.
Adept in agile methodologies.
Applicants must be authorized to work for ANY employer in the U.S.
P&C Insurance experience a plus.
Personal & Professional Growth
RLI 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
Diversity & Inclusion
Our 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.
At 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.
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