Sr. Data Engineer, EDM

Medica; Minnetonka (MN); On-site; USD 100,000 - 150,000; Full time

Benefits offered by this job

Competitive medical, dental, vision

PTO and holidays

401K contributions

Job summary

Medica is seeking an experienced Data Engineer to advance healthcare data from Bronze to Silver using Snowflake and CIM standards. You will collaborate with data engineers, analysts, and business experts to interpret source data, document rules, resolve data-quality issues, and make high-value information available organization-wide.

The role emphasizes data quality, automated testing, and scalable transformations across ingestion, transformation, and consumption layers, with onsite Minnetonka

Qualifications

• Bachelor's degree or equivalent experience in a related field.
• 7+ years of work experience beyond degree.
• Significant experience in software/data engineering, data integration, data warehousing.
• Advanced SQL skills with large, complex datasets.
• Experience designing and implementing ETL/ELT pipelines.
• Experience with dimensional/relational/enterprise data modeling.

Responsibilities

• Design, develop, test, and support scalable data pipelines within Snowflake.
• Standardize raw data into Silver-layer models aligned with CIM.
• Analyze source data, rules, and processing behavior.
• Translate healthcare data knowledge into durable transformation logic and data-quality controls.
• Develop reusable data models supporting analytics, reporting, and workflows.
• Profile data to identify quality problems and discrepancies between sources.
• Validate data meaning and transformation rules with subject-matter experts.
• Establish automated reconciliation, validation, observability, and tests.
• Investigate production issues and resolve defects across layers.

Skills

Advanced SQL

ETL/ELT pipelines

Data modeling

Snowflake

dbt

Python

Data quality

Problem solving

Communication

Education

Bachelor's degree or equivalent experience

Tools

Snowflake

dbt

Python

CI/CD practices

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.

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.

Role Summary

In this role, you will work with healthcare data ingested into Medica's Snowflake platform and lead its progression from raw Bronze-layer structures into standardized Silver-layer models aligned with Medica's Common Information Model (CIM). You will partner with data engineers, architects, analysts, and business subject-matter experts to interpret source data, document business rules, resolve data-quality issues, and make high-value information available across the organization.

The ideal candidate combines strong data engineering skills with a practical understanding of healthcare data and business processes. Experience with claims, membership, enrollment, providers, billing, care management, or related health plan subject areas is especially valuable.

Key Accountabilities

• Design, develop, test, and support scalable data pipelines and transformations within Snowflake.
• Standardize raw source data into well-defined Silver-layer data models aligned with Medica's CIM standards.
• Analyze complex source data, relationships, business rules, and processing behavior.
• Translate healthcare data knowledge into durable transformation logic, documentation, and data-quality controls.
• Develop and maintain reusable data models that support analytics, reporting, operational workflows, and downstream applications.
• Profile data and identify quality problems, unexpected patterns, missing relationships, and discrepancies between source systems.
• Work with subject-matter experts to validate data meaning, transformation rules, and expected outcomes.
• Establish automated reconciliation, validation, observability, and testing practices.
• Investigate production issues and resolve defects across ingestion, transformation, and consumption layers.
• Contribute to data architecture, modeling, engineering standards, design reviews, and technical decision-making.
• Provide technical guidance to other engineers and help improve team engineering practices.
• Document data lineage, definitions, transformation logic, dependencies, and operational procedures.
• Collaborate across engineering, architecture, analytics, governance, and business teams.

Required Qualifications

• Bachelor's degree or equivalent experience in related field
• 7+ years of work experience beyond degree
• Significant professional experience in software engineering, data engineering, data integration, data warehousing, or a related discipline.
• Advanced SQL skills and experience working with large, complex datasets.
• Experience designing and implementing ETL or ELT pipelines.
• Experience with dimensional, relational, or enterprise data modeling.

Skills and Attributes

• Ability to interpret unfamiliar source data and convert it into standardized, business-meaningful models.
• Experience implementing data-quality checks, reconciliation processes, automated tests, and production monitoring.
• Strong troubleshooting skills across interconnected data pipelines and systems.
• Ability to communicate effectively with both technical and nontechnical partners.
• Demonstrated ability to work independently, manage ambiguity, and lead complex technical work.
• Strong analytical thinking and attention to detail.
• Curiosity about how data is created, processed, and used.
• Ability to distinguish source-system behavior from enduring business meaning.
• Comfort working across technical and business domains.
• Pragmatic approach to balancing delivery, maintainability, and data quality.
• Strong ownership mindset and commitment to reliable production outcomes.

Preferred Qualifications

• Experience with Snowflake and cloud-based data platforms.
• Experience using dbt or comparable SQL-based transformation frameworks.
• Knowledge of medallion architecture, including Bronze, Silver, and Gold data layers.
• Experience with Python, orchestration platforms, source control, automated deployment, and CI/CD practices.
• Experience working with healthcare payer or health insurance data.
• Knowledge of healthcare subject areas such as claims and encounters; membership and enrollment; providers and provider networks; benefits, products, and billing; care management and clinical programs; eligibility and accumulators; or electronic data interchange.
• Experience interpreting data from healthcare administration or core processing platforms.
• Familiarity with healthcare data governance, privacy, security, and regulatory expectations.
• Experience developing canonical, common-information, or enterprise data models.
• Experience mentoring engineers or serving as a technical lead while remaining hands‑on.

What Success Looks Like

• Complex source data is transformed into understandable, documented, and reusable data products.
• Silver-layer models accurately represent healthcare concepts and business rules.
• Data consumers can confidently find, understand, and use standardized data.
• Data-quality issues are detected early and resolved systematically.
• Transformation logic is tested, observable, maintainable, and traceable to its sources.
• The broader engineering team benefits from stronger standards, documentation, and technical leadership.

This position is an Office role, which requires an employee to work onsite at our Minnetonka, MN office, on average, 3 days per week.

The full salary grade for this position is $100,300 - $172,000. While the full salary grade is provided, the typical hiring salary range for this role is expected to be between $100,300 - $150,465. Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable certifications and/or licensure, the position's scope and responsibility, internal pay equity and external market salary data. In addition to base compensation, this position may be eligible for incentive plan compensation in addition to base salary. Medica offers a generous total rewards package that includes competitive medical, dental, vision, PTO, Holidays, paid volunteer time off, 401K contributions, caregiver services and many other benefits to support our employees.

The compensation and benefits information is provided as of the date of this posting. Medica's compensation and benefits are subject to change at any time, with or without notice, subject to applicable law.

We are an Equal Opportunity employer, where all qualified candidates receive consideration for employment indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws.

For further information, please review the Know Your Rights notice from the Department of Labor.