Data Analyst I (CIN) - Quality Performance Management
SB Clinical Practice Management · Stony Brook
Job description
About the role
The Data Analyst I joins the SB CIN Population Health IT team at Stony Brook CPMP, working in a fast-paced, multi-disciplinary project team. The analyst acquires data from multiple participants of the CIN Program, ingests, validates and maps it into the Population Health Platform, and develops SQL queries, data marts and analytics. The role also includes technical support for Cerner's Population Health suite (HealtheRegistries, HealtheAnalytics, HealtheEDW, HealtheCare) and contributes to the full software development lifecycle.
Key responsibilities
- Maintain and process all CIN data used for reporting, and support CIN data acquisition and EMR integration projects.
- Integrate disparate EMR data sources from practice sites and billing vendors into the Population Health Platform.
- Design, code and maintain SQL queries and run attribution algorithms and scripts for reports.
- Build custom data marts in SQL Server for dashboards and reporting, and help maintain the CIN report catalog.
- Optimize existing SQL statements and establish best practices, and author technical requirements and design specifications.
- Communicate analysis results clearly to stakeholders and test and validate report outputs and dashboards.
- Take part in requirements, analysis, design, development, testing, training, implementation and support of CIN projects.
Required profile
- 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.
- 3+ years of experience in data mining, large-scale data acquisition, transformation and cleaning of structured and unstructured data.
- Experience with data modelling, database table design and data manipulation and analysis.
- Programming proficiency with analytical platforms and BI systems, and considerable experience with statistical tools and methods.
Required skills
- Proficiency in SQL with SQL Server and Oracle, including stored procedures, joins and optimization of large statements.
- BI and analytical platform expertise such as Business Objects, SQL and Tableau.
- Strong Excel skills.
- Preferred: PostgreSQL, Python, SSIS, HL7, 837, CCDA, Cerner EMR and population health applications, and mentorship of junior analysts.
Schedule is Monday to Friday, 8:30 AM to 5 PM. The salary range is $120,135 - $135,120, set according to experience, qualifications and education.
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in the United States.
Salaries by job title
- Delivery Specialist 330
- Line Cook 264
- Restaurant Host 251
- Dishwasher 241
- Shift Supervisor 226
- Parts Specialist 208
- Retail Service Specialist 176
- Server - Red Robin 140
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 5 days ago
Expires 1 month from now
8 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
SB Clinical Practice Management
Stony Brook