[Remote] Caboodle ETL Developer I, II Epic-(Open to experienced remote in ID, NE, MO, OK, TX)

Note: The job is a remote job and is open to candidates in USA. PIH Health is a nonprofit, regional healthcare network that serves approximately 3 million residents in the Los Angeles County, Orange County and San Gabriel Valley region. The Caboodle ETL Developer is responsible for developing custom import packages for the Caboodle database, requiring strong SQL skills and a solid understanding of healthcare data. Responsibilities • Develops custom import packages to move additional data sets into the Caboodle database • Demonstrated proficiency in writing SQL • Demonstrated proficiency with SQL Server Integration Services • Demonstrated proficiency in data architecting and data modeling • Demonstrating flexibility with respect to changing end‐user business needs • The ability and willingness to recognize assignments or tasks that need to be completed, to seek out additional assignments or tasks, and to help others • The ability to communicate information clearly and concisely with project leadership and subject matter experts • The ability to gain trust and establish effective relationships with Epic counterparts • The ability and willingness to learn new software and systems • Listening attentively to ensure that the intended message has been accurately received, holding responses until the person have finished making their point, and repeating information to ensure accuracy • Seeking, logically examining, and interpreting information from different sources to determine a problem's cause and developing a course of action to resolve the problem and to prevent its recurrence • The ability to persevere in difficult situations, overcome obstacles, and reach high levels of performance when faced with stressful work situations and time pressures Skills • Strong analytical, technical, and troubleshooting skills • Demonstrated proficiency in writing SQL • Demonstrated proficiency with SQL Server Integration Services • Demonstrated proficiency in data architecting and data modeling • Demonstrating flexibility with respect to changing end‐user business needs • The ability and willingness to recognize assignments or tasks that need to be completed, to seek out additional assignments or tasks, and to help others • The ability to communicate information clearly and concisely with project leadership and subject matter experts • The ability to gain trust and establish effective relationships with Epic counterparts • The ability and willingness to learn new software and systems • Listening attentively to ensure that the intended message has been accurately received, holding responses until the person have finished making their point, and repeating information to ensure accuracy • Seeking, logically examining, and interpreting information from different sources to determine a problem's cause and developing a course of action to resolve the problem and to prevent its recurrence • The ability to persevere in difficult situations, overcome obstacles, and reach high levels of performance when faced with stressful work situations and time pressures • Experience in SQL • 10 or more years of strong experience in SQL server, including T-SQL, schema design, performance tuning, solid background in SSIS development with ETL processes and data pipeline designs • 5 years of experience in a data role in a healthcare setting • 5 years of experience with SSRS and other visualization tools (i.e. Tableau, Power BI, Looker, etc) • Epic Train Track: Caboodle Development for Clarity Data • Epic Train Track: Caboodle Development for Non‐Epic Data • Certified in Epic Clarity Data Model • Certified in Epic Caboodle Data Model • Certified in Epic Caboodle Development Company Overview • PIH Health is a nonprofit, regional healthcare network. It was founded in 1959, and is headquartered in Whittier, California, USA, with a workforce of 5001-10000 employees. Its website is Apply tot his job