Data Analytics and Reporting Team Analyst Intern

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. Interns must conduct all duties relevant to their position in their assigned division and demonstrate an advanced level of expertise. This position requires a focus on aligning daily operations to the agency's strategic priorities, engage stakeholders in planning and ensure performance using well-defined success metrics and project management strategies. Interns are expected to deliver timely and quality work products and services, participate in ongoing improvement activities, proactively deepen their knowledge of procurement and government operations, and will use modern technology software and hardware to complete daily duties. This position must collaborate with other team members to implement projects, help to maintain and/or analyze operational data, and interact with external stakeholders. 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. Internship Responsibilities (Data Analytics and Reporting - DAR) - Data Analysis and Reporting: 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. - Compliance Reporting Support: Assist the Data team in managing regular compliance reporting by performing data quality checks, coordinating with agencies and vendors, and ensuring timely follow-ups. - MOCS Data Cabinet Engagement: Participate in MOCS Data Cabinet meetings to enhance understanding of DAR's reporting outputs and data analysis capabilities across the agency. - Project Management: Utilize project management tools (e.g., Monday.com) to track and report on the progress of reporting tasks. - Meeting Participation: Attend internal and external meetings, take detailed notes, and manage follow-up actions related to data initiatives. - Power BI and BI Tools: Support the development of basic BI visualizations to improve data accessibility and decision-making. Qualifications / Special Skills / Areas of Study - Excel & Data Management: Proficiency in Excel, including pivot tables, formulas, data visualization, and Power Query for advanced data management. - Data Analysis & SQL: Experience in data analysis with strong skills in data manipulation; SQL proficiency is highly valuable. - Power BI & BI Tools: Familiarity with Power BI or other business intelligence tools for data visualization and reporting. - Attention to Detail & Communication: Strong analytical skills with excellent written and verbal communication. - Collaboration & Learning: Team-oriented mindset with a willingness to learn and contribute to data-driven decision-making in City government. Preferred Fields of Study: Candidates pursuing degrees in Data Science, Analytics, Computer Science, AI, Statistics, Business, Finance, Economics, or a related field are strongly encouraged to apply.

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.