Senior Data Engineer: Scalable Pipelines & Warehouse

Talentify; Overland Park (KS); On-site; USD 110,000 - 150,000; Full time

Job summary

Intrepid Direct Insurance (IDI) is hiring a Senior Data Engineer in Overland Park, KS to mentor, orchestrate, implement, and monitor data pipelines across our organization. You’ll partner with operations and engineering to enhance data availability and quality for business users and customers.

You will contribute to long-term data warehousing, model data, and automate processes, ensuring accuracy and timely availability of data for regulatory requests and analytics.

Qualifications

• Bachelor’s degree in Mathematics, Statistics, Computer Science, or equivalent experience.
• 6+ years of relevant data engineering experience.
• Experience with Microsoft SQL Server.
• Familiarity with ETL tools and concepts.
• Hands-on experience with database design and data modeling, preferably Data Vault.
• Experience supporting and troubleshooting SSIS packages.
• Experience consuming event-based data via APIs or queues.
• Experience in Agile software development.
• Experience with insurance data is highly desired.

Responsibilities

• Mentor, orchestrate, implement, and monitor data pipelines across the organization.
• Improve data availability and quality for business units and customers.
• Participate in long-term data warehousing planning and data warehouse buildout.
• Monitor and optimize existing pipelines; automate manual processes.
• Design and deploy new pipelines ingesting data from disparate sources.
• Ensure data accuracy and availability in the data warehouse.
• Collaborate with cross-functional teams on data-driven solutions.
• Respond to regulatory information requests and aid in data cataloging.

Skills

SQL Server

Data modeling

ETL

Agile

APIs/Queues

Education

Bachelor’s degree in CS/Math/Statistics

Tools

SSIS

Data Vault

Power BI

Job description

Intrepid Direct Insurance (IDI) is hiring a Senior Data Engineer in Overland Park, KS to mentor, orchestrate, implement, and monitor data pipelines across our organization. You’ll partner with operations and engineering to enhance data availability and quality for business users and customers.

You will contribute to long-term data warehousing, model data, and automate processes, ensuring accuracy and timely availability of data for regulatory requests and analytics.