Data Analyst I (CIN)

SB Clinical Practice Management•Town of Brookhaven, NY

4d•$120,135 - $135,120

About The Position

The Data Analyst will be a member of the SB CIN Population Health IT Team, working in a fast-paced, multidisciplinary project environment. The role supports acquisition of data from CIN Program participants, including data ingestion, validation, and mapping into the Population Health Platform. The analyst develops SQL queries to generate reports, create data marts, and perform analytics on data loaded into the platform. The position also provides technical support for Cerner Population Health Management products, including HealtheRegistries, HealtheAnalytics, HealtheEDW, and HealtheCare, and maintains current knowledge of Managed Care and ACO measure specifications and compliance requirements. The analyst contributes across the CIN software development lifecycle, from requirements and analysis through solution design, development, testing, training, implementation, and support. The role also supports strategic data-related decisions by analyzing data, identifying actionable insights, and collaborating with leaders and stakeholders to drive change.

Requirements

Bachelor’s degree in Computer Science, Mathematics, Statistics, or another applied science field.
At least 5 years of professional experience in a technical or data analyst role in a data-driven environment.
Proficient knowledge of SQL and experience working with SQL Server and Oracle; ability to write sound, efficient SQL statements that support database stability, reliability, and performance.
Experience with stored procedures and querying complex datasets to derive conclusions, including use of all types of joins across multiple tables.
Skill optimizing large, complicated SQL statements and knowledge of best practices.
At least 3 years of experience in data mining and large-scale data acquisition, transformation, and cleaning of structured and unstructured data.
Experience with data modeling, data-structure principles, and designing database tables for efficient information retrieval.
Competency in data manipulation and analysis, including accessing raw data in varied formats using different methods and analyzing and processing it.
Programming proficiency with analytical platform software and expertise in BI systems, including Business Objects, SQL, and Tableau.
Considerable experience with statistical tools and methods and incorporating statistical results into analyses.
Ability to turn vague concepts and requests into well-documented, effective business metrics and insights.
Strong knowledge of and comfort with Excel.

Nice To Haves

Knowledge of PostgreSQL, Python, and SSIS.
Experience with the Cerner Electronic Medical Record and Population Health applications.
Ability to mentor junior programmer analyst team members.
Knowledge of HL7 transactions, healthcare claims (837), and/or CCDA.
Knowledge of or exposure to established standards of care presented by CMS, NCQA, AHRQ, IOM, and The Joint Commission.
Experience with Tableau or other statistical, visualization, and predictive modeling software.
Experience with electronic health record review and abstraction.

Responsibilities

Maintain and process CIN data used for reporting.
Support CIN data acquisition and EMR integration projects, including technical onboarding and integration of disparate EMR data sources from practice sites and billing vendors into the Population Health Platform.
Design, code, and maintain SQL queries in Cerner’s hosted platform for reporting.
Run attribution algorithms and maintain and execute scripts used to generate reports.
Upload required report files to the Population Health Platform.
Design, code, and operationalize reports for quality, process monitoring, and regulatory requirements, extracting data from multiple source systems, normalizing it, and providing it in the format requested by the CIN business team.
Design and develop custom SQL Server data marts for dashboards and reporting.
Assist in creating and maintaining the CIN report catalog.
Improve the performance and accuracy of existing reports by optimizing SQL statements and establishing best practices.
Author technical requirements and design specifications as needed.
Communicate data-analysis results clearly and effectively to appropriate stakeholders.
Test and validate report outputs and visualization dashboards using queries and other tools.
Contribute to CIN software development lifecycle activities, including requirements, analysis, solution design, development, testing, training, implementation, and support.
Analyze data, identify actionable insights, and work with leaders and stakeholders to support strategic decisions and drive change.
Work in a fast-paced team environment, multitasking as needed based on project plans and business priorities.
Perform other duties as assigned by management.