Senior Data Engineer
MGICAbout the role
At MGIC, we take pride in knowing that what we do matters. As pioneers of private mortgage insurance, we help people achieve homeownership sooner - making affordable low-down-payment mortgages a reality. Our efforts have helped more than 14 million people get the keys to their own homes sooner than otherwise possible. Every position is critical to our company's success - from the analytical to the technical; from the innovative to the operational. The customer-facing roles to behind-the-scenes experts, we're all part of one team. We're an organization with a national footprint that's large enough to never lack for a new challenge, but small enough for an opportunity to make an impact and influence decisions. Come make a difference at MGIC.
Summary:
We’re building great things at MGIC, and we are excited to be offering this position. This is an opportunity help us create the next generation data platform. Becoming Data-driven is at the core of our transformation – join us and help us build the future!
We are looking for a Senior Data Engineer who is passionate about building trusted, scalable data products with modern cloud technologies. As part of the Data & Analytics team, you will design and deliver a Snowflake-centered data platform, automate source-to-warehouse ingestion with Fivetran, develop analytics-ready transformations with dbt, and orchestrate production workflows with Astronomer and Apache Airflow.
Responsibilities:
Define and evolve data integration frameworks, engineering standards, reusable patterns, and governance practices for a modern cloud data platform.
Design scalable Snowflake data architectures, including databases, schemas, tables, views, virtual warehouses, role-based access, and approaches for performance and cost optimization.
Build and operate reliable batch and incremental ingestion pipelines using Fivetran connectors, including source configuration, schema-change handling, sync monitoring, troubleshooting, and custom connector patterns when needed.
Develop modular, maintainable dbt models in Snowflake; implement source definitions, tests, documentation, lineage, incremental strategies, and reusable macros.
Author, schedule, deploy, and monitor data workflows with Apache Airflow on Astronomer, applying effective dependency management, retry, alerting, backfill, and failure-recovery practices.
Implement observability and data-quality controls across ingestion, orchestration, and transformation layers so production data is accurate, timely, and available to stakeholders.
Partner with business, analytics, architecture, security, and engineering teams to translate requirements into durable data products and a long-term platform roadmap.
Deliver changes through Git-based development, automated testing, code review, and CI/CD practices across dbt and Airflow projects.
Troubleshoot data and pipeline issues across source systems, Fivetran, Astronomer, dbt, Snowflake, and downstream consumption layers.
Evaluate Cortex Code capabilities and lead the development of a practical adoption plan for incorporating AI-assisted engineering into solution delivery processes, including prioritized use cases, governance and security guardrails, developer workflows, enablement, success measures, and a phased rollout.
Lead design and code reviews, share engineering best practices, and m
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s