Job Summary

Supports the business and clinical operations of the Perioperative Service Line (PSL) at a system level in alignment with the organization's strategic priorities. Develops data analysis routines for business and clinical performance measurement and monitoring. Imports and maintains data from a variety of sources to support data driven, continuous improvement across MedStar Health. Designs, codes, tests, and maintains relational databases. Relates data insights to operational stakeholders to gain operational efficiency and drive clinical quality and business outcomes.

Minimum Qualifications

Education/Training:

Bachelor's degree in information technology, computer science, or related field required.

Experience:

3 year's experience in SQL database and reports development, and experience with database and systems development life cycle management required. 2 year's knowledge and experience with statistical analysis and modeling. Experience in healthcare field and knowledge of the healthcare industry highly preferable

License/Cert/Reg:

No special certification, registration or licensure required.

Knowledge, Skills & Abilities:

Critical thinking, reasoning and problem solving. Ability to write complex SQL queries and demonstrated competence developing complex stored procedures, functions, triggers, and other database objects. Experience with large databases/data warehouses required and developing dashboards. Ability to translate concepts into tangible ideas and informative data deliverables. Excellent interpersonal skills and strong verbal and written communication. Demonstrated proficiency with Microsoft Office applications, including Word, Excel, Outlook, Visio and PowerPoint. Knowledge of Python and experience working with Health Catalyst data warehouse and Tableau preferred.

Primary Duties and Responsibilities

1. Contributes to the achievement of established department goals and objectives and adheres to department policies, procedures, quality standards, and safety standards. Complies with governmental and accreditation regulations.
2. Collaborates with other technical and operational teams throughout the organization to deliver data solutions which establish and meet business, technical and data governance requirements.
3. Creates and maintains accurate design documentation for new projects and existing reporting artifacts and maintains repository of data architecture and design artifacts and procedures.
4. Designs, coordinates, and executes pilots, prototypes, or proof of concepts, provides validation on specific scenarios and deployment guidance as required, meeting established goals and deadlines.
5. Effectively escalates and communicates risks and issues, while communicating status updates.
6. Establishes and manages production data and analytics processes and deliverables. Develops and performs QA processes to ensure data accuracy. Troubleshoots issues and errors. Optimizes analyses and dashboards as requested.
7. Supports architectural guidelines for the data and analytics environment in areas including scalability, security, performance, data recovery, reliability and usability and applies those guidelines to the design and implementation of reporting and analytics projects.
8. Leads multiple projects and efforts including design sessions to gather requirements, report and analyze business features for the organizations leadership by orchestrating and delivering cohesive data solutions.
9. Identifies appropriate data sources and works with data owners to obtain appropriate data access.
10. Engages with data stewardship by partnering with stakeholders and subject matter experts to understand, identify, and standardize data sources and data dictionaries that are used for enterprise analytics, business intelligence and reporting.
11. Partners with stakeholders to ensure data accuracy, business rules for metric calculations and validation of outputs.
12. Performs statistical analysis including hypothesis testing, regression analysis, factor analysis, capability comparison and variance analysis and articulates interpretation of statistical results.
13. Presents analytics to varying audiences, adjusting the presentation of the data based on target audience (ranging from senior executives to frontline personnel).
14. Participates in interdisciplinary meetings as required to support development of data platforms in alignment with business needs and promote data use in optimization of operations.
15. Stays abreast of industry standards, emerging technologies, and best practice with the intent of applying to current and future projects.
16. Participates in meetings and on committees and represents the department and hospital in community outreach efforts.
17. Participates in multi-disciplinary quality and service improvement teams.
18. Performs other duties as assigned.