Data Management Analyst

Data Management Analyst

Community Healthcare Network (CHN) is a not-for-profit organization providing more than 65,000 New Yorkers with primary and behavioral healthcare, dental, nutrition, wellness, and needed support services.

Our network is made up of 14 federally qualified health centers throughout Brooklyn, the Bronx, Queens, and Manhattan, along with a fleet of mobile vans that bring health services to underserved people in need throughout New York City. We provide judgment-free, high-quality healthcare, without regard to race, religion, orientation, gender identity, immigration status or ability to pay. We turn no one away.

Growth and development: Access to various healthcare professionals and benefits to deepen understanding and interest in the various disciplines involved in community health programming.

Supportive team culture: Be a part of an interdisciplinary environment where your ideas and work are valued and encouraged.

Comprehensive benefits: Including health, dental and vision insurance, retirement plans, employee assistance programming and more.

The Data Management Analyst is responsible for assisting with harnessing the data available in our EHR system to improve our clinics' operations and our patients' health. The Data Analyst plays a key role by extracting data from the EHR and transforming it into intelligent, actionable reports.

The position involves understanding the data needs of agency staff, mastering the intricacies of our EHR system (front-end and back-end), writing complex SQL queries, presenting data in user-friendly ways, and automating reports where possible. In addition to PostgreSQL and Microsoft SQL Server, the data analyst will use a variety of technologies, from Excel to Crystal Reports to COGNOS, as well as some Ruby scripting and other automation tools.

Essential functions:

1. Write complex SQL queries to extract data from the EHR
2. Build a reusable library of reports in Excel, Crystal, and Cognos
3. Develop a deep familiarity with the EHR application and its database schema
4. Correctly interpret precise report specifications
5. Handle requests from internal customers and clarify their reporting needs
6. Maintain and enhance our reporting infrastructure and tools (ETL scripts, view definitions, automation tools, new self-serve reporting options, etc.)
7. Develop and maintain dashboards to monitor NCQA and HEDIS clinical measures.
8. Provide help desk assistance to end users on our Medical Management system
9. Create and develop forms for the collection of data, and work with other staff install areas to improve the collection data
10. Perform other related duties as assigned by supervisor

Education & experience required:

• Bachelor's degree in computer science or other healthcare related discipline
• Minimum of 2 years of experience, including a focus on data analysis and other skills relevant to data management, preferably in healthcare

Knowledge, skills & abilities required:

• Excellent logical reasoning and problem-solving skills
• Ability to write complex SQL queries
• General computer wizardry and ability to learn new programs quickly
• Expert with one or more of the following: Excel, Crystal, Cognos, or similar reporting tool
• Some experience with scripting languages such as Python or Ruby, or a desire and aptitude to learn
• Excellent verbal and written communication skills
• Self-starter and impact player
• Interest in and commitment to CHN's mission