Sr. Data Engineer - SQL/Python

Medica is seeking an experienced Sr. Data Engineer with a background in extraction, transformation, and loading (ETL) of data from a variety of sources. These robust and scalable solutions that will support Medica's claims and financial platforms. This role is ideal for an innovative and highly technical thinker who thrives in a mission-driven, healthcare-focused organization and is passionate about ensuring efficiency, scalability, financial integrity and compliance.

The ideal candidate is a technical generalist with strong system design expertise and a proven ability to bridge strategy and execution across diverse technologies. Design, build, implement, and maintain data storage structures and processing pipelines for the extraction, transformation, and loading (ETL) of data from a variety of 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, including modern cloud platforms such as Snowflake, Azure, AWS, and data integration tools like Apache Airflow, dbt, Informatica Intelligent Data Management Cloud (IDMC), and distributed processing frameworks such as Apache Spark.

• 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 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.

In addition to engineering responsibilities, the Data Generalist component of this role includes:

• Performing exploratory data analysis and generating actionable insights.
• Creating dashboards and visualizations using tools like Power BI, Tableau, or Excel.
• Collaborating with cross-functional teams to align data efforts with business goals.

Qualifications:

• Bachelor's degree in computer science, Engineering, or related field desired, or equivalent work experience.
• 7+ years of experience in software engineering or technical architecture
• Strong understanding of system design principle and data storage structures, ideally in a cloud-based environment (Azure, SnowPro, Snowflake).
• Proficiency writing complex SQL or Python queries.
• Excellent collaboration and communication skills, with the ability to engage both technical teams and business stakeholders.

Preferred:

• Preferred certifications in:
  
  
  
  • Microsoft Certified: (or equivalent cloud )Azure Data Engineer
  • Microsoft Certified: Azure Fundamentals
  • Snowflake SnowPro Core Certification
  • Snowflake Advanced Architect Certification
  
  
  
  
• 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

This position is an Office role, which requires an employee to work onsite, on average, 3 days per week. We are open to candidates located near one of the following office locations: Minnetonka, MN, or Madison, WI

The full salary range for this position is $112,400 - $168,600. 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 compensation, 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 are 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.