Data Analytics and Reporting Team Intern

City of New York • New York, NY

2d • Onsite

About The Position

SUMMER 2026 INTERNSHIP The 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. MOCS team members operate in a collaborative, service-oriented environment, where flexibility and ability to achieve results are valued. All managers lead teams and lines of service, assuming increasing levels of responsibility for the agency’s success. 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.

Requirements

• 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.

Nice To Haves

• Candidates pursuing degrees in Data Science, Analytics, Computer Science, AI, Statistics, Business, Finance, Economics, or a related field are strongly encouraged to apply.

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.

What This Job Offers

• Career Level: Intern
• Education Level: No Education Listed