Enterprise Data Engineer

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., * 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

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., * 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.

Avera is an Equal Opportunity/Affirmative Action Employer: Minority/Female/Disabled/Veteran/Sexual Orientation/Gender Identity.