FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Data Engineering Consultant
COUNTRY Financial®. Design and implement enterprise data architecture supporting Guidewire InsuranceSuite integrations across PolicyCenter, ClaimCenter, ContactManager, DataHub, ODS, Data Lakes, and Enterprise Data Warehouses .
Posted 10/13/2026full-timeBloomington • Illinois • United StatesSeniorLead💰 $132,000 - $181,500 per yearWebsite
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in designing and implementing enterprise data architecture, particularly with Guidewire InsuranceSuite integrations and cloud modernization initiatives. Proficient in developing scalable data solutions, optimizing data pipelines, and ensuring data quality and governance across various platforms.
Highest-signal resume keywords
Guidewire DataHub ExperienceCloud Modernization InitiativesSQL Development and Performance TuningData Governance and Quality ControlsEnterprise Data Lake Architecture
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data EngineeringETL/ELT Pipeline DevelopmentData ModelingOperational Data Store (ODS) SupportData Quality ControlsRoot-Cause AnalysisData MigrationPerformance OptimizationData IntegrationMachine Learning Data Pipelines
Soft Skills
Technical LeadershipMentoringCollaborationProblem-SolvingCommunication
Tools & Technologies
AzureAWSSnowflakeMicrosoft FabricDatabricksSparkPySparkAzure Data FactorySynapseDevOps Tools
Industry Keywords
Insurance Data DomainsPolicyCenterClaimCenterRegulatory ReportingData GovernanceData LineageData LakesData WarehousesAnalytics PlatformsData Engineering Best Practices
Tech Stack
Tools & technologiesAWSAzureCloudETLGuidewirePySparkSparkSQL
About the role
Key responsibilities & impact- 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 migrating legacy insurance data platforms to Azure, AWS, Snowflake, and Microsoft Fabric
- Establish scalable data integration patterns and governance standards
- Partner with business, analytics, architecture, delivery, and Guidewire application teams on strategic data roadmaps and scalable data solutions
- Provide technical leadership for geographically distributed teams and drive enterprise data programs from requirements through production deployment
- Build and support near-real-time Operational Data Store solutions
- Design and maintain Data Lake architecture for structured and semi-structured insurance data
- Develop scalable ETL/ELT pipelines using modern cloud technologies
- Design and optimize data models for reporting, analytics, operational support, and regulatory requirements
- Integrate Guidewire transactional data into enterprise data platforms
- Implement data quality controls, validation processes, and reconciliation frameworks
- Support reporting and analytics teams with reliable, governed data assets
- Perform root-cause analysis and implement corrective actions for data issues
- Optimize data pipelines and database performance
- Support Guidewire Cloud, DataHub, and enterprise data modernization initiatives
- Participate in Guidewire conversion and migration efforts
- Mentor junior engineers and contribute to data engineering best practices
- Develop scalable, repeatable, and secure data pipelines for dashboards, machine learning, and exploratory data analysis
- Design data models in Entity Relationships Diagrams (ERD)
- Prepare and manipulate data; manage data migrations/conversions and troubleshoot processing issues
- Iteratively deliver functionality using DevOps tools and concepts
- Collaborate on standards and best practices for research, analysis, data engineering, and machine learning
Requirements
What you’ll need- 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
- 3+ years working with Guidewire InsuranceSuite data
- Strong understanding of Guidewire PolicyCenter and ClaimCenter data models
- Experience supporting enterprise reporting and regulatory reporting solutions
- 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
- 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
Benefits
Comp & perks- Short-Term Incentive plan
- Medical insurance
- Dental insurance
- Vision insurance
- Disability insurance
- Life insurance
- 401(k) with company match
- Opportunities to learn and grow throughout your career
- Equal-opportunity, discrimination-free work environment