A complete application in a minute
Tailored resume and cover letter, ready to send.
MGT Insurance is seeking a data-focused engineer to own end-to-end data pipelines and the warehouse that powers reporting for Finance, Actuarial, Underwriting, and more. The role emphasizes agentic workflows, strong SQL, and production reliability in a hybrid setting.
You'll design transformation models, maintain ingestion services, and collaborate across teams to deliver governed data with quality checks and clear definitions.
MGT is the first AI-driven, neo-insurer focused on evolving commercial P&C insurance for the brokers and small business owners. By combining the expertise of industry veterans with state-of-the-art technology, we are ushering in the next evolution of commercial insurance and working to move the industry forward through the use of modern technology, better processes, and a rock-star team. We seek visionary leaders who thrive in dynamic, entrepreneurial settings, and excel in autonomous roles.
MGT runs its reporting on a cloud data warehouse that turns raw policy administration data into the numbers the business relies on including premium, exposure, and statutory reporting. You'll own those pipelines end to end: ingestion from our policy administration systems, the transformation layers that model the data, and the governed tables that Finance, Actuarial, Underwriting, and Reinsurance report from.
This role sits at the integration layer bringing together policy administration systems, rating engines, and third-party sources into one trusted warehouse that powers reporting across the company. There's no separate QA function here. The person who builds the model is the person who proves it ties out. You'll have real autonomy over how the warehouse evolves, and direct visibility with the leaders who depend on it.
Design, build, and maintain the SQL transformation models that carry data from raw ingestion through to the reporting layer
Maintain and extend the ingestion services that pull from our source systems, and keep them running reliably in production
Keep an eye on warehouse cost, performance, and reliability
Model the insurance domain - policy lifecycle, premium, coverages, limits, and exposure - at the grain the business needs to report on
Document data definitions, business logic, and the decisions behind them
Build the agentic data quality controls that sit alongside every model, and make sure they'd actually catch a regression
Reconcile what you build against an authoritative source, and explain any variance rather than smoothing it over
Work with Finance, Actuarial, Underwriting, and Product to turn ambiguous requests into reliable, repeatable data products
Support the BI layer and the analysts who build on top of your work
Governed sources only - there's a defined path from raw data to reporting, and we use it
Every model carries its own tests - controls ship with the code, not after it
Small, clean pull requests
Write things down - hard-won knowledge belongs in the repo, not in someone's head
Hybrid (minimum 3 days a week in office) Denver, CO, Madison, WI, or San Francisco, CA preferred, to facilitate close collaboration with the team.
The base salary range for this role is $150,000 - $200,000 annually . Compensation will depend on qualifications, experience, and location. This role is also eligible for performance-based bonus and equity, in addition to a comprehensive benefits package.
We recognize that no candidate will meet every qualification and encourage individuals with relevant experience and interest in the role to apply.
Please note: MGT does not accept unsolicited resumes from staffing vendors, including recruitment agencies and/or search firms.