WHO WE ARE:
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.
WHAT WE OFFER:
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.
POSITION SUMMARY:
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:
- Write complex SQL queries to extract data from the EHR
- Build a reusable library of reports in Excel, Crystal, and Cognos
- Develop a deep familiarity with the EHR application and its database schema
- Correctly interpret precise report specifications
- Handle requests from internal customers and clarify their reporting needs
- Maintain and enhance our reporting infrastructure and tools (ETL scripts, view definitions,
automation tools, new self-serve reporting options, etc.)
- Develop and maintain dashboards to monitor NCQA and HEDIS clinical measures.
- Provide help desk assistance to end users on our Medical Management system
- Create and develop forms for the collection of data, and work with other staff install areas to improve the collection data
- 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
Skills Required
- Bachelor's degree in computer science or healthcare-related discipline
- Minimum of 2 years of data analysis/data management experience, preferably in healthcare
- Ability to write complex SQL queries
- Experience with PostgreSQL and Microsoft SQL Server
- Expertise with reporting tools such as Excel, Crystal Reports, or Cognos
- Experience with ETL scripts, view definitions, and reporting automation
- Some experience with scripting languages such as Python or Ruby (or willingness to learn)
- Excellent verbal and written communication skills
- Self-starter with strong problem-solving skills and commitment to CHN's mission
What We Do
Community Healthcare Network 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 13 federally qualified health centers throughout Brooklyn, the Bronx, Queens, and Manhattan, along with 2 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. Our health centers serve neighborhoods that are incredibly diverse. More than 96% of CHN’s patients are people of color, with 46% identifying as African-American/Caribbean, 49% as Hispanic, and 1% as Asian-American. A large number of our patients are immigrants and the working poor. Approximately 29% of CHN’s patients are best served in a language other than English.
