UC Health · 19 hours ago
Data Architect
Cincinnati, OH
Full-time
Onsite
Mid, Senior Level
1+ years expUC Health is an integrated academic health system serving Greater Cincinnati and Northern Kentucky. They are seeking a Data Architect to function as an advanced technical lead in coordinating and delivering enterprise data management initiatives, designing and maintaining data warehouse architectures, and collaborating with stakeholders to ensure data accuracy.
BiotechnologyHealth CareHospitalMedicalNon Profit
Responsibilities
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
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
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
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
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
Provide occasional backup for other duties as needed
On call rotation
Qualification
Required
Bachelor's degree
1-2 Years equivalent experience - Minimum Required
4 Years equivalent experience can substitute for a BA/BS Degree
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
Preferred
Master's Degree
3 - 5 Years equivalent experience
Machine Learning Model deployment preferred
Programming languages such as Python and C# preferred
Existing Epic Caboodle Custom Development certification preferred
Company
UC Health
UC Health brings together the region’s top clinicians and researchers to provide world-class care to the Cincinnati community and beyond.
10001+ employees
H1B Sponsorship
UC Health has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (1)
Funding
Current Stage
Late StageLeadership Team
Alexandra Castillo
Vice President and Chief Data & Analytics Officer
Margie Zyble
Chief Human Resources Officer
Recent News
Company data provided by crunchbase