> Markdown version of [/jobs/ext/1953299-senior-data-engineer](https://www.wearedevelopers.com/jobs/ext/1953299-senior-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior Data Engineer

- **Company:** Mgic Investment Corporation
- **Location:** Milwaukee, WI, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Application Programming Interfaces (APIs), Agile Methodology, Artificial Intelligence, Airflow, Amazon Web Services, Amazon S3, Data Analysis, ARM Architecture, Automation of Tests, Code Review, Information Systems, Databases, Continuous Integration, Directed Acyclic Graph (Directed Graphs), Information Engineering, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Dimensional Modeling, Identity and Access Management, Python (Programming Language), Shell Script, SQL Databases, Macros, Snowflake, Git Flow, Information Technology, Data Analytics, Functional Programming
- **Published:** August 6, 2026
- **Apply:** https://us.experteer.com/career/view-jobs/senior-data-engineer-milwaukee-wi-usa-58814375

## About the Role

Airflow workflows on Astronomer; manage dependencies, retries, alerts, and backfills * Implement observability and data-quality controls across ingestion, orchestration, and transformation layers * Partner with business, analytics, architecture, security, and engineering teams to translate requirements into durable data products and a long-term platform roadmap * Deliver changes via Git workflows, automated tests, code reviews, and CI/CD across dbt and Airflow * Troubleshoot data and pipeline issues across source systems, Fivetran, Astronomer, dbt, Snowflake, and downstream layers * Evaluate Cortex Code capabilities and plan AI-assisted engineering adoption with governance and security guardrails * Lead design and code reviews, share best practices, and mentor junior data engineers Tasks * Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or relevant experience * 5+ years data engineering experience with cloud data warehousing, dimensional aaaaaa
and ETL/ELT, analytics enablement, and production pipeline support * Hands-on Snowflake experience with SQL, data loading/transformation, and cost-conscious operation * Production-grade dbt projects with modular models, tests, docs, lineage, incremental models, macros, packages, and CI/CD * Experience building Airflow DAGs and familiarity with Astronomer or managed Airflow platforms * Experience implementing managed ELT with Fivetran, including connectors and schema evolution * Strong Python and SQL; API, data formats, shell scripting, and Git workflows * Experience with AWS services (S3, Lambda, IAM) and Agile / end-to-end automation * Knowledge of Cortex Code or willingness to adopt AI-assisted development with governance and security * Strong communication, problem-solving, and collaboration skills and ability to mentor others Key requirements * Competitive Salary & pay-for-performance bonus * 401k with company match, profit sharing, HSA, wellness program * On-site Fitness Center and
classes * Paid-time off and paid holidays * Business casual dress

## Description

Experteer Overview Join MGIC to help build the next generation data platform as part of the Data & Analytics team. You will design and deliver a Snowflake-centered data platform with automated ingestion, analytics-ready transformations, and robust orchestration. This role combines engineering excellence with governance and observability to deliver trusted data for stakeholders. You'll shape the platform roadmap and collaborate across business, security, and engineering teams to drive a data-driven transformation. Compensation / Benefits * Define and evolve data integration frameworks and governance for a modern cloud data platform * Design scalable Snowflake architectures (databases, schemas, warehouses, access controls) and optimize cost/performance * Build and operate batch and incremental ingestion with Fivetran; manage schema changes and monitoring * Develop modular dbt models with tests, documentation, lineage, and incremental strategies * Author, schedule, deploy, and monitor Airflow workflows on Astronomer; manage dependencies, retries, alerts, and backfills * Implement observability and data-quality controls across ingestion, orchestration, and transformation layers * Partner with business, analytics, architecture, security, and engineering teams to translate requirements into durable data products and a long-term platform roadmap * Deliver changes via Git workflows, automated tests, code reviews, and CI/CD across dbt and Airflow * Troubleshoot data and pipeline issues across source systems, Fivetran, Astronomer, dbt, Snowflake, and downstream layers * Evaluate Cortex Code capabilities and plan AI-assisted engineering adoption with governance and security guardrails * Lead design and code reviews, share best practices, and mentor junior data engineers Tasks * Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or relevant experience * 5+ years data engineering experience with cloud data warehousing, dimensional modeling, ETL/ELT, analytics enablement, and production pipeline support * Hands-on Snowflake experience with SQL, data loading/transformation, and cost-conscious operation * Production-grade dbt projects with modular models, tests, docs, lineage, incremental models, macros, packages, and CI/CD * Experience building Airflow DAGs and familiarity with Astronomer or managed Airflow platforms * Experience implementing managed ELT with Fivetran, including connectors and schema evolution * Strong Python and SQL; API, data formats, shell scripting, and Git workflows * Experience with AWS services (S3, Lambda, IAM) and Agile / end-to-end automation * Knowledge of Cortex Code or willingness to adopt AI-assisted development with governance and security * Strong communication, problem-solving, and collaboration skills and ability to mentor others Key requirements * Competitive Salary & pay-for-performance bonus * 401k with company match, profit sharing, HSA, wellness program * On-site Fitness Center and classes * Paid-time off and paid holidays * Business casual dress


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews)
- [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Why Git Still Matters](https://www.wearedevelopers.com/videos/100288-why-git-still-matters)
- [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment)

## Related Articles

- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)
- [Dev Digest 132 - Binging WADFlix?](https://www.wearedevelopers.com/magazine/473-dev-digest-132-binging-wadflix)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline)
- [Dev Digest 162: AI careers, MCP, AWS best practices & floppy sweaters](https://www.wearedevelopers.com/magazine/571-dev-digest-162-ai-careers-mcp-aws-best-practices-floppy-sweaters)