Enterprise Data Engineer

Location: Avera Downtown Building-Sioux Falls Worker Type: Regular Work Shift: Day Shift (United States of America) Pay Range: The pay range for this position is listed below. Actual pay rate dependent upon experience. $73,840.00 - $111,800.00 Position Highlights Candidate must live in the Sioux Falls, SD area/Avera Footprint. You Belong at Avera Be part of a multidisciplinary team built with compassion and the goal of Moving Health Forward for you and our patients. Work where you matter. A Brief Overview The Data Engineer is focused on supporting the design, development, and maintenance of data systems and pipelines under the guidance of senior engineers. This position involves assisting in the collection, processing, and storage of data from various sources to ensure its availability for analysis and reporting. The role also includes supporting data validation and maintaining data quality within the data lake and data warehouse. What you will do Design and develop data systems such as data warehouse and data lake. Assist in developing and maintaining ETL processes. Support building data pipelines to collect and move data from source systems to storage platforms. Help with data cleaning and preprocessing to ensure high data quality. Monitor and troubleshoot data pipeline performance and address issues as they arise. Maintain system logs and ensure the smooth operation of data processes. Assist with maintaining and upgrading existing data infrastructure, including databases and data warehouses. Work closely 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. Essential Qualifications The individual must be able to work the hours specified. To perform this job successfully, an individual must be able to perform each essential job function satisfactorily including having visual acuity adequate to perform position duties and the ability to communicate effectively with others, hear, understand and distinguish speech and other sounds. These requirements and those listed above are representative of the knowledge, skills, and abilities required to perform the essential job functions. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions, as long as the accommodations do not cause undue hardship to the employer. Required Education, License/Certification, or Work Experience: Bachelor's in computer science, analytics, mathematics, business, or related fields 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 like SQL Server. Strong Understanding of SQL for querying and manipulating relational databases. Exposure to data processing tools and frameworks - both on-premises and cloud based. (PySpark, ETL, tools, SSIS, Azure Data Factory, etc.) Ability to collaborate effectively with cross-functional teams, such as data scientists, analysts, and other engineers. Strong attention to detail and ability to follow standard operating procedures. Familiarity with cloud-based platforms like Databricks (AWS,Azure,GCP). Willingness to learn and develop skills in data engineering technologies. Preferred Education, License/Certification, or Work Experience: Heath care experience, with preference to Epic Electronic Health Record system. Expectations and Standards Commitment to the daily application of Avera's mission, vision, core values, and social principles to serve patients, their families, and our 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, coordinating work flow 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. Benefits You Need & Then Some Avera is proud to offer a wide range of benefits to qualifying part-time and full-time employees. We support you with opportunities to help live balanced, healthy lives. Benefits are designed to meet needs of today and into the future. PTO available day 1 for eligible hires. Up to 5% employer matching contribution for retirement Career development guided by hands-on training and mentorship Avera is an Equal Opportunity Employer - Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, Veteran Status, or other categories protected by law. If you are an individual with a disability and would like to request an accommodation for help with your online application, please call View phone number on click.appcast.io or send an email to View email address on click.appcast.io. Avera Health