Unclassified - Ann Arbor, MI
posted about 2 months ago
The Database Manager/Architect is a pivotal role responsible for the design, administration, development, and expansion of a multi-source, multi-hospital, multi-schedule data warehouse. This data warehouse supports business intelligence, advanced analytics, clinical research, and routine health system quality and safety reporting. The position is situated in an innovative environment where team members can see the direct impact of their work on improving patient care. The role requires a comprehensive understanding of data management processes and the ability to collaborate effectively with various stakeholders to ensure the integrity and security of the data warehouse. In this role, the Database Manager/Architect will be responsible for the ETL (Extract, Transform, Load) processes, which include manipulating, cleaning, and loading data from both internal and external sources. The individual will also be tasked with testing and maintaining data integrity across multiple databases, developing and maintaining a framework for adding additional data sources into the warehouse, and ensuring the security and integrity of the database server. The position involves auditing, modifying, and updating data in systems using various processes such as SAS, SQL commands, and bulk imports. Additionally, the Database Manager/Architect will develop and enforce database and user standards and procedures, schedule database projects, and manage transaction log backups. Collaboration is key in this role, as the Database Manager/Architect will work closely with team members on database projects, participate in team meetings to determine user requirements, and assist in the development of SQL and web-based databases. The individual will also engage with physicians and hospital staff to understand their information needs and ensure that the database systems meet those needs effectively.