Senior Data Scientist

Oak Orchard Health; Village of Brockport (NY); On-site; USD 110,000 - 140,000; Full time

Job summary

Oak Orchard Health in Brockport, NY seeks a Senior Data Scientist to develop and maintain reports and dashboards using eCW, SQL, and third-party data sources. You will collaborate with Clinical, Financial, Quality, Imaging, Regulatory, and Operations to meet reporting needs.

You will build KPI dashboards in Power BI, understand EMR workflows, and perform data analysis to identify trends and opportunities for improvement across the organization.

Qualifications

• Bachelor’s degree in statistics, systems engineering, or related field.
• Two years of data analysis/engineering experience, incl. KPI dashboards with Power BI.
• Experience with eClinicalWorks (eCW) EMR and SQL.
• Exposure to discrete-event simulation with FlexSim; modeling in Minitab.

Responsibilities

• Develop reports and dashboards using eCW and SQL.
• Create KPIs and dashboards in Power BI for leadership.
• Translate EMR workflows to backend data models.
• Collaborate with Clinical, Financial, Quality, and Operations for reporting needs.
• Coordinate with third-party data providers for Oak Orchard Health.

Skills

Power BI

SQL

eCW EMR

Python (pandas, NumPy, Matplotlib)

KPI dashboards

Data analysis

FlexSim

Minitab

Disrete-event simulation

Education

Bachelor’s degree in statistics or related field

Tools

eClinicalWorks (eCW)

Power BI

Python

SQL

Job description

Description

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.

Requirements

• 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.