Data Architect, Data & Analytics

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/transactional 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 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. 

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.
• Custom Epic Caboodle data warehouse development to integrate data into Caboodle from various sources.
• Custom data warehouse/Datamart development for data that does not integrate with Epic data.
• Migrate data from legacy systems and external data into Epic Caboodle data warehouse for the development of new solutions.
• Work with users to automate schedule of reporting and other data driven functions.
• Work with data requestor or stakeholder to validate the results.
• Determine and manage workload priorities.

Job Function: Monitoring and Problem Resolution:

• Apply knowledge of resources, constraints, and organizational values in decision making process.
• Upgrades to current state versions on Business Intelligence Applications (Epic Cogito Infrastructure, Tableau Server, SAP Business Objects Enterprise, REDCap, etc.) to minimize problems and in accordance with vendor specifications.

Job Function: Planning:

• Work extensively with department representatives to understand and define their database and/or data mart needs.
• Work with Data & Analytics staff, department representatives and vendors as necessary to provide technical expertise and assistance in installation, upgrading, and maintenance of new database systems.
• Work with other department staff to implement databases and migrations to new versions.

Job Function: Project Support:

• Provide task level detail for project plans, including suggested schedules.
• Provide accurate and timely individual status reports.
• Document and ensure timely resolution of project issues.
• Coordinate effectively with team members.
• Support the institution’s internal and external, strategic and operational reporting needs. Inform management of all issues that are influencing or will impact assignment.

Job Function: Documentation:

• Own and assist in data model documentation, data dictionary, data flow, data mapping, and other data governance documentation.
• Appropriately documents application information, backup and disaster recovery procedures, and database structures.
• Provide necessary documentation for network, installations, configurations, procedures, and other related network functions.
• Identify data sources and constructs data diagrams, data flow diagrams, and documents processes.

Job Function: Other Duties:

• Provide occasional backup for other duties as needed.
• On call rotation

• Minimum Required: Bachelor’s degree. 
• Preferred: Master’s Degree. 
• 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 in 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.
• Machine Learning Model deployment preferred.
• Programming languages such as Python and C# 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.