The Technical Business Analyst will provide technical support to the team responsible for the oversight and management of the New York City’s three major social services benefit programs: Cash Assistance, Supplemental Nutrition Assistance Program, and Medicaid along with DHS services for the homeless. The Technical Business Analyst will assist in the optimizing reporting, data collection strategies and documentation. He/She will run regularly scheduled reports and provide quality assurance for the integration of various data sources when automating new databases. This will include verifying source file data integrity; reviewing and troubleshooting upload errors; and verifying successful uploads. He/She will also be responsible for the creation of logic documentation that will enable the project to be passed on to the permanent team for future changes.
Additionally, the successful candidate will develop data collection tools, assist with data mining and data visualization projects, construct queries of the agency’s information systems in response to internal and external data requests, assist the division in the formation of new reports to support policy decision-making, and work to effectively communicate the results of these analyses to agency staff and partners. S/he may also be called upon to conduct interagency data matches as needed. The selected candidate must have a some technical background in query-building using SQL and be comfortable in using large datasets.