Senior Application Analyst

The Database Analyst, under the direction of the Assistant Director of Montefiore Care Management's (CMO) MIS department, will be responsible for the analysis and production of multiple projects related to Operational, Clinical, Quality, and Safety improvements for the health plan members' medical management, customer service call center.

The Data Analyst will be the point person for the analysis and assist leadership in identifying new areas for improvement, preparing presentations and forecasting.

He/she will also be heavily involved in the creation, validation and improvement of dashboards related to these projects and other organization-wide initiatives.

The Data Analyst will partner with Montefiore IT and clinical/operational owners to detail project specifications, develop dashboards utilizing MS Power BI Report Server or other data visualization software, conduct quality assurance testing of the dashboards and assist in the education and roll-out of the dashboards with clinical and operational stakeholders.

The Data Analyst will serve as a resource for other analysts and application developers and will be expected to provide ad-hoc training and assistance.

Job Responsibilities:

• Relational Database Design and Development. Will support the development team and business analysts with database analysis and design as part of the various projects.

• Analyze Operational and Clinical data to establish and evaluate baseline performance measures and trends, size potential operational and clinical opportunities, measure ongoing Department performance vs. target, and identify and model additional metrics, service expansion and/or improvement opportunities.

• Design, implement, maintain and enhance data workflows and modeling, analytical processes, and reporting products that support company and client operations, program performance and opportunity assessments as they relate to the Montefiore Medical Center and Montefiore Care Management.

• Provide high level analytical and operational support for the MIS, Customer Service, Medical Management, and Network Care Management to assist in achieving financial and operational goals of the organization

• Assist in the development and preparation of ad-hoc reports on specific issues to help managers and other stakeholders make decisions.

• Analyze opportunities for operational improvement based on review of key performance indicators, and provides support of communication plans to assist in their implementation.

• Evaluate compliance with guidelines and healthcare industry protocols utilizing data analytics reports

• Perform outcomes analysis related to coordination of care

• Assist with healthcare economic analysis to demonstrate payer financial outcomes of the varied programs and other care management initiatives.

Minimum Qualifications:

To qualify for this role, the candidate must have Associates degree and at least two years of experience in a related position.

The Data Analyst should have a proficiency-level RDBMS understanding and competencies, and display a general understanding of medical field, claims processing systems. ETL experience is mandatory.

The candidate should demonstrate strong analytical and communication skills to meet and exceed the needs of their customers.

Preferred Qualifications:

A Bachelor's degree in Computer Science, Finance, Mathematics, Accounting, Management Information Systems, or a related field, is preferred.

The preferred candidate would have a good understanding of the Healthcare industry and will partner with Montefiore IT and clinical/operational owners to detail project specifications, develop dashboards utilizing MS Power BI Report Server or other data visualization software, conduct quality assurance testing of the dashboards and assist in the education and roll-out of the dashboards with clinical and operational stakeholders. The ideal candidate will have experience with decision support systems, healthcare data, and data visualization software such as MS Power BI Report Server. The candidate would be experienced in data analysis and visualization, and should be comfortable with handling large data sets, have strong written and verbal communication and presentation skills, and a team-oriented perspective.

The candidate should be able to effectively communicate with all levels of the Montefiore Care Management.

Skills Required:

• Must be proficient in enterprise-wide database management systems (MS SQL Server)
• Be fluent with

• Relational database design,
• T-SQL
• SQL Server Data Tools (SSDT/SSIS BIDS, SQL Server Integration Services, 2008 BIDS; 2019 SSDT) ETL
• MS SQL Server Reporting Services (2008-2019 SSRS)

• Preferred prior experience:

• Power BI Report Server 2018-2022
• MS SQL Server Analysis Services (SSAS)
• Trizetto QNXT / Facets
• Epic
• Optum Webstrat
• X12 EDI
• Healthcare IT

Will aid in strategic planning MMC Decision Support via

• analysis,
• research,
• planning,
• creation and maintenance of data, reports, dashboards, task management systems.

This Database Analyst will work in conjunction with various clinical, administrative and financial management groups to meet various static, dynamic and interactive data reporting and analysis needs.

Department: CMO Bargaining Unit: Non Union Campus: YONKERS Employment Status: Regular Full-Time Address: 100 Corporate Blvd, Yonkers

Shift: Day Scheduled Hours: 8:30 AM-5 PM Req ID: 209385 Salary Range/Pay Rate: $63,749.94 - $84,999.92

For positions that have only a rate listed, the displayed rate is the hiring rate but could be subject to change based on shift differential, experience, education or other relevant factors.

To learn more about the "Montefiore Difference" - who we are at Montefiore and all that we have to offer our associates, please click here .

Diversity, equity and inclusion are core values of Montefiore. We are committed to recruiting and creating an environment in which associates feel empowered to thrive and be their authentic selves through our inclusive culture. We welcome your interest and invite you to join us.

Montefiore is an equal employment opportunity employer. Montefiore will recruit, hire, train, transfer, promote, layoff and discharge associates in all job classifications without regard to their race, color, religion, creed, national origin, alienage or citizenship status, age, gender, actual or presumed disability, history of disability, sexual orientation, gender identity, gender expression, genetic predisposition or carrier status, pregnancy, military status, marital status, or partnership status, or any other characteristic protected by law.

N/A

Mission:

To heal, to teach, to discover and to advance the health of the communities we serve.

Vision:

To be a premier academic medical center that transforms health and enriches lives.

Values

Define our philosophy of care, they shape our actions and motivate and inspire us to pursue excellence and achieve the goals we have set forth for the future. Our values include:

• Humanity
• Innovation
• Teamwork
• Diversity
• Equity

Nearest Major Market: Yonkers

Nearest Secondary Market: New York City