Share Email Opening

Data Analyst- CIN 

EOE Statement We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law.  

Position Overview

The Data Analyst will be a member of the SB CIN Population Health IT Team. This individual will work in a fast-paced environment as part of a multi-disciplinary project team acquiring data from multiple participants of the CIN Program assisting with data ingestion, validation and mapping into the Population Health Platform.  The Analyst will be responsible for developing SQL queries used to generate reports, create data marts and perform analytics against the data that has been successfully loaded into the platform.

The successful candidate will bring a balance of creative problem solving, hands-on data analytics, manipulation and practical software integration skills. The candidate will also be responsible for helping provide technical support for Cerner’s Population Health Management suite of products, HealtheRegistries, HealtheAnalytics, HealtheEDW and HealtheCare.

The Data Analyst will be responsible to maintain up to date knowledge and understanding of Managed Care and ACO program measure specifications and compliance requirements.

This team member will participate and contribute to all CIN software development project lifecycle tasks including requirements, analysis, solution design, development, testing, training, implementation and support. 

The Analyst will provide support in making strategic data-related decisions by analyzing data, finding actionable insights, and working with leaders and stakeholders to drive change.

Job Responsibilities:

Analyst responsible for maintaining and processing all CIN Data used for Reporting.

Support the CIN data acquisition and EMR integration projects.  Assist the team with technical on-boarding projects, integrating disparate EMR data sources from various practice sites and billing vendors into the Population Health Platform.

Design, code and maintain SQL queries used within Cerner’s Hosted platform for reporting.

Run attribution algorithms, maintain and execute scripts used to generate reports.

Upload required report files to the Population Health platform.

Design, code and operationalize reports as requested by the end user for the purpose of quality, process monitoring or regulatory requirements.  This data will be extracted from multiple source systems, normalized and ultimately provided in the format requested by the CIN business team. 

Design and develop custom data marts using SQL server to be used as input for dashboards and reporting requirements.

Assist in the creation and maintenance of the CIN report catalog. 

Improve performance and accuracy of existing reports by optimizing existing SQL statements as necessary and establishing best practices. 

Author technical requirements and design specifications as needed.

Communicate results of data analyses in a clear and effective manner to appropriate stakeholders.

Test and validate all report outputs and visualization dashboards using various queries and tools.

Work in a high paced team environment with the ability to multitask when required based on project plan and business priorities.

Category Information Technology  
Exempt/Non-Exempt Exempt  
Location St. James NY  
Full-Time/Part-Time Full-Time  
Position Requirements

Required Qualifications:

Bachelor’s Degree in Computer Science, Mathematics, Statistics, other applied science field.

Minimum of 5 years professional experience in a technical/data analyst role in a data driven environment.

Proficient knowledge of SQL –

Working with SQL server and Oracle; able to write sound, efficient, and proper SQL statements ensuring stability, reliability, and performance of databases.

Experience with stored procedures and able to query complex datasets and derive conclusions, including using all types of joins between multiple tables.

Skilled at optimizing large complicated SQL statements and knowledge of best practices.

3+ years’ experience in data mining, large scale data acquisition, transformation, and cleaning, both structured and unstructured data.

Experience with data modelling, data structure principles and designing database tables that facilitate efficient information retrieval.

Competency in data manipulation and analysis; accessing raw data in varied formats with different methods and analyzing and processing data.

The Data Analyst must have programming proficiency with analytical platform software and BI systems expertise including but not limited to Business Objects, SQL and Tableau.

Considerable experience with statistical tools and methods to incorporate statistical results into analyses.

Ability to turn vague concepts and asks into well-documented and effective business metrics and insights.

Strong knowledge and comfort level with Excel.

Preferred Qualifications:

Knowledge of PostgreSQL, Python and SSIS a plus.

Experience with the Cerner Electronic Medical Record and Population Health applications.

Mentor/direct junior programmer analyst team member(s).

Knowledge of HL7 transactions, Health Care Claims (837), and/or CCDA a plus.

Knowledge of, and exposure to, established standards of care presented by CMS, NCQA, AHRQ, IOM, The Join.

Experience with Tableau or other data statistical, visualization, and predictive modeling software.

Electronic health record review and abstraction ability and experience.

Shift Days  
Tags Benefits,401K, PTO, Life Insurance. Competitive Salary. This is a hybrid position  
Salary Range $60,000-$85,000 annually  
Position Data Analyst- CIN  
Open Date 1/16/2024  

This position is currently not accepting applications.

To search for an open position, please go to


Other Jobs Within Same Category
Business Process Analyst- Commack in Suffolk County, NY
Posted on: 4/23/2024
[Apply Now]

Other Jobs Within 60 Miles
Business Process Analyst- Commack in Suffolk County, NY
Posted on: 4/23/2024
[Apply Now]

Certified Nurse Midwife in Center Moriches, NY
Posted on: 3/7/2024
[Apply Now]

Clinical Operations Manager-Cardiology in East Setauket, NY
Posted on: 3/21/2024
[Apply Now]

CRNA in Greenport, NY
Posted on: 3/7/2024
[Apply Now]

LPN in Mattituck , New York
Posted on: 3/7/2024
[Apply Now]

Follow us

AppOne.comTM 1999-2021 HR Services, Inc.
Click here for technical assistance.