Data Engineer

W. R. Berkley

Overland Park (KS)

On-site

USD 90,000 - 120,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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

Company Details

Intrepid Direct Insurance (IDI) is a rapidly growing direct to consumer property and casualty insurance company. A member of the W. R. Berkley Corporation, a fortune 500 company, rated A+ (Superior) by A.M. Best, Intrepid Direct’s vision is to make life better for business. The insurance industry has not evolved with innovation like other major industries.We’re here to change that. We are making life better for our customers, shareholders, and our team members by leveraging data and technology as insurance experts for our targeted customers. You will be part of a highly collaborative team of talented and focused professionals. Join a group that enjoys working together, trusts each other, and takes pride in our hard‑earned success.

https://intrepiddirect.com/

The Company is an equal employment opportunity employer.

Responsibilities

Join our team at as a Data Engineer and play a pivotal role in designing, creating, deploying, and managing our company's data systems. This essential position supports our growth and innovation by ensuring the availability of high-quality data. You will be responsible for designing and building scalable data pipelines, developing data models, and implementing strategies for data acquisition and management. Your expertise in data infrastructure and database management will enhance the availability, reliability, and integrity of data used across the organization.

Key functions include but are not limited to:

  • Design and Build Database Systems: Design, construct, test, and maintain highly scalable data management systems that adhere to both business requirements and industry best practices.
  • Data Modeling and Design: Create data models and architecture patterns that optimize functionality, cost, performance, scalability, reusability, security, and extensibility.
  • Data Strategy and Management: Devise, support and implement strategies for data acquisition, archival recovery, and database implementations to ensure data fidelity and cleanliness.
  • Integration and Migration: Maintain robust data integrity across a variety of data sources and systems, facilitating data migrations and preparing data for advanced analytics.
  • Performance Management: Oversee and enhance the performance and storage of database systems through automated maintenance scripts.
  • Collaboration and Support: Collaborate with developers, data scientists, analysts, and others to support data-related technical needs and improvements.
  • Innovation and Research: Stay updated on industry trends and technologies, advocating for new tools and techniques that can enhance our data architecture and management capabilities.
Qualifications
  • Bachelor’s degree in Mathematics, Statistics, Computer Science, or equivalent experience.
  • 3+ years of relevant data engineering experience.
  • Analytical thinker with experience working 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, preferable experience with Data Vault methodology.
  • 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.

This role is based in our Overland Park, KS office. It is a full-time, in-office role.

Additional Company Details

We do not accept unsolicited resumes from third party recruiting agencies or firms. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment.

Sponsorship Details

Sponsorship not Offered for this Role

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

Berkley Technology Services LLC • Overland Park (KS)

On-site
USD 110,000 - 150,000
Data Engineer
Data Engineer

Berkley Technology Services LLC • Overland Park (KS)

On-site
USD 95,000 - 130,000
Senior Data Engineer
Senior Data Engineer

Intrepid Direct Insurance • Overland Park (KS)

On-site
USD 100,000 - 130,000
Data Engineer: Build Scalable Data Pipelines & Models
Data Engineer: Build Scalable Data Pipelines & Models

Berkley Technology Services LLC • Overland Park (KS)

On-site
USD 95,000 - 130,000
Data Engineer III – Data Operations & Infrastructure
Data Engineer III – Data Operations & Infrastructure

ICW Group • San Diego (CA)

On-site
USD 122,000 - 218,000
Bonus potential
Paid Time Off
401K with company match
Data Engineer III – Data Operations & Infrastructure
Data Engineer III – Data Operations & Infrastructure

ICW Group • Baxter Village (SC)

On-site
USD 122,000 - 218,000
Challenging work environment
Competitive benefits package
Bonus potential
+1
238 AVP, Senior Data Engineer
238 AVP, Senior Data Engineer

Dataspace • Chicago (IL), New York (NY)

Remote
USD 160,000 - 200,000
401k with 5% match
Unlimited PTO
Data Engineer
Data Engineer

Intrinsic • Colorado Springs (CO)

On-site
USD 95,000 - 160,000
401(k)
401(k) matching
Dental insurance
+5
Intermediate Data Engineer
Intermediate Data Engineer

Progressive Insurance • United States

Remote
USD 98,000 - 109,000
401(k) match
Medical, dental & vision
Wellness programs
+4
Senior Data Engineer (Contract To Hire)
Senior Data Engineer (Contract To Hire)

Tier4Group • United States

On-site
USD 120,000 - 180,000