McLean County Jobs

85
companies
927
Jobs

P/C Insurance Data Specialist

Country Companies

Country Companies

IT
Bloomington, IL, USA
Posted on Oct 8, 2024
P/C Insurance Data Specialist

Job Number:

240419

Primary Location

: US-IL-Bloomington

As COUNTRY’s Property Casualty Insurance Data Specialist, 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 and 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 (Worker Compensation, 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 Insurance Data Specialist 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, such as worker compensation, auto/home, and commercial
  • Regulatory and/or Governmental statistical reporting experience is preferred (working to set deadlines that will not change for any reason)
  • 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 troubleshoot data procedures and locate/fix root cause of error when problems with a report are identified.
  • Collaborate and participate in a team environment while maintaining attention to detail and on-time deliverables
  • 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.