Senior Data Engineer

Responsibilities

• Aid in 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 processes.
• 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.
• Ensure 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.
• Assume other tasks and duties as assigned by management.
• Mentor team members and advise on best practices.

Qualifications

• Bachelor’s degree in Mathematics, Statistics, Computer Science, or equivalent experience.
• 6+ years of relevant data engineering experience.
• An 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 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.