> Markdown version of [/jobs/ext/4691525-data-analyst-i-cin](https://www.wearedevelopers.com/jobs/ext/4691525-data-analyst-i-cin). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst I (CIN) - **Company:** SB Clinical Practice Management - **Location:** Stony Brook, NY, United States - **Experience:** Experienced - **Salary:** $120,135 - $135,120 - **Contract:** Permanent contract - **Skills:** Cerner, Microsoft Excel, Data Analysis, Big Data, Computer Programming, Databases, Data Mart, Data Mining, Data Structures, Database Queries, Information Retrieval, Python (Programming Language), PostgreSQL, Microsoft SQL Server, Oracle (Applications), Raw Data, Standard Sql, Software Engineering, Software Systems, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, System Software, Systems Integration, Tableau (Software), Unstructured Data, Data Processing, Data Ingestion, Electronic Medical Records, Sap Business Objects, Information Technology, Statistics Packages, Data Analytics, Health Level Seven International - **Published:** November 12, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=b03880f0a0a4d20f ## About the Role * 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. ## Description 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, 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.