Database Manager Architect

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.

Full time

Days

Days

Full-time, 40 hours/week

Center for Health Care Analytics and Performance Improvement

Trinity Health Ann Arbor

$41.90 PLUS DailyPAY

• Competitive compensation, DAILYPAY
• Benefits effective Day One! No waiting periods.
• Full benefits package including Medical, Dental, Vision, PTO, Life Insurance, Short and Long-term Disability
• Retirement savings plan with employer match and contributions
• Opportunity for growth and advancement throughout Trinity Health
• Tuition Reimbursement

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.

• Bachelor's 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.

• 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.
• Must be able to set and organize own work priorities and adapt to them as they change frequently.
• Must be able to work concurrently on a variety of tasks/projects in an environment that may be stressful with individuals having diverse personalities and work styles.

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

to learn more about the benefits, culture, and career development opportunities available to you at Trinity Health Michigan.

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.