Data Engineer

The Data Engineer at Avera Health helps build and maintain the data systems and pipelines that support reliable collection, processing, storage, validation, and delivery of data for analytics and reporting. The role includes supporting ETL workflows, monitoring pipeline performance, and documenting data processes.

Location and Employment Details

Onsite: Sioux Falls, SD 57104

Salary: USD 73,840 - 123,240 per year

Minimum experience: 2 years

Role Summary

The Data Engineer supports the design, development, and maintenance of data systems and pipelines to ensure data is collected, processed, stored, validated, and available for analysis and reporting. This position assists with ETL, data quality, pipeline performance monitoring, documentation, and maintaining data infrastructure.

Key Responsibilities

• Design and develop data systems including a data warehouse and data lake.
• Assist with developing and maintaining ETL processes.
• Build data pipelines that collect and move data from source systems to storage platforms.
• Support data cleaning and preprocessing to improve data quality.
• Monitor and troubleshoot data pipeline performance and address issues as they arise.
• Maintain system logs and help ensure smooth operation of data processes.
• Assist with maintaining and upgrading existing data infrastructure, including databases and data warehouses.
• Collaborate with data scientists, analysts, and business stakeholders to understand data requirements and provide solutions.
• Document data workflows, pipelines, and technical processes.
• Maintain clear and organized records for data sources and transformations.

Required Qualifications

• Bachelor's degree in computer science, analytics, mathematics, business, or a related field (or an equivalent combination of education and work experience).
• At least 2-3 years of relevant experience.
• Knowledge of programming languages such as SQL and Python.
• Familiarity with relational databases including SQL Server.
• Strong understanding of SQL for querying and manipulating relational databases.
• Exposure to data processing tools and frameworks for both on-premises and cloud environments, including examples such as PySpark, ETL, SSIS, and Azure Data Factory.
• Ability to collaborate effectively with cross-functional teams, including data scientists, analysts, and other engineers.
• Strong attention to detail and ability to follow standard operating procedures.
• Familiarity with cloud-based platforms such as Databricks (AWS, Azure, GCP).
• Willingness to learn and develop skills in data engineering technologies.

Technologies

SQL, Python, SQL Server, PySpark, ETL, SSIS, Azure Data Factory, Databricks, AWS, Azure, GCP

Preferred Background

• Healthcare experience, with preference for experience using the Epic Electronic Health Record system.

Benefits

• PTO available day 1 for eligible hires.
• Up to 5% employer matching contribution for retirement.
• Career development guided by hands-on training and mentorship.

Essential Job Functions and Standards

• The individual must be able to work the hours specified.
• To perform the job successfully, the individual must be able to perform essential job functions satisfactorily, including visual acuity adequate to perform position duties and the ability to communicate effectively with others, hear, understand and distinguish speech and other sounds.
• The requirements listed are representative of the knowledge, skills, and abilities required to perform essential job functions.
• Reasonable accommodations may be made to enable individuals with disabilities to perform essential job functions as long as accommodations do not cause undue hardship.

Expectations and Standards:

• Commitment to the daily application of Avera’s mission, vision, core values, and social principles to serve patients, their families, and the community.
• Promote Avera’s values of compassion, hospitality, and stewardship.
• Uphold Avera’s standards of Communication, Attitude, Responsiveness, and Engagement (CARE) with enthusiasm and sincerity.
• Maintain confidentiality.
• Work effectively in a team environment by coordinating workflow with other team members and ensuring a productive and efficient environment.
• Comply with safety principles, laws, regulations, and standards associated with, but not limited to, CMS, The Joint Commission, DHHS, and OSHA if applicable.