• To assist in the development of Graham Windham’s Enterprise Client Management System database (ECMS) as it pertains to Graham’s new Article 29I Health Home and Care Coordination services for youth in foster care.
• Develop ETL processes to import client health and services data from external sources into ECMS.
• Develop Management Reports assisting direct care staff and managers to ensure clients are receiving all required services and assessments.
• Reports to the Chief Information Officer and works closely with other members of the IT team and program leadership.

• Bachelor’s degree preferred.
• Experience using Microsoft SQL Server Management Studio to model and develop integrated database solutions, including stored procedures and functions tied to existing databases.
• Experience using Microsoft SQL Server Integration Services to extract data from other systems and integrate it into existing databases using standard data warehousing techniques.
• Experience working with end-users to develop reports using Microsoft Report Builder.
• Comfortable working remotely with remote supervision.
• Prior non-profit experience is a plus.

• Ability to work collaboratively and effectively on a team with peers and across programs.
• Ability to successfully manage several projects simultaneously in a fast-paced work environment.
• Ability to take directions and respond appropriately.
• Ability to work well with people having different cultures, backgrounds, and identities.

• $80-$83K + Merit Pay + Benefits
• Commensurate with experience

In full partnership with families & communities, Graham Windham strives to make a life-altering difference to children, youth and families affected by abuse, neglect and delinquency by providing each child we serve with a strong foundation for life: a safe, loving, permanent family and the opportunity and preparation to thrive in school and in the world. With over 400 full-time, part-time and On-call employees serving children and families in multiple programs throughout Westchester County, Manhattan, the Bronx, Brooklyn and Harlem, Graham Windham provides an exciting & enriching work experience.Graham has pioneered programs for New York City’s children, families and communities for over 200 years.Today, Graham is one of New York City’s leading social services organizations, providing educational and social services to over 4,000 children, young people, and parents in the Bronx, Brooklyn, and Harlem.GRAHAM ‘s IMPACT: 2019 HIGHLIGHT-Graham served 4,128 children, young people, and parents across New York City.-99% of families in our prevention program, who were at risk of having children placed in foster care, remained intact six months after receiving family support services.*95 kids in foster care reunited with their families within one year and 25 were adopted.*Over 90% of children in foster care who were reunified with their families avoided re-entering foster care in the year after reunification.*92% of young people in the Graham SLAM education and career support program graduated from high school by age 21 (compared with 22% of young people across the New York City foster care system).*We helped to lead close to 100 stakeholders in successfully advocating for New York City to invest $10 million in an approach similar to Graham SLAM for young people across NYC through the Fair Futures campaign.