McLean County Jobs

Bloomington-Normal Economic Development Council

Data Engineer, Property Casualty Insurance

Country Companies

Country Companies

Data Science
Bloomington, IL, USA
Posted on Tuesday, July 9, 2024
Data Engineer, Property Casualty Insurance

Job Number:


Primary Location

: US-IL-Bloomington

As COUNTRY’s Property Casualty Business Intelligence Senior Data Engineer, you will be part of a team that ensures we remain compliant and current with all regulatory, legal, and contractual data reporting requirements. This includes working closely with your direct leader and other business areas to understand and adapt to changes in source files/processes. Collaborating with coworkers to ensure full knowledge-sharing and documenting each process is a critical role at Country and one which requires the right combination of self-motivation, problem solving, technical writing, data identification/gathering/curating/transformation. Familiarity with Property Casualty insurance (personal and commercial) would be very helpful in getting up to speed quickly in this role and understanding the specifics behind the raw data to best address the requirements and adapt to changes as needed.

You will use your technical aptitude to develop, update, and execute automated data gathering, manipulation, and reporting to ensure we meet all of our data reporting requirements on time, on budget, as well as being responsible for curating data from a variety of diverse modern and legacy systems.

You will utilize modern approaches to understand and update/rebuild older processes (examples of old and new: SAS, Focus, Mainframe, Tableau, Excel, SQL, Business Objects, Python, Essbase, QueryWizard, Cobal, and InSync) while ensuring that data quality, completeness, and timeliness of mandatory reporting is not impacted. This position requires a high degree of competency both in self-motivation and team collaboration, as well as hands on data engineering work. The keywords for success in this role are accuracy, completeness, collaboration, understanding, balancing, and timeliness. Our tasks must be completed on time, be fully accurate, and balance to our other financial systems.

You will work closely with Business Compliance, Corporate Compliance, Actuary, Controllers, Accounting, and other Data areas to ensure the data you report is correct, complete and balanced. You will also be self-directed in writing replacement code and data gathering processes, working to identify, understand and improve/modernize multiple existing data calls and environments (especially mainframe/FOCUS based environments) to use a more modern approach to provide more flexible, easier to navigate, more automatable solutions and as a result to provide more readily accessible data to our business partners and regulatory agencies. A key responsibility is the collection, curation, and balancing of data across all property casualty lines of business (Commercial, Farm, Home, Auto, Umbrella, etc…).

This position offers a hybrid work schedule and is based out of our corporate offices in Bloomington, IL.

How does a Property Casualty Business Intelligence Senior Data Engineer make an impact?

  • Develops data pipelines that are scalable, repeatable and secure and can be used for dashboard development, machine learning models and exploratory data analysis.
  • Designs and builds data models in Entity Relationships Diagram (ERD).
  • Prepares and manipulates data. Manages data migrations/conversions and troubleshoots data processing issues.
  • Iteratively delivers functionality using DevOps tools and concepts.
  • Collaborates with other areas to develop standards and best practices for research, analysis, data engineering and machine learning.

Do you have what we're looking for?

  • Insurance industry knowledge, especially of property casualty.
  • Ability to review and understand project proposals from other business units and identify any impacts to the statistical reporting unit’s needs/data before the project moves forward (and offer/develop solutions to address any impacts)
  • Ability to understand older code and create newer, more modern alternatives.
  • Collaborate and participate in a team environment while maintaining attention to detail and on-time deliverables.
  • Flexibility and adaptability to drive change and envision/implement new solutions.
  • Typically requires 7 years of relevant experience or a combination of related experience, education and training.

This position is part of a job family. Placement will be determined by skills and qualifications of the candidate.

Why work with us?

Our employees and representatives serve nearly one million households with our diverse range of personal and business insurance products as well as retirement and investment services. We build relationships and work together to create a stronger, more secure future for our clients and our communities. We’re a big company, yet small enough you can make an impact and won’t get lost in the shuffle. You’ll have the opportunity to learn and grow throughout your career, either within this role or by exploring other areas of our business.

You’ll be able to take advantage of our benefits package, which includes insurance benefits (medical, dental, vision, disability, and life), 401(k) with company match, parental leave, paid time off, paid company holidays and time off to volunteer in your community. Please click here to learn more about who we are and the many benefits we offer our employees.

COUNTRY Financial is committed to providing equal opportunity in all areas of employment, and in providing employees with a work environment free of discrimination and harassment. Employment decisions are made without regard to race, color, religion, age, gender, sexual orientation, veteran status, national origin, disability, or any other status protected by applicable laws or regulations.

Come join our team at COUNTRY today!

COUNTRY Financial does not generally sponsor individuals for employment-based visas for this position.