Skip to content

Open nowPosted today

Data Engineering Consultant

countryfinancial309 open roles

Where
Bloomington, IL
Work mode
Hybrid
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowData Engineering Consultantcountryfinancial · Bloomington, IL
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on countryfinancial's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

9.0% of postings close within 7 days. Measured by our own scanner across the market. countryfinancial postings stay open a median of 6 days.

Share of postings closed within
  1. 1.8%1 day
  2. 3.9%3 days
  3. 9.0%7 days
  4. 15.5%14 days
  5. 34.0%30 days
This job: posted today

countryfinancial median: 6 days open

The posting

Experience more with a career at COUNTRY Financial!

We’re excited you’re interested in a career at COUNTRY as we strive toward our vision - to enrich lives in the communities we serve. Our footprint spans coast to coast. But more important than where we operate, is the people who do the work. Apply today to help our organization grow and make a difference for our clients.

About the role

COUNTRY Financial is seeking a hands-on Senior Guidewire Data Developer who combines deep technical expertise with architecture leadership. The ideal candidate has extensive experience integrating Guidewire PolicyCenter, ClaimCenter, and ContactManager into enterprise data platforms, modernizing legacy insurance data environments to cloud-native architectures, and delivering measurable business outcomes through scalable, high-performing data solutions.

Designs, develops, implements, and maintains overall database/data warehouse to integrate data from various sources/systems throughout the organization. Establishes database management systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logic, capacity planning, interface specifications, maintenance and security. Develops strategies for data acquisition, archive recovery, and database implementation.

The ideal candidate will possess strong insurance domain knowledge, expertise across Azure, AWS, Snowflake, and Microsoft Fabric, and the ability to lead complex enterprise initiatives while partnering across business, analytics, and technology teams. The candidate will also have a deep expertise in Operational Data Stores (ODS), Data Lakes, Guidewire DataHub, insurance data modeling, and large-scale data integration patterns. The candidate will partner with business, analytics, architecture, and Guidewire application teams to design scalable, secure, and high-performing data solutions supporting reporting, operational analytics, regulatory compliance, and advanced analytics initiatives.

How does this role 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 manuipulates 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?

Responsibilities

  • Design and implement enterprise data architecture supporting Guidewire InsuranceSuite integrations across PolicyCenter, ClaimCenter, ContactManager, DataHub, ODS, Data Lakes, and Enterprise Data Warehouses.
  • Lead cloud modernization initiatives, including migration of legacy insurance data platforms to Azure, AWS, Snowflake, and Microsoft Fabric.
  • Establish scalable data integration patterns and governance standards that improve performance, reduce operational costs, and support enterprise reporting, analytics, and regulatory compliance.
  • Partner with business, analytics, architecture, and delivery teams to define and execute strategic data roadmaps supporting Commercial & Agribusiness Insurance objectives.
  • Provide technical leadership for geographically distributed teams and drive successful delivery of complex enterprise data programs from requirements through production deployment.
  • Build and support Operational Data Store (ODS) solutions that provide consolidated, near real-time business data.
  • Design and maintain Data Lake architecture supporting structured and semi-structured insurance data.
  • Develop scalable ETL/ELT pipelines using modern cloud-based technologies.
  • Design and optimize data models for reporting, analytics, operational support, and regulatory requirements.
  • Integrate Guidewire transactional data into enterprise data platforms.
  • Collaborate with architects to define enterprise data strategies and standards.
  • Implement data quality controls, validation processes, and reconciliation frameworks.
  • Support reporting and analytics teams through reliable, governed data assets.
  • Perform root-cause analysis for data issues and implement corrective actions.
  • Optimize data pipelines and database performance.
  • Support Guidewire Cloud, DataHub, and enterprise data modernization initiatives.
  • Participate in conversion and migration efforts related to Guidewire implementations.
  • Mentor junior engineers and contribute to data engineering best practices.

Required Qualifications

  • 8+ years of Data Engineering experience.
  • Experience with Guidewire DataHub and extracting data from InsuranceSuite into an ODS/Data Lake environment is strongly preferred.
  • Experience building and supporting Operational Data Stores (ODS).
  • Experience designing and implementing Enterprise Data Lakes or Lakehouse architectures.
  • Strong SQL development and performance tuning skills.
  • Experience with Databricks, Spark, PySpark, and large-scale data processing.
  • Experience with Azure Data Factory, Synapse, Snowflake, or similar cloud analytics platforms.
  • Experience implementing data governance, lineage, and data quality controls.

Preferred Experience

  • 3+ years working with Guidewire InsuranceSuite data.
  • Strong understanding of Guidewire PolicyCenter and ClaimCenter data models.
  • Experience supporting enterprise reporting and regulatory reporting solutions.
  • Excellent communication, analytical, and problem-solving skills.
  • Proven experience integrating all Guidewire InsuranceSuite centers (PolicyCenter, ClaimCenter, and ContactManager) into enterprise reporting and analytics platforms.
  • Experience with Microsoft Fabric and other modern cloud data platforms, including demonstrated success improving performance and optimizing operating costs through modernization initiatives.
  • Strong understanding of insurance industry data domains, including policy, claims, actuarial, regulatory, and governance reporting.
  • Experience leading large-scale data programs and mentoring onsite/offshore teams of developers, analysts, and data engineers.
  • Ability to combine hands-on technical development with architecture leadership and delivery management.

Base Pay Range:

$132,000-$181,500

The base pay range represents the typical range of potential salary offers for candidates hired. Factors used to determine your actual salary include your specific skills, qualifications and experience.

Incentive Pay:

In addition to base salary, this position is eligible for a Short-Term Incentive plan.

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.

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!

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against countryfinancial's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on countryfinancial's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    countryfinancial's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.