Database Manager Architect I

Trinity Health - Ann Arbor, MI

Full-time

Ann Arbor, MI

Hospitals

About the position

The Database Manager/Architect is responsible for designing, administering, developing, and expanding a multi-source data warehouse that supports business intelligence, advanced analytics, clinical research, and health system quality reporting. This role is crucial in an innovative environment where team members can see the impact of their work on improving patient care.

Responsibilities

• Designs, administers, and maintains the data warehouse.
• Responsible for ETL processes; manipulates, cleans, and loads data from various sources.
• Tests and maintains data integrity across multiple databases with edit checks.
• Develops and maintains a framework for adding additional data sources into the warehouse.
• Maintains database server integrity and security.
• Implements new database and online technology to improve efficiency.
• Audits, modifies, and updates data in systems using SAS, SQL commands, and bulk import.
• Develops and enforces database and user standards and procedures.
• Schedules database projects, transaction log backups, and notifications.
• Collaborates with TIS, home office, and external organizations for data management.

Requirements

• Bachelor's degree in computer science, information management, or related field.
• Certification in Microsoft SQL Server preferred.
• Minimum of 3 years of experience in a database environment, preferably SQL Server.
• Knowledge of SAS, Bases SAS, SAS macros, INTRNET, ACCESS, CONNECT strongly preferred.
• Experience with Business Objects, Desktop Intelligence, Web Intelligence preferred.
• HL7 experience preferred.
• Experience working in the healthcare industry preferred.
• Demonstrated understanding of current data structures and database administration concepts.
• Proficient with MSSQL Server 2018 or higher, Oracle or similar, stored procedures, and data management.

Nice-to-haves

• Experience with FTP and ODBC Connectivity.
• Familiarity with basic retrieval, security, and backup processes.