Programmer/Analyst

AGENCY BACKGROUND:

Northern Manhattan Improvement Corporation (NMIC) is a community-based, not-for-profit organization founded in 1979. NMIC has grown into a leading multi-service agency with over 140 staff members serving New York City with a focus on upper Manhattan and the Bronx. Our mission is to serve as a catalyst for positive change in the lives of the people in our community on their paths to secure and prosperous futures. Integration is the cornerstone of NMIC’s programs, and our staff can identify and address a broad array of immediate needs through comprehensive crisis intervention services. With their matters resolved, clients move seamlessly to capacity building services through our holistic programs designed to transition individuals and families to self-sufficiency.

• Our Legal, Organizing, Advocacy, and Weatherization programs meet community member’s basic needs including legal representation, immigration assistance, housing advocacy, tenant organizing, financial services, DV and health related matters
• Our Education & Career Services program impacts individual community members with the practical tools necessary to build secure and prosperous futures

Job Title: Programmer/Analyst

Department: Administration

Reports To: Assistant Director for Program Evaluation

Location: Hybrid - 1 day in office per week (office site is 45 Wadsworth Avenue, New York, N.Y. 10033)

FLSA Status: Exempt

SUMMARY OF RESPONSIBILITIES:

The Programmer/Analyst is a newly created role at NMIC, which will work closely with the Data Systems Manager to enhance NMIC’s current CRM application, ClientTrack, and will support the Assistant Director for Program Evaluation with analyzing internal and external data for funder reporting and program improvement. ClientTrack is a cloud-based system developed by Eccovia Solutions on Microsoft technology.

NMIC is currently engaged in a comprehensive review of our ClientTrack system which has identified the need for significant redevelopment to better align with program operations. This new role will expand our internal capacity for customized redevelopment for each of NMIC’s 23 programs. The Assistant Director for Program Evaluation will serve as the primary contact point translating program needs to functionality requests, with the Programmer/Analyst working alongside the Data Systems Manager to implement technical solutions. As redevelopment progresses, there will be an increased need for quality assurance, data analysis and report design, which will also fall under the Programmer/Analyst role.

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES:

Implementation

• Design and implement new and/or customize existing ClientTrack functionality to meet program needs, using ClientTrack’s own development platform, which partially uses T-SQL and JavaScript syntax.
• Improve performance of existing code, as needed. Apply native platform functionality effectively to promote efficient, comprehensive, reliable, and valid data entry (e.g., form validation rules, pick lists, conditional logic, etc.).
• Test new developments and modifications before they go live.
• Consult on, and implement as necessary, solutions using other technical tools. NMIC’s operation is based on Microsoft technology, so integration with other Microsoft products is likely in the future.

Maintenance

• Fix problems in existing ClientTrack functionality while coordinating with the Data Systems Manager and liaise with the software provider on bugs and system errors.
• Document all ClientTrack platform customization to facilitate ongoing troubleshooting and upgrades.
• Conduct large scale data cleaning in identified problem areas of the data.
• Develop and follow a schedule to ensure a high level of data quality.

Data Analysis/Reporting

• Assist with improving the efficiency of report generation processes.
• Develop data visualization tools that move beyond required deliverables to monitor key outputs and impacts in support of broader program management and planning.
• Link public data sets (e.g. NYC OpenData resources) and NMIC records (e.g., to tie housing maintenance code violations to client addresses to identify repair needs).

Additional related responsibilities may be assigned.

QUALIFICATIONS:

• Relevant professional experience. Bachelor’s degree in a related field and relevant professional certifications are preferred.
• Solid understanding of database concepts.
• Proven recent experience with programming, and relational database, preferably Visual Studio and SQL Server. (ClientTrack experience is a positive, but otherwise qualified candidates with no ClientTrack experience are encouraged to apply).
• Proficiency in T-SQL.
• Experience working with JavaScript. RegEx knowledge is a positive.
• Experience with analyzing large data sets; data visualization experience is a positive.
• Strong ability to communicate technical concepts to non-technical staff.
• Experience with software documentation/technical writing.
• Experience prioritizing competing demands.
• Ability to implement simple solutions to complex problems.
• Excellent problem-solving skills, including ability to anticipate problems and use appropriate judgment to plan solutions.
• Strong analytical, organization, communication, and data management skills.
• Interest in applying data and technical design to enhance nonprofit mission.

SALARY/BENEFITS:

NMIC offers a competitive salary based on experience and education as well as a comprehensive generous benefits package: medical, dental, life, and disability insurance are included; paid time off, including 20 vacation days, 15 sick days, 5 personal days, and 12 agency holidays; a 401k with agency contribution; and other benefits.

NMIC IS AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER:

NMIC is an Equal Opportunity Employer and actively encourages candidates of diverse backgrounds to apply for employment. Applicants must meet the minimum qualification requirements. A combination of education and experience will be considered unless specifically stated otherwise.