Please Note: This is a temporary, full-time position. Position Summary: 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.
Qualification Requirements Minimum Qualifications - 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.
NOTE: This position is scheduled for 35 hours per week. The exact work schedule will be determined in consultation with the Director of Data Analysis.
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.
