Data Engineer

Sedgwick Claims Management Services Inc.; Texas; Hybrid; USD 120,000 - 150,000; Full time

Job summary

Sedgwick is seeking a Gen AI/Data Engineer to architect and build the data supply chain powering enterprise AI initiatives. You will design production-grade data pipelines bridging on-prem systems with Snowflake, AWS, and Azure, enabling ML, feature stores, and RAG-based AI workloads.

The role emphasizes delivering clean, versioned data, governance, and scalable data solutions in a multi-cloud environment with a focus on performance and reliability.

Qualifications

• Master’s degree in Computer Science, Data Engineering, or a related field.
• Six years of hands-on data engineering experience, delivering production-grade pipelines for Data Science and AI in multi-cloud environments.
• Experience building pipelines that power ML and AI initiatives.

Responsibilities

• Designs, builds, and maintains resilient ETL/ELT pipelines ingesting data from on‑premise systems, AWS services (S3, RDS), and Azure platforms (Blob Storage, Azure SQL), centralizing and curating data for Snowflake and AI services.
• Develops and maintains feature stores and analytically optimized datasets for ML workflows.
• Engineers data pipelines for generative AI use cases, including extraction, transformation, chunking, and loading into vector databases across AWS and Azure.
• Acts as a Snowflake power user, implementing advanced data modeling, Snowpipe automation, and compute/storage optimization.
• Orchestrates complex workflows with Airflow, AWS Step Functions, and Azure Data Factory for multi-cloud data movement.
• Implements data quality, validation, and observability frameworks to detect data drift and anomalies.
• Drives efficiency by optimizing storage, compute, and query performance in Snowflake, AWS, and Azure.
• Partners with MLOps, Data Science, and AI teams to translate experimental use cases into production-ready data solutions.

Skills

Team collaboration

Problem solving

Get-it-done attitude

Adaptability

Communication

Education

Master's degree in Computer Science or related field

6 years of data engineering experience

Tools

Snowflake

AWS

Azure

Python

SQL

PySpark

Docker

Airflow

Azure Data Factory

Snowpipe

Snowflake data modeling

Job description

By joining Sedgwick, you'll be part of something truly meaningful. It’s what our 33,000 colleagues do every day for people around the world who are facing the unexpected. We invite you to grow your career with us, experience our caring culture, and enjoy work-life balance. Here, there’s no limit to what you can achieve. Newsweek Recognizes Sedgwick as America’s Greatest Workplaces National Top Companies Certified as a Great Place to Work® Fortune Best Workplaces in Financial Services & Insurance Data Engineer

Data Engineer PRIMARY PURPOSE:

The Gen AI Engineer within the Transformation Office serves as the hands‑on architect of the enterprise data supply chain for the organization’s most advanced analytics, data science, and AI initiatives. This role performs the critical engineering work required to deliver high‑fidelity, production‑grade data that powers machine learning models, feature stores, and generative AI applications. Operating as a day‑one builder, the Gen AI Engineer designs and delivers data pipelines that bridge legacy on‑premise systems—including mainframes, SQL Server, and DB2—with modern cloud platforms such as Snowflake and AWS/Azure AI ecosystems. The role ensures that data is not merely transferred, but deliberately engineered to meet the statistical, performance, and governance requirements of model training, inference, and RAG‑based AI systems.

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES

• Designs, builds, and maintains resilient ETL/ELT pipelines that ingest data from on‑premise systems, AWS services (S3, RDS), and Azure platforms (Blob Storage, Azure SQL), centralizing and curating data for consumption in Snowflake and downstream AI services.
• Develops and maintains feature stores and analytically optimized datasets that support machine learning workflows, ensuring data is clean, versioned, reproducible, and statistically valid for Data Science teams.
• Engineers data pipelines that enable generative AI use cases, including the automated extraction, transformation, chunking, and loading of structured and unstructured data into vector databases across AWS and Azure environments.
• Acts as a Snowflake power user and technical lead, implementing advanced data modeling patterns, Snowpipe automation, and compute and storage optimization to support high‑concurrency analytics and AI workloads.
• Executes non‑invasive data extraction strategies to unlock mission‑critical data from decades‑old legacy systems while preserving system stability and avoiding disruption to core business operations.
• Designs and manages complex, cross‑platform data workflows using orchestration tools such as Airflow, AWS Step Functions, and Azure Data Factory to ensure reliable, synchronized data movement across the organization’s multi‑cloud architecture.
• Partners closely with central IT, database administrators, infrastructure, and security teams to resolve connectivity and access challenges—including PrivateLink, IAM, network segmentation, and firewall controls—while securing production approval for new data integrations.
• Implements automated data quality, validation, and observability frameworks to detect data drift, anomalies, and integrity issues that could negatively impact production analytics, machine learning, or AI systems.
• Drives efficiency across the data ecosystem by optimizing storage, compute usage, and query performance in Snowflake, AWS, and Azure, ensuring responsible cost management and measurable ROI for Transformation Office initiatives.
• Operates as a dedicated engineering partner to MLOps, Data Science, and AI teams, rapidly iterating on evolving data requirements and translating experimental use cases into scalable, production‑ready data solutions.

ADDITIONAL FUNCTIONS and RESPONSIBILITIES

• Performs other duties as assigned.
• Travel as required.

QUALIFICATIONS

Education & Licensing

• Master’s degree in Computer Science, Data Engineering, or a related field from an accredited college or university preferred.
• Experience Six (6) years of hands‑on data engineering experience, with a track record of building production‑grade pipelines for Data Science and AI in multi‑cloud environments or equivalent combination of education and experience required.

Skills & Knowledge

• Expert‑level proficiency in Snowflake architecture, including data sharing, performance tuning, and the integration of Snowflake with external cloud AI services.
• Advanced, hands‑on knowledge of AWS (S3, Glue, Lambda) and Azure (Data Factory, Synapse) data services.
• Mastery of Python, SQL, and PySpark.
• Deep experience with data orchestration and containerization (Docker).
• Proven ability to interface with "old world" tech (on‑premise SQL, Mainframe extracts, flat files) and transform it for modern cloud consumption.
• A strong understanding of the specific data needs for Machine Learning (feature engineering) and Generative AI (vectorization and embedding pipelines).
• A "get‑it‑done" attitude, capable of navigating enterprise bureaucracy and technical debt to ship code at the speed required by a Transformation Office.
• Ability to work in a team environment.
• Ability to meet or exceed Performance Competencies.

WORK ENVIRONMENT

When applicable and appropriate, consideration will be given to reasonable accommodations. Mental: Clear and conceptual thinking ability; excellent judgment, troubleshooting, problem solving, analysis, and discretion; ability to handle work‑related stress; ability to handle multiple priorities simultaneously; and ability to meet deadlines. Physical: Computer keyboarding, travel as required. Auditory/Visual: Hearing, vision and talking.

Equal Opportunity

Sedgwick is an Equal Opportunity Employer and a Drug‑Free Workplace.

Sedgwick is building a diverse, equitable, and inclusive workplace and recognizes that each person possesses a unique combination of skills, knowledge, and experience.

You may be just the right candidate for this or other roles.

Sedgwick is the world’s leading risk and claims administration partner, which helps clients thrive by navigating the unexpected. The company’s expertise, combined with the most advanced AI‑enabled technology available, sets the standard for solutions in claims administration, loss adjusting, benefits administration, and product recall. With over 33,000 colleagues and 10,000 clients across 80 countries, Sedgwick provides unmatched perspective, caring that counts, and solutions for the rapidly changing and complex risk landscape.

For more, see sedgwick.com