Senior Data Engineer
MGIC Investment Corporation3 months ago
Milwaukee, WI, USASenior
Base Salary
$106k - $180k/yr
Responsibilities
- Define data integration frameworks, engineering standards, reusable patterns, and governance practices for a modern cloud data platform.
- Design scalable Snowflake architectures and optimize performance, access controls, and costs.
- Build and operate batch and incremental ingestion pipelines using Fivetran, including monitoring, troubleshooting, and schema-change handling.
- Develop modular dbt models with tests, documentation, lineage, incremental strategies, macros, and packages.
- Author, deploy, schedule, and monitor Apache Airflow workflows on Astronomer with effective recovery and alerting practices.
- Implement observability and data-quality controls across ingestion, orchestration, and transformation layers.
- Partner with business, analytics, architecture, security, and engineering teams to deliver data products and a long-term platform roadmap.
- Use Git-based development, automated testing, code review, and CI/CD practices across dbt and Airflow projects.
- Troubleshoot issues across source systems, Fivetran, Astronomer, dbt, Snowflake, and downstream consumption layers.
- Evaluate Cortex Code and lead a governed, phased adoption plan for AI-assisted engineering.
- Lead design and code reviews, share engineering practices, and mentor junior data engineers.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or relevant experience.
- At least 5 years of data engineering experience, including cloud data warehousing, dimensional data modeling, ETL/ELT, analytics enablement, and production pipeline support.
- Hands-on Snowflake experience with advanced SQL, data loading and transformation, warehouse sizing, query optimization, access controls, and cost-conscious operations.
- Production-grade dbt experience with modular models, tests, documentation, source freshness, incremental models, macros, packages, and CI/CD.
- Experience developing and operating Apache Airflow DAGs and familiarity with Astronomer or another managed Airflow platform.
- Experience implementing and supporting managed ELT with Fivetran, including connector setup, synchronization, schema evolution, monitoring, and issue resolution.
- Strong Python and SQL skills, plus experience with APIs, data formats, shell scripting, and Git-based workflows.
- Experience with AWS services such as S3, Lambda, and IAM, along with end-to-end automation practices.
- Knowledge of Cortex Code and AI-assisted software development, or the ability to create a responsible adoption plan with security, governance, testing, and change-management controls.
- Strong communication, problem-solving, collaboration, technical influence, and mentoring skills.
Benefits
- Competitive salary and pay-for-performance bonus.
- 401(k) with company match, profit sharing, HSA, and wellness program.
- On-site fitness center and classes at the corporate office.
- Paid time off and paid company holidays.
- Business casual dress.
About MGIC Investment Corporation
MGIC Investment Corporation provides private mortgage insurance to mortgage lenders, helping them originate low‑down‑payment home loans while managing credit risk and meeting secondary‑market requirements. It earns premiums on loan‑level coverage and offers underwriting tools and risk insights to banks, credit unions, and mortgage bankers across the U.S. and Puerto Rico. Founded in 1957 and headquartered in Milwaukee, it is a public company listed on the NYSE and operates through its MGIC subsidiary.