Trinity Health
Database Manager Architect I
Trinity Health, Ann Arbor, Michigan, us, 48113
Employment Type:Full time
Shift:
Description:
Applicants for this position must be authorized to work for any employer in the U.S. We are unable to sponsor an employment visa for this position.
General Summary
The Database Manager/Architect is responsible for the design, administration, development and expansion of a multi-source, multi-hospital, multi-schedule data warehouse to support business intelligence, advanced analytics, clinical research as well as routine health system quality and safety reporting. This is a key position in an innovative environment in which team members see how their work is used to improve patient care.
Essential Functions and Responsibilities
> Designs, administers and maintains data warehouse:Responsible for the ETL processes; Manipulates, cleans, loads data from internal and external sources; Tests and maintains data integrity across multiple databases with edit checks; Develops and maintains framework for adding additional data sources into warehouse.Maintains database server integrity and security.Develops new processes for the warehouse to optimize the existing data; implements new database and online technology from time to time; improves efficiency of existing database systems by utilizing keys and indexes.Audits, modifies and updates data in systems using processes such as SAS, SQL commands, hand-editing, and bulk import.Develops and enforces database and user standards and procedures.Schedules database projects, transaction log backups, and notifications.Works with TIS, home office, external organizations for efficient and accurate data management.> Maintains the confidentiality of information acquired pertaining to patients, physicians, employees, and visitors to Trinity Health Michigan.
> Collaborates with staff on database projects:
Collaborates with the team and participates in team meetings/project meetings to determine user requirements.Reviews technical designs, reports, documentation, and other materials produced by staff.Assists team members in the development and creation of SQL and Web-based databases and database systems.Works closely with physicians and hospital staff to determine their information needs.
Required Education, Experience and Certification/Licensure
Bachelor's degree in computer science, information management or related field. Certification in Microsoft SQL server preferred. A minimum of 3 years of experience in a database environment (SQL Server preferred) with significant responsibilities. Knowledge of SAS, Bases SAS, SAS macros, INTRNET, ACCESS, CONNECT strongly preferred. Business Objects, Desktop Intelligence, Web Intelligence preferred. HL7 experience preferred. Experience working in the healthcare industry preferred.
REQUIRED SKILLS AND ABILITIES
Demonstrated understanding of current data structures, database theory and database administration concepts Proficient with MSSQL Server 2018 or higher, Oracle or similar, stored procedures, importing/exporting data, back up/restoring databases, triggers. Knowledge of FTP and ODBC Connectivity. Familiarity with basic retrieval, security and back-up. Strong analytical, problem-solving and conceptual skills. Ability to manage multiple concurrent projects. Strong teamwork and interpersonal skills. Timely and effective verbal and written communication skills.
Our Commitment to Diversity and Inclusion
Trinity Health is one of the largest not-for-profit, Catholic healthcare systems in the nation. Built on the foundation of our Mission and Core Values, we integrate diversity, equity, and inclusion in all that we do. Our colleagues have different lived experiences, customs, abilities, and talents. Together, we become our best selves. A diverse and inclusive workforce provides the most accessible and equitable care for those we serve. Trinity Health is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by law.
Shift:
Description:
Applicants for this position must be authorized to work for any employer in the U.S. We are unable to sponsor an employment visa for this position.
General Summary
The Database Manager/Architect is responsible for the design, administration, development and expansion of a multi-source, multi-hospital, multi-schedule data warehouse to support business intelligence, advanced analytics, clinical research as well as routine health system quality and safety reporting. This is a key position in an innovative environment in which team members see how their work is used to improve patient care.
Essential Functions and Responsibilities
> Designs, administers and maintains data warehouse:Responsible for the ETL processes; Manipulates, cleans, loads data from internal and external sources; Tests and maintains data integrity across multiple databases with edit checks; Develops and maintains framework for adding additional data sources into warehouse.Maintains database server integrity and security.Develops new processes for the warehouse to optimize the existing data; implements new database and online technology from time to time; improves efficiency of existing database systems by utilizing keys and indexes.Audits, modifies and updates data in systems using processes such as SAS, SQL commands, hand-editing, and bulk import.Develops and enforces database and user standards and procedures.Schedules database projects, transaction log backups, and notifications.Works with TIS, home office, external organizations for efficient and accurate data management.> Maintains the confidentiality of information acquired pertaining to patients, physicians, employees, and visitors to Trinity Health Michigan.
> Collaborates with staff on database projects:
Collaborates with the team and participates in team meetings/project meetings to determine user requirements.Reviews technical designs, reports, documentation, and other materials produced by staff.Assists team members in the development and creation of SQL and Web-based databases and database systems.Works closely with physicians and hospital staff to determine their information needs.
Required Education, Experience and Certification/Licensure
Bachelor's degree in computer science, information management or related field. Certification in Microsoft SQL server preferred. A minimum of 3 years of experience in a database environment (SQL Server preferred) with significant responsibilities. Knowledge of SAS, Bases SAS, SAS macros, INTRNET, ACCESS, CONNECT strongly preferred. Business Objects, Desktop Intelligence, Web Intelligence preferred. HL7 experience preferred. Experience working in the healthcare industry preferred.
REQUIRED SKILLS AND ABILITIES
Demonstrated understanding of current data structures, database theory and database administration concepts Proficient with MSSQL Server 2018 or higher, Oracle or similar, stored procedures, importing/exporting data, back up/restoring databases, triggers. Knowledge of FTP and ODBC Connectivity. Familiarity with basic retrieval, security and back-up. Strong analytical, problem-solving and conceptual skills. Ability to manage multiple concurrent projects. Strong teamwork and interpersonal skills. Timely and effective verbal and written communication skills.
Our Commitment to Diversity and Inclusion
Trinity Health is one of the largest not-for-profit, Catholic healthcare systems in the nation. Built on the foundation of our Mission and Core Values, we integrate diversity, equity, and inclusion in all that we do. Our colleagues have different lived experiences, customs, abilities, and talents. Together, we become our best selves. A diverse and inclusive workforce provides the most accessible and equitable care for those we serve. Trinity Health is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by law.