At Stony Brook Medicine the Quality Database Administrator/Architect functions as the leader in maintaining and continuously enhancing applications and repositories such as the Lumedx Apollo application and database, the Vizient repository database, and the Performance Manager application. This individual will take responsibility for ensuring the continued smooth functioning of these applications and databases, implementing additional data imports and exports as determined necessary by departmental and hospital leadership, and meet the needs of staff who must access these applications and databases for abstraction and analysis.
Duties of a Quality Database Administrator/Architect may include the following but are not limited to:
Function as the lead support of the monthly downloads from the Vizient Clinical Database application, ensuring that monthly data are successfully downloaded and then integrated into the Vizient repository database. This may include collaborating with vendor and/or IT staff to monitor the success of monthly uploads by IT.
Perform updates to the Vizient repository database as needed to ensure that data tables from all Stony Brook Medicine hospitals can continue to successfully integrate. Data table formats are updated at minimum annually by Vizient.
Perform necessary updates and upgrades to the Apollo application by working with Lumedx, Quality Measurement & Analytics (QMA), hospital Information Technology (IT), clinical and administrative staff. Manage the long-term maintenance and support of the Apollo application; this includes additional data integration and other improvements.
Work with QMA abstraction staff clinical care areas as necessary to enhance clinical data capture and analysis, in support of internal and external quality improvement and reporting efforts and mandates. This includes custom field development and other enhancements to the Apollo application in order to integrate required registries and to meet the needs of these programs. Working with the services may require flexible scheduling to accommodate physician participation.
Function as the QMA lead for updates and upgrades to the Performance Manager decision support system clinical quality data warehouse and reporting, in collaboration with colleagues in IT and Finance.
Implement, maintain, and support other quality databases and applications as deemed appropriate by the Director of QMA.
Maintain all appropriate documentation for quality databases and applications, including process steps, data dictionaries, and other information necessary to ensure the smooth functioning of these databases.
Train analysts in the extraction of data from quality databases and applications. Train end users in navigation, data entry, and routine report generation.
Provide technical support and coordinate data activities to develop a centralized clinical data repository.
Provide high quality, actionable reports to hospital leadership, Programs of Distinction (PODs), Quality Improvement (QI) and other performance improvement teams, and other groups to drive quality and safety improvement efforts. This includes aggregating, analyzing and displaying statistically-oriented, external quality reporting data in formats such as dashboards, scorecards, visualizations, and other reports. Ensure the automation of reporting functions wherever possible.
Provide guidance and support on data capture, data integration, data management, data validation, analytical, and internal and external quality and safety reporting topics to other QMA personnel, QI, and other analytical and clinical departments.
Generate ad hoc reports and perform ad-hoc responsibilities as deemed appropriate by the Director of QMA.
Abide by and demonstrate Stony Brook's Mission, Vision, and Values through behavior and job performance on a day-to-day basis. Maintain awareness of institutional quality priorities and work collaboratively with colleagues in QMA, the Quality Management Division, IT, Finance, clinical and ancillary services, and hospital leadership to accomplish organizational goals.
Bachelor degree in Computer Science, Information Systems, or other requiring database and systems administration skills, applications, programming, and/or software engineering/analysis. Equivalent job experience or non-degree training will also be considered.
Three or more years or relevant experience in database administration, applications, programming, and/or software engineering/analysis.
SQL Server experience, including the ability to create and maintain stored procedures for import to and update of databases.
Experience and skill in developing and monitoring mechanisms for assessing data accuracy and completeness.
Superior organization skills, detail-oriented, and ability to be persistent and follow-through.
Problem-solving, ability to adapt, flexibility in approaches to accomplishing tasks, and ability to independently arrive at creative solutions to problems.
Excellent communication skills, both verbal and written, particularly the ability to convey technical information in an accessible and understandable manner.
Strong listening skills with the ability to gather requirements and understand the technical barriers to project completion.
Master's degree in Computer Science, Information Systems or other field requiring database and systems administration skills, applications, programming, and/or software engineering/analysis.
Five or more years of relevant experience in database administration, applications, programming, and/or software engineering/analysis.
Experience with SSIS, VBA, Datawatch Monarch, open source data extraction and transformation tools such as Python and R, as well as with the SAP Business Objects Suite, particularly Web Intelligence, and Crystal Reports are a plus. Experience with Tableau is also desirable.
Prior experience with health care-related systems and reporting as well as working in a health care setting and/or collaborating with clinical staff.
Experience as well as skill in presenting data in a variety of reporting formats and to a variety of audiences.
Experience and skill in managing external vendors.
This position will remain posted until filled or for 90 days max.
An initial review of all applicants will occur two weeks from the posting date. For full consideration, applications must be received before the initial review date (which is within two weeks of the posting date). If within the initial review no candidate was selected to fill the position posted, additional applications will be considered for the posted position; however, the posting will close once a finalist is identified, and at minimal, two weeks after the initial posting date. Please note, that if no candidate were identified and hired within 90 days from initial posting, the posting would close for review, and possibly reposted at a later date.
Stony Brook Medicine is a smoke free environment. Smoking is strictly prohibited anywhere on campus, including parking lots and outdoor areas on the premises.
All Hospital positions are subject to changes in pass days and shifts as necessary. This position may require the wearing of respiratory protection, which may prohibit the wearing of facial hair.
The selected candidate must successfully clear a background investigation. Prior to start date, the selected candidate must meet the following requirements: Successfully complete pre-employment physical examination and obtain medical clearance from Stony Brook Medicine's Employee Health Services (The hiring department will be responsible for any fee incurred for examination), submit (3) written references, and provide a copy of any required New York State license(s)/certificate(s). Please be advised that failure to comply with any of the above requirements could result in a delayed start date and/or revocation of the employment offer.
The best ideas in medicine start with the best people. At Stony Brook Medicine, our highest calling is to put the power of ideas to work in our patients' lives. Stony Brook Medicine integrates and elevates all of our health-related initiatives: education, research and patient care. Stony Brook Medicine is Long Island's premier academic medical center. With 603 beds, we serve as the region's only tertiary care center and Level 1 Trauma Center, and are home to the Stony Brook Heart Institute, Stony Brook Cancer Center, Stony Brook Children's Hospital, Stony Brook Neurosciences Institute, and Stony Brook Digestive Disorders Institute. We also encompass Suffolk County's only Level 4 Regional Perinatal Center, state-designated AIDS Center, state-designated Comprehensive Psychiatric Emergency Program, state-designated Burn Center, the Christopher Pendergast ALS Center of Excellence, and Kidney Transplant Center. It is home of the nation's first Pediatric Multiple Sclerosis Center.
Stony Brook University is an Affirmative Action/Equal Opportunity employer. We are committed to the creation of a diverse and inclusive campus climate. We encourage protected veterans, individuals with disabilities, women and minorities to apply.
This function/position has been designated as "essential." This means that when the Hospital is faced with an institutional emergency, employees in such positions may be required to remain at their work location or to report to work to protect, recover, and continue operations at Stony Brook Medicine, Stony Brook University Hospital and related facilities.
Pursuant to Executive Order 161, no State entity, as defined by the Executive Order, is permitted to ask, or mandate, in any form, that an applicant for employment provide his or her current compensation, or any prior compensation history, until such time as the applicant is extended a conditional offer of employment with compensation. If such information has been requested from you before such time, please contact the Governor's Office of Employee Relations at (518) 474-6988 or via email at email@example.com .
IF YOU NEED A DISABILITY-RELATED ACCOMMODATION, PLEASE CALL THE UNIVERSITY HUMAN RESOURCE SERVICES DEPARTMENT AT (631) 632-6161 OR THE UNIVERSITY HOSPITAL HUMAN RESOURCES DEPARTMENT AT (631) 444-4700. IN ACCORDANCE WITH THE TITLE II CRIME AWARENESS AND SECURITY ACT, A COPY OF OUR CRIME STATISTICS IS AVAILABLE UPON REQUEST BY CALLING (631) 632-6350. IT CAN ALSO BE VIEWED ON-LINE AT THE UNIVERSITY POLICE WEBSITE AT http://www.stonybrook.edu/police
Official Job Title: TH Staff Associate
Job Field: Quality and Safety
Primary Location: US-NY-East Setauket
Department/Hiring Area: Quality Measurement & Analytics-Stony Brook University Hospital
Schedule: Full-time Shift: Day Shift Shift Hours: 0830-1700 Pass Days: Sat, Sun
Posting Start Date: Nov 7, 2019
Posting End Date: Feb 6, 2020, 4:59:00 AM
Salary: Commensurate with experience
Salary Grade: SL4
Internal Number: 1904086
About Stony Brook University
FROM ITS BEGINNINGS A HALF-CENTURY AGO, STONY BROOK UNIVERSITY HAS BEEN CHARACTERIZED by innovation, energy and progress, transforming the lives of people who earn degrees, work and make groundbreaking discoveries here. A dramatic trajectory of growth has turned what was once a small teacher preparation college into an internationally recognized research institution that is changing the world.