Tech Lead/Data Engineer III

Medica • Minnetonka, MN

11h • Hybrid

About The Position

Medica is seeking an experienced Tech Lead/Data Engineer III. This role is ideal for an innovative and strategic thinker with a depth of experience in enterprise data and broader cloud-based data engineering initiatives. This individual is someone who thrives in a mission-driven, healthcare-focused organization and is passionate about ensuring efficiency, scalability, financial integrity and compliance. Key Responsibilities: 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 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. Key Accountabilities: 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. Automating data workflows using scripting languages such as Python or R. Supporting business intelligence initiatives and translating data into strategic recommendations. Documenting data processes and contributing to data governance standards. Applying AI and machine learning techniques to enhance predictive analytics, automate decision-making, and uncover deeper insights from complex datasets. Utilizing preferred AI tools and platforms such as TensorFlow, Azure Machine Learning, scikit-learn, and PyTorch to build and deploy models that support enterprise analytics and innovation.

Requirements

• Bachelor's degree or equivalent experience in related field
• 5 years of related work experience beyond the degree
• Proficient use of SQL
• Microsoft Certified: (or equivalent cloud) Azure Data Engineer
• Microsoft Certified: Azure Fundamentals
• Snowflake SnowPro Core Certification
• Snowflake Advanced Architect Certification

Nice To Haves

• Healthcare industry experience is desired

Responsibilities

• 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.
• 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.
• Automating data workflows using scripting languages such as Python or R.
• Supporting business intelligence initiatives and translating data into strategic recommendations.
• Documenting data processes and contributing to data governance standards.
• Applying AI and machine learning techniques to enhance predictive analytics, automate decision-making, and uncover deeper insights from complex datasets.
• Utilizing preferred AI tools and platforms such as TensorFlow, Azure Machine Learning, scikit-learn, and PyTorch to build and deploy models that support enterprise analytics and innovation.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level