Data Engineer, Property Casualty Insurance

2 months ago

Bloomington, United States Country Financial Full time
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.

  • Data Engineer, Property Casualty Insurance

    2 months ago

    Bloomington, United States Country Financial Full time

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

  • Property & Casualty Actuarial Analyst

    1 month ago

    Bloomington, United States State Farm Full time

    OverviewWe are not just offering a job but a meaningful career Come join our passionate teamAs a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inclusion to ensure a workforce that is engaged, builds on the strengths and talents of...

  • Property & Casualty Actuarial Analyst

    1 month ago

    Bloomington, United States State Farm Full time

    OverviewWe are not just offering a job but a meaningful career! Come join our passionate team!As a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inclusion to ensure a workforce that is engaged, builds on the strengths and talents of...

  • Large Property Risk Manager

    14 hours ago

    Bloomington, United States USI Insurance Services Full time

    Job SummaryWe are seeking a highly skilled Senior Property Placement Consultant to join our team at USI Insurance Services. As a key member of our Commercial Lines team, you will be responsible for providing expert technical support to clients and internal stakeholders.Key ResponsibilitiesProvide guidance and coaching to junior team members on property risk...

  • Experienced Property

    1 month ago

    Bloomington, United States State Farm Full time

    OverviewWe are not just offering a job but a meaningful career! Come join our passionate team!As a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inclusion to ensure a workforce that is engaged, builds on the strengths and talents of...

  • Personal Lines Insurance Account Executive

    1 week ago

    Bloomington, Illinois, United States SAHOURI INSURANCE & FINANCIAL Full time

    Job OverviewSahouri Insurance & Financial is a premier insurance agency with a legacy of excellence in providing comprehensive insurance solutions since its inception. Our commitment lies in delivering a diverse array of insurance products tailored to meet the needs of both local and global clients. At Sahouri, we prioritize outstanding customer service and...

  • Data Engineer

    3 weeks ago

    Bloomington, United States State Farm Full time

    OverviewWe are not just offering a job but a meaningful career Come join our passionate teamAs a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inclusion to ensure a workforce that is engaged, builds on the strengths and talents of...

  • Insurance Claims Adjuster

    1 week ago

    Bloomington, Indiana, United States Great West Casualty Company Full time

    Position Overview We are seeking a Liability Claims Specialist to join our team in a hybrid work model, allowing for a blend of in-office and remote work. Are you an assertive decision-maker ready to advance your career? Do you possess substantial experience in managing commercial or automotive liability claims? Join Great West Casualty Company, a respected...

  • Data Engineer

    3 weeks ago

    Bloomington, United States State Farm Full time

    OverviewWe are not just offering a job but a meaningful career! Come join our passionate team!As a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inclusion to ensure a workforce that is engaged, builds on the strengths and talents of...

  • Actuarial Manager for Property

    4 days ago

    Bloomington, United States State Farm Full time

    OverviewAt State Farm, we are committed to providing a fulfilling career, not just a job. Our team is passionate about serving our customers and making a difference in the insurance and financial services sector. We value diversity and inclusion, ensuring an engaged workforce that leverages the strengths and talents of all associates, fostering a Good...

  • Actuarial Manager for Property

    1 week ago

    Bloomington, United States State Farm Full time

    OverviewWe are not just offering a position but a fulfilling career. Our organization is a leader in the insurance and financial services sector, committed to hiring top talent to serve our clients effectively. We prioritize diversity and inclusion to cultivate a workforce that is engaged, leveraging the strengths and talents of all associates, and fostering...

  • Actuarial Manager for Property

    4 days ago

    Bloomington, United States State Farm Full time

    OverviewAt State Farm, we are committed to offering not just a job, but a fulfilling career. As a leading organization in the insurance and financial services sector, we pride ourselves on hiring top talent to serve our customers effectively. Our commitment to diversity and inclusion fosters a workforce that is engaged and leverages the strengths and skills...

  • Insurance Client Support Specialist

    1 week ago

    Bloomington, Illinois, United States Farmers Insurance - Carrie Joos Agency Full time

    Job OverviewJoin the Farmers Insurance - Carrie Joos Agency as an Insurance Client Support Specialist.We are a dynamic insurance agency focused on providing comprehensive coverage solutions, including Auto, Home, Business, and Life insurance. We pride ourselves on fostering a competitive and supportive environment.Key Qualifications for the Insurance Client...

  • Actuarial Manager for Property

    3 days ago

    Bloomington, United States State Farm Full time

    OverviewWe are not merely offering a position but a fulfilling career. Become part of our dedicated team.As a prominent player in the insurance and financial services sector, we prioritize hiring exceptional talent to serve our clients, establishing ourselves as a leader in the industry. State Farm values diversity and inclusion, fostering a workforce that...

  • Property & Casualty Actuarial Manager

    3 weeks ago

    Bloomington, United States State Farm Full time

    OverviewWe are not just offering a job but a meaningful career! Come join our passionate team!As a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inclusion to ensure a workforce that is engaged, builds on the strengths and talents of...

  • Property & Casualty Actuarial Manager

    3 months ago

    Bloomington, United States State Farm Full time

    OverviewWe are not just offering a job but a meaningful career! Come join our passionate team!As a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inclusion to ensure a workforce that is engaged, builds on the strengths and talents of...

  • Property & Casualty Actuarial Manager

    2 months ago

    Bloomington, United States State Farm Full time

    OverviewWe are not just offering a job but a meaningful career! Come join our passionate team!As a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inclusion to ensure a workforce that is engaged, builds on the strengths and talents of...

  • Insurance Apprentice Agent

    1 week ago

    Bloomington, United States Farmers Insurance - Carrie Joos Agency Full time

    This position serves as a training opportunity to evolve into a Farmers agent and establish your own enterprise.You will collaborate with a seasoned, award-winning agent who will provide you with valuable insights and essential tools to achieve success independently.This is not merely a job; it is a pathway to becoming a fully autonomous business owner with...

  • Insurance Apprentice Agent

    1 week ago

    Bloomington, Illinois, United States Farmers Insurance - Carrie Joos Agency Full time

    Position OverviewThis role serves as a stepping stone to becoming a Farmers Insurance agent and establishing your own enterprise.You will collaborate with a seasoned, award-winning agent who will provide valuable insights and the necessary tools to help you thrive independently.This opportunity is not merely a job; it is a pathway to achieving complete...

  • Customer Service Representative

    4 days ago

    Bloomington, Indiana, United States ALEXANDRA WALLACH INSURANCE AGENCY INC Farmers Insurance Full time

    Job OverviewAt Alexandra Wallach Insurance Agency Inc. Farmers Insurance, we are seeking a highly skilled Customer Service Representative to join our team. As an Insurance Professional, you will play a vital role in providing exceptional support to our clients, ensuring their insurance needs are met with professionalism and expertise.Key...