Oak Orchard Community Health Center, Inc. (Oak Orchard Health) seeks to hire a Senior Data Scientist, in Brockport, NY, who will be responsible for the development and maintenance of reports and dashboards utilizing eClinicalworks (eCW), and third-party data repositories. He or she will also interact with multiple disciplines of the Health Center, including but not limited to Clinical, Financial, Quality, Imaging, Regulatory and Operations to ensure reporting needs are met. The responsibilities will include:

· Develop logic for reports and data analysis using various SQL languages (PostgreSQL, Microsoft SQL) along with eCW reporting tools.

· Utilize function calls, SQL stored procedures, multiple table joins, nested select statements and various SQL programming techniques to extract structure and present data.

· Understand Electronic Medical Record (EMR) workflows to translate between eCW to backend databases.

· Conduct thorough data analysis to identify trends, patterns, and opportunities for improvement across various organizational functions.

· Assist in data quality assurance by identifying inconsistencies, cleaning datasets, and implementing best practices for data governance.

· Work with Relevant Healthcare to be able to build custom reports and views based on staff requests.

· Work with third party organizations that deal with providing reports of views to Oak Orchard Health.

· Be a liaison between Oak Orchard Health and Health Efficient Quality IT program.

This position requires a bachelor’s degree in statistics, systems engineering, or a related field. A successful candidate must have two (2) years of data analysis or engineering experience, which includes two (2) years of experience in the following:

· Performing discrete-event simulation studies using FlexSim software to model services or operations;

· Building Key Performance Indicator (KPI) dashboards in Power BI, including productivity and quality measures, supporting leadership data-driven decision-making; and,

· Applying statistical modeling in Minitab.

The position also requires six (6) months of experience using the following tools, software, and platforms:

· Advanced SQL;

· eClinicalworks (eCW) Electronic Medical Record (EMR) system; and

· Python libraries, including pandas, NumPy, and Matplotlib.