Data Engineering Consultant

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!