Senior Data Engineer - Data Warehousing and Pipelines Lead

Intrepid Direct Insurance; Overland Park (KS); On-site; USD 100,000 - 130,000; Full time

Job summary

A financial services company in Overland Park, KS is seeking a Senior Data Engineer to enhance data pipelines and ensure data quality. The ideal candidate should have at least 6 years of relevant experience and a bachelor's degree in a related field. This full-time role will involve collaboration with various teams to develop data-driven solutions and support existing data processes. The position emphasizes strong analytical skills and flexibility in a startup environment.

Qualifications

• 6+ years of relevant data engineering experience.
• Experience supporting and troubleshooting SSIS packages.
• Experience with insurance data highly desired.

Responsibilities

• Assist with long-term strategic planning for data warehousing needs.
• Contribute to data modeling exercises and the buildout of the data warehouse.
• Monitor existing pipelines and recommend performance improvements.
• Automate manual processes.
• Design and build new data pipelines.
• Ensure accuracy and availability of data.
• Collaborate with a multi-disciplinary team.
• Create and deploy reports as needed.

Skills

Microsoft SQL Server

ETL tools

Data Vault methodology

SSIS packages

APIs or queues

Agile software development

Power Bi

Analytical thinking

Problem-solving

Strong communication skills

Education

Bachelor’s degree in Mathematics, Statistics, Computer Science

Job description

A financial services company in Overland Park, KS is seeking a Senior Data Engineer to enhance data pipelines and ensure data quality. The ideal candidate should have at least 6 years of relevant experience and a bachelor's degree in a related field. This full-time role will involve collaboration with various teams to develop data-driven solutions and support existing data processes. The position emphasizes strong analytical skills and flexibility in a startup environment.