ABOUT NEW YORK CARE COORDINATION PROGRAM (NYCCP) and HEALTH HOMES OF UPSTATE NEW YORK (HHUNY): New York Care Coordination Program (NYCCP) is a not-for-profit organization governed by a Board of Directors comprised of leaders from multiple counties, provider agencies, and consumers of behavioral health services. Its primary aim is to improve outcomes for individuals with serious behavioral health conditions through supporting training, education and consultation in areas including person-centered care coordination and through management and administration of New York State’s Health Home program. Health Homes of Upstate New York (HHUNY) is a Management Services Organization providing management and administrative services to affiliated adult and child serving Health Homes covering 54 counties across Upstate New York. A health home isn’t a physical location. It’s an extensive network of services for Medicaid recipients. HHUNY care managers provide the support individuals need to manage all of their medical services and connects them to other community supports, such as housing, food, and legal services, so that they can live their healthiest lives.
ABOUT THE POSITION:
The Data Analyst (SQL / Tableau) delivers focused reporting and business analytics for our client. This analyst partners with the requestor to understand business problems/challenges and creates meaningful and creative solutions to address these problems/challenges. Primary responsibilities include development of departmental and ad hoc reports in SQL tools as well as Tableau.
Ideal candidates will be within driving distance of Rochester, NY
SPECIFIC RESPONSIBILITIES INCLUDE:
- Develops reports and data analysis using advanced functionality within Microsoft SQL tools, Tableau or other reporting applications.
- Designs, develops, delivers and maintains efficient reports, visualizations and dashboard solutions to enhance end users understanding of information.
- Prepares and presents concise summaries to explain findings, limitations and recommendations based upon actionable insight.
- Act as subject matter expert in discussions with various source systems, other subject matter experts and downstream users to identify, define and implement data requirements.
- Assist in reviewing and analyzing DOH, Security and HIPAA requirements; provide updates to IT systems to accommodate.
- Provide support as directed to assist other internal teams in accomplishing work as it relates to HHUNY systems.
- Perform other duties as assigned.
REQUIRED COMPETENCIES: To be successful in this position, you will need to be competent in:
- Understanding of information systems design and configuration
- Ability to manage multiple small to medium size projects
- Excellent communication and customer service skills
- Ability to communicate analytical and technical information in manner easily understood by workforce members and customers with non-technical experience
- Self-driven and able to prioritize work appropriately
- Enthusiastic approach to innovation and program development
- Comprehensive knowledge of Healthcare delivery systems a plus
Required software, applications, and systems:
- Knowledge of database design techniques and advanced SQL
- Tableau
- Microsoft Visual Studios SSIS
- Microsoft SSRS
- Microsoft Access with VB experience
- Ability to support Excel Macros
