Data Analytics and Reporting Team Intern
City of New York, New York, NY, United States
Data Analytics and Reporting Team Intern
Part‑time
Agency: Mayor's Office of Contract Services (MOCS)
Compensation: USD 17.5 - USD 18
SUMMER 2026 INTERNSHIP
Mayor’s Office of Contract Services (MOCS) is a New York City oversight and service agency that manages procurement citywide, from planning and release of agency solicitations to payment of vendors. Annually, agencies procure billions in products and services from a diverse pool of vendors that represent various industries. MOCS therefore aims to ensure that the procurement process remains fair, transparent, efficient, and cost‑effective. MOCS makes it easier to do business through use of end‑to‑end technology tools, increases transparency by publication of enriched data and hosting public hearings, and strengthens procurement operations by providing direct assistance and resources to all stakeholders. MOCS also partners with agencies and vendors to identify areas for policy reform, resulting in ongoing process improvement to reduce administrative burdens and increase the positive impact of services on communities. The MOCS Director serves as the City Chief Procurement Officer.
The Data Analytics and Reporting Team provides strategic, analytical, and reporting support to drive data‑informed decision‑making at MOCS. The team collaborates closely with stakeholders across the agency to develop and enhance data‑driven insights, manage key reporting initiatives, and streamline data processes. We produce compliance reports, ad‑hoc reports, and business intelligence (BI) tools to ensure the accuracy and accessibility of critical information. Through data analysis, visualization, and strategic reporting, the team supports MOCS in achieving its operational and policy objectives.
Responsibilities
Support the Associate Director (DAR) and the team in developing the Annual Procurement Indicators Report by conducting data analysis using Excel pivot tables, creating impactful data visualizations, ensuring data quality, and leveraging Power Query for advanced data management.
Assist the data team in managing regular compliance reporting by performing data quality checks, coordinating with agencies and vendors, and ensuring timely follow‑ups.
Participate in MOCS Data Cabinet meetings to enhance understanding of DAR’s reporting outputs and data analysis capabilities across the agency.
Utilize project management tools (e.g., Monday.com) to track and report on the progress of reporting tasks.
Attend internal and external meetings, take detailed notes, and manage follow‑up actions related to data initiatives.
Support the development of basic BI visualizations to improve data accessibility and decision‑making using Power BI or other BI tools.
Qualifications
Proficiency in Excel, including pivot tables, formulas, data visualization, and Power Query for advanced data management.
Experience in data analysis with strong skills in data manipulation; SQL proficiency is highly valuable.
Familiarity with Power BI or other business intelligence tools for data visualization and reporting.
Strong analytical skills with excellent written and verbal communication.
Team‑oriented mindset with a willingness to learn and contribute to data‑driven decision‑making in City government.
Current enrollment in a degree program in Data Science, Analytics, Computer Science, AI, Statistics, Business, Finance, Economics, or a related field.
This internship is on‑site.
The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual’s sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.
#J-18808-Ljbffr
Part‑time
Agency: Mayor's Office of Contract Services (MOCS)
Compensation: USD 17.5 - USD 18
SUMMER 2026 INTERNSHIP
Mayor’s Office of Contract Services (MOCS) is a New York City oversight and service agency that manages procurement citywide, from planning and release of agency solicitations to payment of vendors. Annually, agencies procure billions in products and services from a diverse pool of vendors that represent various industries. MOCS therefore aims to ensure that the procurement process remains fair, transparent, efficient, and cost‑effective. MOCS makes it easier to do business through use of end‑to‑end technology tools, increases transparency by publication of enriched data and hosting public hearings, and strengthens procurement operations by providing direct assistance and resources to all stakeholders. MOCS also partners with agencies and vendors to identify areas for policy reform, resulting in ongoing process improvement to reduce administrative burdens and increase the positive impact of services on communities. The MOCS Director serves as the City Chief Procurement Officer.
The Data Analytics and Reporting Team provides strategic, analytical, and reporting support to drive data‑informed decision‑making at MOCS. The team collaborates closely with stakeholders across the agency to develop and enhance data‑driven insights, manage key reporting initiatives, and streamline data processes. We produce compliance reports, ad‑hoc reports, and business intelligence (BI) tools to ensure the accuracy and accessibility of critical information. Through data analysis, visualization, and strategic reporting, the team supports MOCS in achieving its operational and policy objectives.
Responsibilities
Support the Associate Director (DAR) and the team in developing the Annual Procurement Indicators Report by conducting data analysis using Excel pivot tables, creating impactful data visualizations, ensuring data quality, and leveraging Power Query for advanced data management.
Assist the data team in managing regular compliance reporting by performing data quality checks, coordinating with agencies and vendors, and ensuring timely follow‑ups.
Participate in MOCS Data Cabinet meetings to enhance understanding of DAR’s reporting outputs and data analysis capabilities across the agency.
Utilize project management tools (e.g., Monday.com) to track and report on the progress of reporting tasks.
Attend internal and external meetings, take detailed notes, and manage follow‑up actions related to data initiatives.
Support the development of basic BI visualizations to improve data accessibility and decision‑making using Power BI or other BI tools.
Qualifications
Proficiency in Excel, including pivot tables, formulas, data visualization, and Power Query for advanced data management.
Experience in data analysis with strong skills in data manipulation; SQL proficiency is highly valuable.
Familiarity with Power BI or other business intelligence tools for data visualization and reporting.
Strong analytical skills with excellent written and verbal communication.
Team‑oriented mindset with a willingness to learn and contribute to data‑driven decision‑making in City government.
Current enrollment in a degree program in Data Science, Analytics, Computer Science, AI, Statistics, Business, Finance, Economics, or a related field.
This internship is on‑site.
The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual’s sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.
#J-18808-Ljbffr