Job Summary:
Intrepid Direct Insurance is a rapidly growing direct to consumer property and casualty insurance company. They are seeking a Senior Data Engineer to mentor and implement data solutions that enhance the availability and quality of data for their business units and customers.
Responsibilities:
โข 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.
Qualifications:
Required:
โข 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.
โข 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.
Preferred:
โข Experience with insurance data highly desired.
โข Experience with Power Bi desired.
Company:
Intrepid Direct Insurance is a leading direct property and casualty provider for franchise businesses. Founded in 2016, the company is headquartered in Overland Park, USA, with a team of 51-200 employees. The company is currently Growth Stage.