Data Engineer

The Data Engineer at Avera Health in Sioux Falls, SD supports the end-to-end design, development, and maintenance of data systems and pipelines so data can be collected, processed, stored, validated, and used for analysis and reporting.

Responsibilities

• Design and develop data systems, including a data warehouse and a data lake.
• Assist with developing and maintaining ETL processes.
• Build data pipelines to collect data from source systems and move it to storage platforms.
• Support data cleaning and preprocessing to maintain high data quality.
• Monitor and troubleshoot data pipeline performance, addressing issues as they occur.
• Maintain system logs to support the 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 deliver solutions.
• Document data workflows, pipelines, and technical processes.
• Maintain clear and organized records for data sources and transformations.

Requirements

• 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 to 3 years of relevant experience.
• Knowledge of programming languages such as SQL and Python.
• Familiarity with relational databases such as 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 PySpark, ETL tools, 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 platforms such as Databricks and AWS, Azure, and 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 Qualifications

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

Benefits

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

Essential Qualifications

• Ability to work the hours specified.
• Ability to perform each essential job function 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.
• 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, provided accommodations do not cause undue hardship to the employer.

Expectations and Standards

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

Compensation and Location

Location: Sioux Falls, SD 57104 (onsite)

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

Minimum experience: 2 years