MGIC logo
MGICPosted 3 weeks ago

Senior Data Engineer

$105,590–$179,510 year

HybridMilwaukee, Wisconsin, United States

Full TimeSenior LevelMedium

Job Summary

Design and deliver a Snowflake-centered data platform, automating source-to-warehouse ingestion with Fivetran and developing analytics-ready transformations with dbt. Orchestrate production workflows using Apache Airflow on Astronomer, implementing observability and data-quality controls across ingestion, orchestration, and transformation layers. Define engineering standards, reusable patterns, and governance practices while partnering with business, analytics, and security teams to translate requirements into durable data products. Evaluate Cortex Code capabilities and lead the development of a practical adoption plan for incorporating AI-assisted engineering into solution delivery processes.

Required Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or relevant experience
  • 5 or more years of data engineering experience, including cloud data warehousing, dimensional data modeling, ETL/ELT, analytics enablement, and production pipeline support
  • Hands-on Snowflake experience, including advanced SQL, data loading and transformation, virtual warehouse sizing, query optimization, access controls, and cost-conscious platform operation
  • Experience building production-grade dbt projects with modular models, tests, documentation, source freshness, incremental models, macros, packages, and CI/CD
  • Experience developing and operating Apache Airflow DAGs; familiarity with Astronomer or another managed Airflow platform, including deployment, monitoring, alerting, and troubleshooting
  • Experience implementing and supporting managed ELT with Fivetran, including connector setup, incremental synchronization, schema evolution, monitoring, and issue resolution
  • Strong Python and SQL skills; experience with APIs, data formats, shell scripting, and Git-based development workflows
  • Experience with AWS services such as S3, Lambda, IAM, and related cloud data services, plus Agile delivery and end-to-end automation practices
  • Knowledge of Cortex Code and AI-assisted software development practices, or demonstrated willingness and ability to build a responsible adoption plan that integrates the technology into solution delivery processes while maintaining security, governance, code-review, testing, and change-management standards
  • Strong communication, problem-solving, and collaboration skills, with the ability to influence technical decisions and mentor other engineers

Hiring someone like this?

Get your role in front of qualified candidates on Sorce.

Get started

Apply to this job in one click with Sorce

Apply on Sorce