Senior Data Architect

Current Saint Francis Employees - Please click HEREto login and apply.

Job Summary: The Senior Data Architect designs new data models, evaluates data management technologies and techniques, reviews and analyzes current data infrastructures, plans future databases, and implements solutions to store and manage data for the organization and its users.

Minimum Education: Bachelor’s degree in Information Technology or related field. Five years of equivalent experience in lieu of Bachelor's degree may be considered.

Licensure, Registration and/or Certification: None.

Work Experience: Minimum 5 years of related experience. Experience within a healthcare environment, preferred.

Knowledge, Skills and Abilities: Working knowledge in Cloud/Big Data solutions or related technologies. Working knowledge of data management and governance concepts. Expertise in data architecture concepts such as data modeling, workflow management, ETL/ELT, and real time streaming. Knowledge utilizing Microsoft Azure/Synapse/Power BI, Epic EHR, or Workday ERP. Understanding of data governance principles and best practices. Excellent technical/non-technical oral and written communication skills. Strong analytical ability to solve both business and technical problems with strong attention to detail. Proficiency working on concurrent projects with minimal supervision.

Essential Functions and Responsibilities: Works collaboratively across teams to understand quality and performance improvement agendas and corresponding data and analytics needs and recommends appropriate solutions. Mentors junior team members to develop skills and understand data architecture concepts. Provides team with additional levels of review and assists with technical troubleshooting. Translates business requirements into databases, data warehouses, and data streams. Identifies internal and external data sources to establish data pipelines and works with product owners to efficiently retrieve data. Develops new data models and implements tables and supporting objects in the Enterprise Data Warehouse (EDW) database. Assists with populating, automating, and maintaining metadata to make the EDW easier to navigate and to facilitate good data governance practices. Develops solutions to monitor usage and performance of EDW and notifies appropriate team of any developing issues. Investigates performance issues with queries and Extract, Transform, Load (ETL) processes on the EDW and initiates solutions to tune the database and optimize the speed of the loads. Provides support to data analysts for the most complex problems, employing advanced SQL methods and innovative data visualization techniques. Develops and conducts end-user training and education for the use of the EDW and its capacity for use in different areas of the organization. Contributes to the definition, review, and adherence to the EDW team’s guiding principles as they relate to the overall architecture and design, development and support processes, and interaction with customers. Interfaces with other teams in IT to ensure the EDW environments are up to date, backed up, and able to sustain expected growth in the future.

Decision Making: The carrying out of non-routine procedures under constantly changing conditions, in conformance with general instructions from a supervisor.

Working Relationships: Leads others in same work performed (does not supervise). Works with internal and/or external customers via telephone or face to face interaction. Works with other healthcare professionals and staff. Works frequently with individuals at Director level and above.

Special Job Dimensions: None.

Supplemental Information: This document generally describes the essential functions of the job and the physical demands required to perform the job. This compilation of essential functions and physical demands is not all inclusive nor does it prohibit the assignment of additional duties.

Location:

EOE Protected Veterans/Disability