Back to jobs

Data Analyst I (CIN)

Pay
$120,135–135,120/yearAnnual period assumed — pay source
Days/Hours: Monday - Friday; 8:30 AM - 5 PM Salary Range: $120,135 - $135,120 (pay will be determined based on experience, preferred qualifications, and education) Our compensation philosophy aims to provide marketable compensation programs and to compensate employees based on relevant experience and education. Individual compensation discussions begin during the hiring process and may occur during job review and promotional opportunities. Salaries vary depending on experience, education and current market for the position. Human Resources determines the external and internal equitable salary for each employee.
Read the full posting
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: FULL_TIME
From the employer’s posting

What you’ll work on

Full posting
  • Design, code and maintain SQL queries used for reporting

  • Design and develop custom data marts in SQL Server for dashboards

  • Run attribution algorithms and scripts that generate reports

  • Integrate EMR data from practice sites and billing vendors into the platform

  • Improve existing reports by optimizing SQL statements

From the employer’s posting
Design, code and maintain SQL queries used within Cerner’s Hosted platform for reporting.
Design and develop custom data marts using SQL server to be used as input for dashboards and reporting requirements.
Run attribution algorithms, maintain and execute scripts used to generate reports.
integrating disparate EMR data sources from various practice sites and billing vendors into the Population Health Platform.
Improve performance and accuracy of existing reports by optimizing existing SQL statements as necessary and establishing best practices.

What you’ll bring

All qualifications

Core experience

  • Bachelor’s Degree in Computer Science, Mathematics, Statistics, other applied science field.
  • 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
  • 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.
  • Ability to turn vague concepts and asks into well-documented and effective business metrics and insights.

Preferred experience

  • Knowledge of PostgreSQL, Python and SSIS a plus.
  • Experience with the Cerner Electronic Medical Record and Population Health applications.
  • 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.
Qualification wording
Bachelor’s Degree in Computer Science, Mathematics, Statistics, other applied science field.
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
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.
Ability to turn vague concepts and asks into well-documented and effective business metrics and insights.
Knowledge of PostgreSQL, Python and SSIS a plus.
Experience with the Cerner Electronic Medical Record and Population Health applications.
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.
Education & alternatives
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 –

Posting record

Report an error

Actively hiringFirst seen by us 11 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 10, 202611 days ago
Recorded sightings
13
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

In line with similar jobs

$120K–$135K against $95K–$145K, the middle half of what similar US postings state.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 11

Similar jobs usually come down between day 5 and day 43.

From 16,008 similar postings that came down. Coming down is not always a hire.

SB Clinical Practice Management is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Excel
  • Oracle
  • PostgreSQL
  • SQL Server
  • SSIS
  • Tableau
Where the posting names them
Preferred Qualifications: - Knowledge of PostgreSQL, Python and SSIS a plus. - Experience with the Cerner Electronic Medical Record and Population Health applications.
SUMMARY: 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.
- 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.
- 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.
- 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.
- 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 prop
- 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 prop -
- - 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
- 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.
- 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, 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.

Your next step

Complete your application on careers-stonybrookmedicinecpmp.icims.com. The employer’s form will show what is required.

Applying through iCIMS

  • You start with your email. New applicants then create a login, and returning ones sign in.
  • Upload your resume before you fill anything in: iCIMS fills some profile fields from it.
  • Check your status on the employer’s iCIMS Dashboard, under Past Job Submittals.

Already applied? Track this application

Job description

View original posting ↗

Overview

Data Analyst I - Stony Brook CPMP - QUALITY PERFORMANCE MANAGEMENT

Schedule: Full time

Days/Hours: Monday - Friday; 8:30 AM - 5 PM 

Salary Range: $120,135 - $135,120 (pay will be determined based on experience, preferred qualifications, and education)

Our compensation philosophy aims to provide marketable compensation programs and to compensate employees based on relevant experience and education. Individual compensation discussions begin during the hiring process and may occur during job review and promotional opportunities. Salaries vary depending on experience, education and current market for the position. Human Resources determines the external and internal equitable salary for each employee. 

The above salary range (or hiring range) represents Stony Brook CPMP’s good faith and reasonable estimate of the range of possible compensation at the time of posting

Responsibilities

SUMMARY:

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 Duties & Essential Functions:

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.
  • Other duties as assigned by management.

Qualifications

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

Physical Demands:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to communicate with patients, staff and medical providers. The employee must be able to exchange accurate information in these situations. This position is largely sedentary and requires the employee to remain stationary for a majority of the day. Any additional physical demands will be outlined and provided by management. 

 

The responsibilities and tasks outlined in this job description are not exhaustive and may change as determined by the needs of CPMP. 

 

StaffCo is a Professional Employer Organization, commonly referred to as a PEO, duly organized and registered under the New York Professional Employer Organization law. StaffCo and SUNY have entered into a professional employer agreement under which StaffCo is the employer of Stony Brook Clinical Practice Management Plan employees and responsible for all aspects of employment, including hirings, promotions, disciplines, terminations, the day-to-day direction and supervision of work, as well as labor relations and collective bargaining. StaffCo is fully responsible for providing all payroll and human resources services, including the payment of wages, collecting and reporting payroll taxes and maintaining any and all employee benefits.  SUNY Stony Brook Hospital is responsible for the operation of the hospital and provision of health care and is the co-employer as is necessary to conduct its responsibilities and for related licensure, regulatory or statutory requirements and obligations.    

 

Given StaffCo’s employment responsibilities, it is deemed the “employer” for employment and labor law purposes.  Thus, the employees are private sector employees of StaffCo, not public sector employees of SUNY.  The private sector nature of the StaffCo employees has been approved by NYS Civil Service and upheld in a decision by the US National Labor Relations Board. 

 

CPMP provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, creed, gender, national origin, age, disability, marital or veteran status, sexual orientation, gender identity or expression, or any other legally protected status.  This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall and transfer, leaves of absence, compensation and training.

 

CPMP expressly prohibits any form of workplace harassment based on race, color, religion, creed, gender, national origin, age, disability, marital or veteran status, sexual orientation, gender identity, or any other legally protected status.  Improper interference with the ability of CPMP’s employees to perform their job duties may result in discipline up to and including discharge.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Days/Hours: Monday - Friday; 8:30 AM - 5 PM Salary Range: $120,135 - $135,120 (pay will be determined based on experience, preferred qualifications, and education) Our compensation philosophy aims to provide marketable compensation programs and to compensate employees based on relevant experience and education. Individual compensation discussions begin during the hiring process and may occur during job review and promotional opportunities. Salaries vary depending on experience, education and current market for the position. Human Resources determines the external and internal equitable salary for each employee.
Location & working pattern

Stony Brook, NY

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.