Data Engineer II

Medica
Madison, MN
Job Description
Medica is a nonprofit health plan with more than a million members that serves communities in Minnesota, Nebraska, Wisconsin, Missouri, and beyond. We deliver personalized health care experiences and partner closely with providers to ensure members are genuinely cared for. Join us in creating a community of connected care, where coordinated, quality service is the norm and every member feels valued.

Requirements

  • Design, build, implement, and maintain data storage structures and processing pipelines for the extraction, transformation, and loading (ETL) of data from a variety of data sources.
  • Develop robust and scalable solutions that transform data into a useful format for analysis, enhance data flow, and enable efficient, cost effective consumption and analysis of data.
  • Write complex SQL queries to support analytics needs.
  • Evaluate and recommend tools and technologies for data infrastructure and processing.
  • Ensure data quality, integrity, and security across all stages of the data lifecycle.
  • Collaborate with team members and stakeholders to define data requirements and translate them into technical specifications.
  • Monitor and optimize performance of data systems and ETL processes.
  • Support the deployment and maintenance of data infrastructure in cloud environments.
  • Develop and maintain complex SQL scripts and stored procedures for data transformation and reporting.
  • Leverage Informatica IDMC for cloud-native data integration, data quality, and governance workflows.

Benefits

  • Competitive medical, dental, vision, PTO, Holidays, paid volunteer time off
  • 401K contributions
  • Caregiver services
  • Other benefits
]]>