Senior Data Engineer

MGT Insurance

. Design, build, and maintain SQL transformation models from raw ingestion through the reporting layer .

Posted 10/16/2026full-timeUnited StatesSenior💰 $150,000 - $200,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and maintaining SQL transformation models and production data pipelines, with a strong focus on data quality controls and integration within the insurance domain. Proficient in collaborating with cross-functional teams to deliver reliable data products and manage complex data workflows.

Highest-signal resume keywords

Strong SQL SkillsExperience With Cloud Data WarehousePython For Data ToolingP&C Insurance Domain KnowledgeWorkflow Orchestration Fundamentals

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQL Transformation FrameworkData Pipeline DevelopmentData Quality ControlsData ReconciliationAgentic-Driven Workflows

Soft Skills

Entrepreneurial MindsetAbility To Drive Projects To CompletionComfort In Fast-Paced Environment

Tools & Technologies

DataformDbtAirflowLookerGit

Industry Keywords

Insurance DomainPolicy LifecyclePremiumPolicy Administration SystemPost-M&A Data Integration

Tech Stack

Tools & technologies

AirflowCloudPythonSQL

About the role

Key responsibilities & impact

Design, build, and maintain SQL transformation models from raw ingestion through the reporting layer
Maintain and extend ingestion services pulling from source systems and keep them reliable in production
Monitor warehouse cost, performance, and reliability
Model the insurance domain, including policy lifecycle, premium, coverages, limits, and exposure
Document data definitions, business logic, and modeling decisions
Build agentic data quality controls alongside every model
Ensure quality controls catch regressions
Reconcile data against authoritative sources and explain variances
Work with Finance, Actuarial, Underwriting, and Product to turn ambiguous requests into reliable data products
Support the BI layer and analysts building on the data products
Build governed data pipelines integrating policy administration systems, rating engines, and third-party sources into a trusted warehouse

Requirements

What you’ll need

Experience with agentic-driven workflows and development
Several years building production data pipelines
Strong SQL skills
Experience with a cloud data warehouse
Experience with a SQL transformation framework such as Dataform, dbt, or equivalent
Python for data tooling and integrations
Comfort with APIs and semi-structured data
Git-based workflow including branches, pull requests, code review, and CI
Rigor about correctness and testing one's own work
Entrepreneurial mindset and ability to work independently
Ability to drive projects to completion
Comfort in a fast-paced environment with frequently changing priorities
P&C insurance domain knowledge, particularly around premium and policy lifecycle, preferred
Experience with a policy administration system such as Socotra, preferred
Workflow orchestration and cloud platform fundamentals; Airflow preferred
BI or semantic layer experience; Looker preferred
Post-M&A or cross-vendor data integration experience

Benefits

Comp & perks

Performance-based bonus
Equity
Comprehensive benefits package
Hybrid work arrangement