CHOICE is a leading Care Management Agency serving Westchester County in New York. We are a dynamic not-for-profit organization which operates in the fast changing environment of healthcare reform. CHOICE's core Mission is to help people restore and maintain their dignity and well-being regardless of their economic, mental, emotional, or physical conditions or limitations. We do this by providing Mental Health Advocacy and Peer Support, Homeless Outreach Programs and Services, and Mental Health Care Management and Support to those in need. Headquartered in White Plains, NY, we are currently a team of about 100 dedicated people and growing.
About the Role:
Reporting to the Director of Strategic Planning, this role provides an exciting opportunity for the right person to join the organization and make a significant contribution.
Data Analytics: Work with the Director of Strategy to build a data strategy which leverages numerous data sources, both internal and external, we have about our clients and the broader environment which we serve. Implement a thoughtful and rigorous approach to collecting, analyzing and presenting data for a number of audiences, including the Senior Management Team as well as various third party constituents in both the public / government and private sectors. This information / data strategy is a key pillar of our broader growth strategy to help more individuals in need and to diversify and expand our services and our revenue base.
Specific skills required include: Exceptional MS Office skills, especially Excel and to a lesser extent Access, as well as experience with business intelligence tools such as MS Power BI or Tableau. A proven track record and ability to manipulate large quantities of data in Excel using formulas, filters and Pivot Tables as well as well as experience extracting data from various sources (Excel, SQL, etc.) into MS Power BI (or other BI tool) to create insightful analyses, visualizations and dashboards.
DBA and Web Portal Development: While the “Data Analytics” piece of the role deals with using data and information to inform our strategic priorities, the DBA and Web aspects of the role deal with the coding and back-end of our data capture and storage approach. CHOICE has many sources of data, one of them being an internally developed application which is a Web enabled user front-end and a SQL database backend. This role will be responsible for managing and enhancing this system as our needs evolve. The first step is to successfully connect the underlying SQL database to MS Power BI so the raw data can be turned into actionable insights (i.e. the “Data Analytics” aspect of the role).
Specific skills required include: information systems knowledge and experience with SQL, HTML and common coding languages and tools used to create functional data collection and reporting tools. You will also need to have experience with AWS (or other web hosting services) and understand how to work with development and production instances of software in a cloud-based environment and be able work collaboratively with the Director of Strategy to implement changes to our existing platform as well as build new tools to support evolving strategic initiatives. It is more important that you have good coding skills than it is that you know a specific coding language.
You have both educational and real world work experience which is closely aligned with the description of both aspects of the role as outlined above. You not only have the technical skills required, but are also able to partner and collaborate with others to see the bigger picture and get the job done. You are easy going, but a logical and analytical thinker with a solid work ethic and the ability to demonstrate thought leadership and own projects and responsibilities and make them your own.
· College degree required with focus on Information Systems / Technology
· Minimum 1-2 years work experience in Data Analysis, Database Administration, and coding for web applications
· Strong MS Office skills – Especially MS Excel, MS Access a plus
· Experience with Business Intelligence tools – preferably MS Power BI
· Understanding of common database types, techniques, languages, etc.
· Some coding experience in HTML, ASP.net, SQL database / web application development a big plus
· Strong project management and delivery / execution skills
· Ability to thrive in an informal, dynamic culture and be comfortable with ambiguity
CHOICE of New Rochelle, Inc.CHOICE is a leading Care Management Agency serving Westchester County in New York. Our Vision is a world where all people have a foundation to meet the challenges of everyday life. We are a dynamic not-for-profit organization which operates in the fast changing environment of healthcare reform. Funded by Medicaid and government grants, we strive to maximize positive human outcomes as we deliver our services to our clients. CHOICE's core Mission is to help people restore and maintain their dignity and well-being regardless of their economic, mental, emotional, or physical conditions or limitations. We do this by providing Mental Health Advocacy and Peer Support, Homeless Outreach Programs and Services, and Mental Health Care Management and Support to those in need.
Westchester County, NY