Senior Data Scientist

Oak-Orchard-Community-Health-Center,-Inc; Town of Clarkson (NY); On-site; USD 120,000 - 170,000; Full time

Job summary

Oak Orchard Community Health Center, Inc. (Oak Orchard Health) seeks a Senior Data Scientist in Brockport, NY to develop and maintain reports and dashboards using eClinicalWorks (eCW) and third-party data sources.

The role partners with Clinical, Financial, Quality, Imaging, Regulatory and Operations teams to ensure reporting needs are met, translate EMR workflows, and apply data analytics to improve care delivery and decision-making.

Qualifications

• Bachelor’s degree in statistics, systems engineering, or a related field.
• Two years of data analysis or data engineering experience.
• Experience with SQL (PostgreSQL, MS SQL) and reporting tools.
• Experience developing KPI dashboards (Power BI).
• Experience with discrete-event simulation (FlexSim) and statistical modeling (Minitab); EMR data integration.

Responsibilities

• Develop reports and data analyses using SQL and eCW reporting tools.
• Build KPI dashboards in Power BI to support leadership decisions.
• Translate EMR workflows between eCW and backend data stores.
• Analyze data to identify trends and opportunities for improvement.
• Ensure data quality and governance through cleaning and validation.
• Collaborate with Clinical, Financial, Quality, Regulatory and Operations teams.
• Coordinate with third-party data providers to deliver reports.

Skills

KPI dashboards

Data analysis

SQL

Statistical modeling

Python (pandas, NumPy, Matplotlib)

Education

Bachelor’s degree in statistics or related field

Tools

Power BI

FlexSim

Minitab

eClinicalWorks (eCW)

SQL (PostgreSQL / MS 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.