The Caboodle ETL Developer develops custom import packages to move additional data sets into the Caboodle database. This role may not be required depending on how you plan to use Caboodle at your organization and how nonEpic data will help contribute to your reporting needs.
Requirements
- Demonstrated proficiency in writing SQL
- Demonstrated proficiency with SQL Server Integration Services
- Demonstrated proficiency in data architecting and data modeling
- Experience inSQL
- strong experience inSQL server, including T-SQL,schema design, performance tuning, solid background inSSISdevelopment withETL processesand data pipeline designs
- 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 NonEpic Data
- Certified in Epic Clarity Data Model
- Certified in Epic Caboodle Data Model
- Certified in Epic Caboodle Development
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
- Experience inSQL
- strong experience inSQL server, including T-SQL,schema design, performance tuning, solid background inSSISdevelopment withETL processesand data pipeline designs
- experience with SSRS and other visualization tools (i.e.Tableau, Power BI,Looker,etc)
Other
- Strong analytical, technical, and troubleshooting skills
- Demonstrating flexibility with respect to changing enduser 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
- 5 years of experience in a data role in a healthcare setting