Mount Sinai Careers

Business Intelligence Analyst (PLSQL, SSIS, SSRS, Tableau)

New York, New York
Future Opportunities

Job Description



Business Intelligence Analyst (PLSQL, SSIS, SSRS, Tableau)

Our Quality Operations group provides end-to-end data management support across Mount Sinai’s clinical institutes and clinical care service lines. Our scope encompasses clinical data registries and disease-based cohort databases that are used for the purposes of quality initiatives, performance improvement, and patient outcomes research. We are currently seeking a Business Intelligence Analyst who will design and build registry/disease/procedure based data models and ETL programs and stored procedures to support these data models. This BI Analyst will also be responsible for development of descriptive statistics through reports and scorecards (Microsoft SSRS) and self-service applications through data visualization tools (Tableau).


Duties and Responsibilities:

·     -    Design and build registry/disease/procedure specific data models.

·      -   Create/maintain complex SQL codes and stored procedures that feed and refresh the data models.

·      -   Create/maintain ETLs that source data from various databases to support the data models.

·     -    Build and advocate analytics and outcomes research projects ranging from scorecards and dashboards to data mining studies evaluating the effectiveness of a particular care process.

·      -   Responsible for the data analysis, development of data visualization tools, and the presentation of data to clinical teams in support of monitoring clinical care protocols and measuring quality and outcomes.

·      -   Work closely with biostatisticians for development of risk models, analytical algorithms, analytics data marts, and development of statistical data tables.


Minimum Education

·         Bachelor's (required) or Master’s (preferred) in Statistics, Mathematics, Economics, Public Health, Computer or Systems Engineering or related field that further developed your expertise in the business of health and healthcare.

Minimum Related Experience                                                                                                                   

·     -Three (+) years of experience in writing complex SQL
-Two (+)  years of data analytics experience using BI tools and data visualization software
-Solid understanding of enterprise data warehouse, subject-matter data marts, and complex data models

·      -Prior experience as a healthcare data analyst or business analyst working with clinical EHR (Epic Clarity) data and nomenclatures and hospital claims data and disease classification systems

·      -General understanding of hospital claims datasets, healthcare departmental/clinical operations, workflow, policies, and procedures is a plus

·     -Project management (agile, lean) skills a plus


for Live Chat Click Here