UC Health is hiring a Full Time Data Architect The purpose of this position is to function as an advanced technical lead to coordinate, validate and deliver short and long-term enterprise data management initiatives. This individual designs, develops, implements, maintains and continuously refines data warehouse architectures using the Epic Caboodle framework, logical and physical data models, application ransactional interfaces, data integration methods, and end-to-end data flows. This position will need to have a clear understanding of the data and work with key stakeholders in order to validate accurate results and reconcile discrepancies when necessary. About UC Health UC Health is an integrated academic health system serving Greater Cincinnati and Northern Kentucky. In partnership with the University of Cincinnati, UC Health combines clinical expertise and compassion with research and teaching-a combination that provides patients with options for even the most complex situations. Members of UC Health include: UC Medical Center, West Chester Hospital, Daniel Drake Center for Post-Acute Care, Bridgeway Pointe Assisted Living, University of Cincinnati Physicians and UC Health Ambulatory Services (with more than 900 board-certified clinicians and surgeons), Lindner Center of HOPE and several specialized institutes including: UC Gardner Neuroscience Institute and the University of Cincinnati Cancer Center. Many UC Health locations have received national recognition for outstanding quality and patient satisfaction. Learn more at uchealth.com.

• Minimum Required: Bachelor's degree.
• Preferred: Masters Degree. | Epic Data (Caboodle / Clarity) certified within six months. |
• 1-2 Years equivalent experience - Minimum Required.
• 3 - 5 Years equivalent experience - Preferred.
• 4 Years equivalent experience can substitute for a BA/BS Degree.

REQUIRED SKILLS AND KNOWLEDGE:

• Demonstrated experience and highly skilled with database concepts SQL Server, SSIS, T-SQL, query optimization tools and techniques, data modelling techniques, and relational database design.
• Good understanding of the features available in SQL Server to achieve a scalable database solution.
• Experience architecting and building Data Warehouses, DataMarts, and/or Data Lakes.
• Epic Caboodle Custom Development certification required in first 6 months of employment required, existing certification preferred.
• Familiarity with Informatica preferred.

Join our team to BE UC Health. Be Extraordinary. Be Supported. Be Hope. Apply Today! At UC Health, we're proud to have the best and brightest teams and clinicians collaborating toward our common purpose: to advance healing and reduce suffering. As the region's adult academic health system, we strive for innovation and provide world-class care for not only our community, but patients from all over the world. Join our team and you'll be able to develop your skills, grow your career, build relationships with your peers and patients, and help us be a source of hope for our friends and neighbors. UC Health is committed to providing an inclusive, equitable and diverse place of employment.Job Function: Development of Data Marts/Warehousing/Scripts:

Design & document the organization's enterprise data architecture, collaborating with multiple operational departments and IS&T stakeholders.

Architect the enterprise Caboodle strategy, with a clearly documented process of integrating data into Caboodle from various sources.

Oversees the migration into the Epic Caboodle data warehouse of data from legacy systems and external data to new solutions.

Works with users to automate schedule of reporting and other data driven functions.

Work with data requestor or stakeholder to validate the r