Data Engineer III

About the role

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. Perform other duties as assigned.

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
• Making data flow robust and scalable
• 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

Data Generalist Component

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

Required Qualifications

• Bachelor's degree or equivalent experience in related field
• 5 years of work experience beyond degree
• Proficient use of SQL and Python

Preferred Qualifications

• Experience working in cloud-based environments, ideally using snowflake

Office Role

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

Compensation and Benefits

• The full salary grade for this position is $100,300 - $172,000.
• 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.

Eligibility to Work in the US

All candidates must be legally authorized to work in the United States at the time of application. 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.