Sr. Data Engineer

Sedgwick; Frankfort (KY); Remoto; USD 120.000 - 180.000; Tempo pieno

Descrizione del lavoro

Sedgwick is seeking a Sr. Data Engineer to design, build, and maintain scalable data pipelines across on‑premises and cloud environments. You’ll be a core developer for Snowflake, collaborate on data modeling, and enable AI-ready data inputs with dbt and related tools.

You’ll provide direct mentorship to one data engineer, guide analytics teams, and promote governance, CI/CD practices, and reliable data product delivery in a fast-paced, collaborative setting.

Competenze

• Bachelor’s degree in computer science, information systems, data engineering, or a related field from an accredited college or university preferred.
• Equivalent combination of education, professional certifications, and relevant work experience will be considered.
• Five (5)+ years of dedicated data engineering experience, with a proven record of building production-grade data pipelines, required.
• Advanced hands‑on experience with Snowflake architecture, performance tuning, and data sharing required.
• Experience moving data across hybrid environments, including on-premises to cloud, using batch, streaming, and event-driven patterns required.
• Experience building or maintaining semantic layers and structuring data for downstream AI, large language model, or natural-language search capabilities preferred.

Mansioni

• Designs, builds, and maintains scalable data pipelines supporting batch, real-time streaming, and event-driven data movement from on-premises and cloud sources.
• Serves as a core developer for the Snowflake data platform and supports platform performance, data modeling, and storage structures.
• Architects and builds transformation pipelines that deliver high-quality data inputs to Snowflake and dbt AI features.
• Designs and maintains semantic layers and metadata models required to support Self-Service 2.0 natural-language user interfaces.
• Establishes reference architectures, reusable templates, and CI/CD best practices that enable decentralized line-of-business teams to build data products safely and consistently.
• Provides direct management and career mentorship to one data engineer, with potential for team growth, and guides decentralized data analysts in maturing their engineering practices.
• Drives adoption of dbt for data transformation and evaluates the integration of AWS and Azure cloud data tools, including Azure Data Factory, Azure Functions, and Stream Analytics, to optimize data flow.
• Performs other duties as assigned.
• Supports the organization’s quality program(s).
• Travels as required.

Conoscenze

Snowflake architecture

Data pipeline architecture

dbt Semantic Layer

Python (cloud/Azure)

SQL capabilities

dbt

Azure Data Factory

Azure Functions

Stream Analytics

AWS data tools

CI/CD & patterns

Leadership & coaching

Cross-functional collaboration

Data governance & quality

Formazione

Bachelor's degree in computer science, information systems, data engineering

Equivalent combination of education and experience

5+ years data engineering experience

Strumenti

Snowflake

dbt

Azure Data Factory

Azure Functions

Stream Analytics

AWS data services

Descrizione del lavoro

Telecommuter TX

Telecommuter ID

Telecommuter AR

Telecommuter HI

Telecommuter NE

Telecommuter LA

Telecommuter MO

Telecommuter IN

Telecommuter NV

Telecommuter KY

Telecommuter MS

Telecommuter FL

Telecommuter SC

Telecommuter WV

Telecommuter NM

Telecommuter NC

Telecommuter OK

Telecommuter SD

Telecommuter AK

Telecommuter AL

Telecommuter TN

Telecommuter KS

Telecommuter IA

Telecommuter PA

Telecommuter MI

Telecommuter WI

Telecommuter GA

Telecommuter MT

Telecommuter AZ

Telecommuter WY

R78845

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

Sr. Data Engineer

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES

• Designs, builds, and maintains scalable data pipelines supporting batch, real-time streaming, and event-driven data movement from on-premises and cloud sources.
• Serves as a core developer for the Snowflake data platform and supports platform performance, data modeling, and storage structures.
• Architects and builds transformation pipelines that deliver high-quality data inputs to Snowflake and dbt AI features.
• Designs and maintains semantic layers and metadata models required to support Self-Service 2.0 natural-language user interfaces.
• Establishes reference architectures, reusable templates, and CI/CD best practices that enable decentralized line-of-business teams to build data products safely and consistently.
• Provides direct management and career mentorship to one data engineer, with potential for team growth, and guides decentralized data analysts in maturing their engineering practices.
• Drives adoption of dbt for data transformation and evaluates the integration of AWS and Azure cloud data tools, including Azure Data Factory, Azure Functions, and Stream Analytics, to optimize data flow.

ADDITIONAL FUNCTIONS and RESPONSIBILITIES

• Performs other duties as assigned.
• Supports the organization’s quality program(s).
• Travels as required.

SUPERVISORY RESPONSIBILITIES

• Provides direct management and career mentorship to one data engineer, with potential for the team to grow.

QUALIFICATIONS

Education & Licensing

Bachelor’s degree in computer science, information systems, data engineering, or a related field from an accredited college or university preferred.

Equivalent combination of education, professional certifications, and relevant work experience will be considered.

Experience

• Five (5)+ years of dedicated data engineering experience, with a proven record of building production-grade data pipelines, required.
• Advanced hands‑on experience with Snowflake architecture, performance tuning, and data sharing required.
• Experience moving data across hybrid environments, including on-premises to cloud, using batch, streaming, and event-driven patterns required.
• Experience building or maintaining semantic layers and structuring data for downstream AI, large language model, or natural-language search capabilities preferred.

Skills & Knowledge

• Advanced knowledge of Snowflake architecture, performance tuning, data modeling, storage structures, and secure data sharing.
• Strong knowledge of scalable batch, real-time streaming, and event-driven data pipeline architecture.
• Experience with semantic layers, including dbt Semantic Layer and Snowflake Cortex or semantic definitions.
• Strong Python skills, particularly in cloud environments and Azure Functions used for data workloads.
• Strong SQL capabilities.
• Experience with dbt highly preferred.
• Experience with Azure data tools, including Azure Data Factory, Azure Functions, and Stream Analytics, preferred.
• Familiarity with AWS data ecosystems preferred.
• Knowledge of reference architecture, reusable pipeline patterns, templates, and CI/CD practices.
• Collaborative coaching and leadership skills, with the ability to teach, establish governance, and strengthen engineering practices across cross-functional teams.
• Strong analytical, problem-solving, organizational, and communication skills.
• 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

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

If you're excited about this role but your experience doesn't align perfectly with every qualification in the job description, consider applying for it anyway! 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