Employment Type:

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.

EssentialFunctions andResponsibilities

> 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.

RequiredEducation Experience and Certification/Licensure

• Bachelors degree in computer science information management or related field.
• 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.
• Certification in Microsoft SQL server 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

Rooted in our Mission and Core Values we honor the dignity of every person and recognize the unique perspectives experiences and talents each colleague brings. By finding common ground and embracing our differences we grow stronger together and deliver more compassionate person-centered care. We are 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 veteran status or any other status protected by federal state or local law.