Job Description

Data Engineer – Specialty Insurance / MGA

Job Summary

Seeking a skilled and motivated Data Engineer to join a rapidly growing organization in the specialty insurance and Managing General Agent (MGA) space. This is an exciting opportunity to work in a high-growth environment, contributing to the development and scaling of data engineering and integration capabilities. The ideal candidate will play a key role in building data pipelines, integrating insurance systems, and enhancing data accessibility across the business.

Compensation Package

• Competitive salary commensurate with experience.
• Comprehensive benefits package, including health, dental, and vision insurance.
• Opportunities for professional development and career growth.
• Flexible work arrangements and a collaborative work environment.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines to support insurance operations, reporting, and analytics.
• Develop Python-based integrations and work with APIs to connect internal applications and third-party platforms.
• Build and optimize data pipelines and transformations using SQL and Snowflake.
• Integrate data from MGA management systems, policy administration platforms, carrier systems, and external vendors.
• Support data warehousing, data modeling, and data quality initiatives.
• Utilize Power BI to support reporting, analytics, and business intelligence needs.
• Troubleshoot data integration issues and enhance the efficiency, reliability, and scalability of existing processes.
• Collaborate with business and technical stakeholders to identify opportunities for automation and system improvements.

Qualifications/Requirements

Required:

• Proven experience in Data Engineering, ETL development, or data integration.
• Proficiency in Python and SQL.
• Experience developing and maintaining data pipelines and integrating data from multiple systems.
• Hands-on experience with APIs and third-party system integrations.
• Familiarity with Snowflake or comparable cloud data warehouse technologies.
• Strong problem-solving skills and the ability to work independently in a dynamic technical environment.

Preferred:

• Experience within the Property & Casualty insurance industry, particularly with MGAs, specialty insurance carriers, or insurance technology providers.
• Knowledge of Vertafore IMS or similar MGA management/policy administration systems.
• Proficiency in Power BI and experience with insurance reporting.
• Understanding of insurance data, including policies, premiums, underwriting, and bordereaux.
• Experience building or improving data infrastructure in a growing organization.

#LI-MC1