Data Engineer: Build Scalable Data Pipelines & Models

W. R. Berkley Corporation; Overland Park (KS); On-site; USD 90,000 - 120,000; Full time

Job summary

Intrepid Direct Insurance (IDI), part of the W. R. Berkley Corporation, is hiring a Data Engineer for our Overland Park, KS office to design, build, and manage scalable data pipelines and models.

You will collaborate with data scientists, analysts, and developers to ensure data availability, quality, and timely analytics, applying best practices in governance and performance. The role emphasizes hands-on work with SQL Server, ETL, and modern data techniques in a fast-paced, collaborative

Qualifications

• Bachelor’s degree in Mathematics, Statistics, Computer Science, or equivalent experience.
• 3+ years of relevant data engineering experience.
• Analytical thinker with experience in a fast-paced startup environment.
• Technical expertise 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 through APIs or queues.
• Experience in Agile software development.
• Experience with insurance data highly desired.
• Detail oriented, solid organizational, and problem-solving.
• Strong written, visual, and verbal communication skills.
• Team oriented with a strong willingness to serve others in an agile startup environment.
• Flexible in assuming new responsibilities as they arise.
• Experience with Power BI desired.

Responsibilities

• Design, construct, test, and maintain scalable data management systems that adhere to both business requirements and industry best practices.
• Create data models and architecture patterns that optimize functionality, cost, performance, scalability, reusability, security, and extensibility.
• Devise, support and implement strategies for data acquisition, archival recovery, and database implementations to ensure data fidelity and cleanliness.
• Maintain robust data integrity across a variety of data sources and systems, facilitating data migrations and preparing data for advanced analytics.
• Oversee and enhance the performance and storage of database systems through automated maintenance scripts.
• Collaborate with developers, data scientists, analysts, and others to support data-related technical needs and improvements.
• Stay updated on industry trends and technologies, advocating for new tools and techniques that can enhance our data architecture and management capabilities.

Skills

SQL Server

ETL

Data Modeling

APIs/Queues

Agile

Power BI

Education

Bachelor’s degree in Computer Science or equivalent

Tools

SSIS

Power BI

Job description

Intrepid Direct Insurance (IDI), part of the W. R. Berkley Corporation, is hiring a Data Engineer for our Overland Park, KS office to design, build, and manage scalable data pipelines and models.

You will collaborate with data scientists, analysts, and developers to ensure data availability, quality, and timely analytics, applying best practices in governance and performance. The role emphasizes hands-on work with SQL Server, ETL, and modern data techniques in a fast-paced, collaborative