Job description

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. intrepiddirect.com The Company is an equal employment opportunity employer. Intrepid Direct Insurance is looking for an experienced Senior Data Engineer to mentor, orchestrate, implement, and monitor the flowing through our organization. This opportunity will have a direct influence on how data is made available to our business units, as well as our customers. You’ll primarily be working with our operations and engineering teams to create and enhance data pipelines, conform and enrich data, and deliver information to business users. Learn the ins and outs of what we do so that you can focus on improving availability and quality of the data we use to service our customers. Key functions include but are not limited to: • Assist with long-term strategic planning for modern data warehousing needs. • Contribute to data modeling exercises and the buildout of our data warehouse. • Monitor, support, and analyze existing pipelines and recommend performance and process improvements to address gaps in existing process. • Automate manual processes owned by data team. • Troubleshoot and remediate ingestion and reporting related issues. • Design and build new pipelines to ingest data from additional disparate sources. • Responsible for the accuracy and availability of data in our data warehouse. • Collaborate with a multi-disciplinary team to develop data-driven solutions that align with our business and technical needs. • Create and deploy reports as needed. • Assist with cataloging and classifying existing data sets. • Participate in peer reviews with emphasis on continuous improvement. • Respond to regulatory requests for information. • Assumes other tasks and duties as assigned by management. • Mentor team members and advise on best practices. • Bachelor’s degree in Mathematics, Statistics, Computer Science, or equivalent experience. • 6+ 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. Important Outside Agency Notice: Only solicited resumes/candidate profiles that are submitted by a Berkley Preferred Agency Partner that have been requested by Berkley Internal Recruiting to engage in a particular search will be subject to the payment of Agency fees as defined in the formal agency agreement. Any unsolicited resumes/candidate profiles are not subject to payment of the agency fees. We do not accept unsolicited resumes from third party recruiting agencies or firms. The company offers a competitive compensation plan and robust benefits package for full-time regular employees. 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 not Offered for this Role Not ready to apply? Connect with us for general consideration.

Requirements

Must-haves

The Company is an equal employment opportunity employer.
Key functions include but are not limited to:
Assist with long-term strategic planning for modern data warehousing needs.
Contribute to data modeling exercises and the buildout of our data warehouse.
Monitor, support, and analyze existing pipelines and recommend performance and process improvements to address gaps in existing process.
Automate manual processes owned by data team.
Troubleshoot and remediate ingestion and reporting related issues.
Design and build new pipelines to ingest data from additional disparate sources.
Responsible for the accuracy and availability of data in our data warehouse.
Collaborate with a multi-disciplinary team to develop data-driven solutions that align with our business and technical needs.
Create and deploy reports as needed.
Assist with cataloging and classifying existing data sets.
Participate in peer reviews with emphasis on continuous improvement.
Respond to regulatory requests for information.
Assumes other tasks and duties as assigned by management.
Mentor team members and advise on best practices.
Bachelor’s degree in Mathematics, Statistics, Computer Science, or equivalent experience.
6+ 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.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlagile

Platform: icims
Effort: medium

Benefits

Benefits detected in the listing.

Vision