
Senior Data Engineer
HCV Underwriting Managers
full-time
Posted on:
Location Type: Hybrid
Location: United States
Visit company websiteExplore more
Job Level
Tech Stack
About the role
- Design and implement scalable data pipelines to ingest, transform, and store data from third-party vendors and internal systems using APIs, files, and databases.
- Build and maintain a cloud-based data warehouse solution in partnership with architects, ensuring clean, normalized, and performant data models.
- Establish and monitor reliable data ingestion processes across systems with varying grain and cadence, ensuring data quality and completeness.
- Collaborate with API and integration teams to develop secure, robust data exchange processes with external vendors and internal services.
- Set up and manage data connections from the warehouse to BI tools (e.g., Power BI, Looker, Tableau) to enable self-service analytics and dashboarding.
- Document data flows, schemas, and definitions, and help drive data governance and standardization efforts across the organization.
- Implement data validation, cleansing, and enrichment processes to ensure high-quality data for financial reporting and analytics.
- Ensure compliance with data standards, regulatory requirements (e.g., NAIC, SOX), and data security best practices.
- Provide technical leadership in data engineering best practices, including version control, CI/CD for data pipelines, testing, and observability.
- Build initial dashboards in BI tools.
- Give directions to data engineers to ensure that projects are completed on time and to a high standard.
Requirements
- 5+ years of experience in data engineering, data warehousing, or a related field with at least 1-2 years leading implementation projects.
- 3+ years of experience in the commercial insurance industry.
- Hands on experience with Azure data services.
- Strong SQL and performance tuning skills in Microsoft SQL Server environments.
- Experience designing data warehouses or data marts with a focus on dimensional modeling and analytics-ready schemas.
- Fluent in range of data ingestion: RESTful APIs, JSON/XML ingestion, flat files, message queues, and CDC patterns.
- Understanding of data governance, metadata management, and access control.
- Familiarity with version control (GitLab) and CI/CD pipelines for data workflows.
- Experience working with BI tools like Power BI, Looker, or Tableau, including building dashboards or semantic layers.
- Bachelor’s degree in Computer Science, Engineering, Information Systems, or equivalent experience.
- Demonstrated ability to translate business needs into scalable data systems and design.
Benefits
- Remote First Work Environment (US Based)
- Medical, Dental, Vision
- 401K, 401K Match
- Life and Disability Benefits
- Unaccrued Paid Time Off
- 11 Paid Holidays
- Employee Discounts
- Employee Assistance Program
- Educational Assistance Program
- Employee Referral Program
- Paid Parental Leave
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data engineeringdata warehousingSQLperformance tuningdimensional modelingdata ingestiondata validationdata cleansingdata governancemetadata management
Soft Skills
technical leadershipcollaborationproject managementcommunicationdirection giving
Certifications
Bachelor’s degree in Computer ScienceBachelor’s degree in EngineeringBachelor’s degree in Information Systems