Database Manager Architect I

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

• Bachelor's degree in computer science, information management, or related field.

Experience:

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

Physical and Mental Requirements and Working Conditions:

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

Minimum rate of pay: $41.90 PLUS DailyPAY

Total Rewards and Benefits:

• 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

Click Here (https://www.stjoeshealth.org/careers/current-openings/benefits) to learn more about the benefits, culture, and career development opportunities available to you at Trinity Health Michigan. 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. Our Commitment to Diversity and Inclusion Trinity Health is a family of 115,000 colleagues and nearly 26,000 physicians and clinicians across 25 states. Because we serve diverse populations, our colleagues are trained to recognize the cultural beliefs, values, traditions, language preferences, and health practices of the communities that we serve and to apply that knowledge to produce positive health outcomes. We also recognize that each of us has a different way of thinking and perceiving our world and that these differences often lead to innovative solutions. Our dedication to diversity includes a unified workforce (through training and education, recruitment, retention, and development), commitment and accountability, communication, community partnerships, and supplier diversity. EOE including disability/veteran