Trinity Health MI · 23 hours ago
Database Manager Architect I
Ann Arbor, MI
Full-time
Onsite
Mid Level
$41.90/hr - $41.90/hr
3+ years expTrinity Health MI is a healthcare organization focused on improving patient care, and they are seeking a Database Manager Architect I to design and maintain a multi-source data warehouse. The role involves overseeing ETL processes, ensuring data integrity, and collaborating with staff to meet information needs.
Hospital & Health Care
No H1B
Responsibilities
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 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
Qualification
Required
Bachelor's degree in computer science, information management, or related field
Minimum of 3 years of experience in a database environment with significant responsibilities
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
Preferred
SQL Server preferred
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
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
Company
Trinity Health MI
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Gregory Wickings
Talent Acquisition Partner - Trinity Health Michigan (Grand Rapids & Muskegon)
Laura Aquinto
Revenue Site Business Partner
Company data provided by crunchbase