Data Engineer II
About The Position
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. We're a team that owns our work with accountability, makes data-driven decisions, embraces continuous learning, and celebrates collaboration — because success is a team sport. It's our mission to be there in the moments that matter most for our members and employees. Join us in creating a community of connected care, where coordinated, quality service is the norm and every member feels valued. 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. Performs other duties as assigned.
Requirements
- Bachelor's degree or equivalent experience in related field
- 3 years of work experience beyond degree
- Proficiency writing complex SQL and Python queries.
Nice To Haves
- Understanding of system design principle and data storage structures, ideally in a cloud-based environment (Azure, SnowPro, Snowflake).
- Preferred certifications in: Microsoft Certified: (or equivalent cloud) Azure Data Engineer
- Experience in healthcare, insurance, or other regulated industries.
- Knowledge of security, privacy, and compliance frameworks (e.g., HIPAA).
- Strong understanding of systems, data governance standards and hierarchies
Responsibilities
- Participate on teams that are designing and implementing scalable data pipelines and storage solutions to support enterprise analytics.
- Ensuring data quality, integrity, and security across all stages of the data lifecycle.
- Collaborating with team members and stakeholders to define data requirements and translate them into technical specifications.
- Monitoring and optimizing performance of data systems and ETL processes.
- Supporting the deployment and maintenance of data infrastructure in cloud environments.
- Developing and maintaining complex SQL scripts and stored procedures for data transformation and reporting.
- Leveraging 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
Associate degree
