Senior Data Engineer

Senior Data Engineer –
Intrepid Direct Insurance

Intrepid Direct Insurance (IDI) is a direct-to-consumer property and casualty company and a wholly owned subsidiary of W. R. Berkley Corporation, a Fortune 500, A+ rated by A.M. Best. Our vision is to make life better for business by leveraging data and technology to serve customers, shareholders and our team members. We are an equal employment opportunity employer.

• Mentor, orchestrate, implement, and monitor data flow throughout the organization and directly influence how data is made available to business units and customers.
• Work with operations and engineering teams to create and enhance data pipelines, conform and enrich data, and deliver information to business users.
• Assist with long-term strategic planning for modern data warehousing needs.
• Contribute to data modeling exercises and buildout of the data warehouse.
• Monitor, support and analyze existing pipelines and recommend performance and process improvements.
• Automate manual processes owned by the data team.
• Troubleshoot and remediate ingestion and reporting related issues.
• Design and build new pipelines to ingest data from additional disparate sources.
• Ensure data accuracy and availability in the data warehouse.
• Collaborate with a multi‑disciplinary team to develop data‑driven solutions aligned with 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.
• 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; preference for Data Vault methodology.
• Experience supporting and troubleshooting SSIS packages.
• Experience consuming event‑based data through APIs or queues.
• Experience with Agile software development.
• Insurance data experience highly desired.
• Detail oriented, solid organizational, and problem‑solving skills.
• 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.

Sponsorship not offered for this role.