Data Analyst I (CIN)

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.