Data Analyst Consultant, Systems and Data (DCP)

The Division of Contracts and Purchasing (DCP) is committed to delivering excellent service to children and families, schools, program offices, and vendors, while promoting equitable access to goods and services contracts for Minority- and Women-Owned Business Enterprises (MWBEs). DCP oversees all procurement activities for purchases of goods (over $15,000) and services (over $25,000) used in school buildings and central offices. With latitude for independent initiative and judgment, the Data Analyst Consultant will be responsible for developing and overseeing data reporting procedures and performing complex analyses related to procurement and purchasing. The Data Analyst Consultant will provide analytical support to the Procurement Units by creating project trackers, management reports, and dashboards. The Data Analyst Consultant will become knowledgeable about procurement processes and gain familiarity with many of NYCPS's operational areas, including, but not limited to, Early Childhood, Community Schools, Transportation, School Food, and Special Education. Performs related work. Reports to: Director, Data Analysis, DCP Direct Reports: N/A Key Relationships: Will interact with all levels of DCP, the Office of Supplier Diversity (OSD), the Division of Instructional and Information Technology (DIIT), the Office of Technology and Innovation (OTI), and the Mayor's Office of Contract Services. Responsibilities

• Evaluate existing reporting methods, recommend improvements, and implement approved changes; develop new reporting methods based on assessments of new reporting requests.
• Analyze and organize large datasets related to purchasing and contracts using Microsoft Excel, SQL, and Power BI.
• Analyze and summarize data through presentations, data visualizations, and written reports for staff and leadership at all levels.
• Develop and produce contract spending reports at the request of the Director of Data Analysis, various program offices, and senior NYCPS and City officials.
• Develop and execute quantitative testing models to ensure data integrity in reporting.
• Utilize and become proficient in systems such as PASSPort, FMS, the Contract Tracking System (CTS), the Contract Processing System (CPS), and FAMIS. Assist with documenting issues and gathering requirements for system enhancements.
• Lead data cleansing and standardization efforts within the Contract Tracking System (CTS), including ongoing data quality reviews.
• Enhance tracking systems for new and replacement procurements, and monitor the progress and cycle times of procurements currently underway.
• Provide information to the Mayor's Office of Contract Services for its annual procurement indicators report and other publicly reported data.
• Support or manage a variety of special projects requiring a high degree of research, analysis, strategic thinking, and problem-solving.
• Perform related duties as assigned.

• A bachelor's degree from an accredited college and two (2) years of experience in data analysis; or
• High school graduation or its equivalent and six (6) years of experience in data analysis; or
• Education and/or experience equivalent to either of the above. However, all candidates must have at least one (1) year of experience as described in the first qualification above.

Plus

• High proficiency in Microsoft Excel.
• Proficiency in Microsoft Access, SQL Server, and Power BI.
• Experience in data analytics and reporting, with the ability to perform independent research, data collection, and analysis.
• Experience maintaining data integrity and improving processes to increase data quality.
• Experience extracting, cleaning, and presenting data from diverse enterprise systems.
• Strong organizational skills with exceptional attention to detail.
• Excellent oral and written communication skills.

Preferred

• Self-starter with a sense of urgency who can adapt to changing priorities and work effectively in a fast-paced environment.
• Ability to collaborate effectively with a diverse team of stakeholders.
• Knowledge of financial, accounting, and procurement management systems; experience with FMS and/or PASSPort is preferred.
• Understanding of, or interest in, public sector procurement.
• Demonstrated commitment to education and public service.

Salary: $40 hourly rate (Internal candidates who are selected for this position and who currently hold comparable or less senior positions within the DOE will not earn less than their current salary.) Please include a resume and cover letter with your application. NOTE: The filling of all positions is subject to budget availability and/or grant funding.

• New York City Residency is NOT Required * We encourage all applicants from the New York City tri-state area to apply.

The New York City school system is the largest in the country, serving nearly one million students and more than 75,000 teachers, with an annual budget of $38 billion.