What are the responsibilities and job description for the Data Analytics and Reporting Team Intern position at City of New York?
Company Description
Job Description
**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.
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.
This is an on-site internship.
TO APPLY
External applicants, please go to and search for Job ID #772666
Current City Employees may apply via Employee Self Service (ESS) Click on Recruiting Activities/Careers and Search for Job ID #772666
ADDITIONAL INFORMATION
To best serve the City we represent, Mayor's Office of Contract Services (MOCS) seeks individuals from a variety of backgrounds who can bring different perspectives to contribute to the work of the office. MOCS also seeks candidates who want to contribute to a work environment that values teamwork, inclusion and respect.
MOCS recognizes the unique skills and strengths gained through military service. Veterans and service members of the U.S. Armed Forces are strongly encouraged to apply. Special accommodations provided to applicants with disabilities. Please contact MOCS Disability Service Facilitator at or to request an accommodation.
COLLEGE AIDE (ALL CITY DEPTS) - 10209
Qualifications
For Assignment Level I:
Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school.
For Assignment Level II (Information Technology):
Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school with a specific course of study in information technology, computer science, management information systems, data processing, or closely related field, including or supplemented by 9 semester credits in an acceptable course of study.
For Assignment Level III (Information Technology Fellow):
Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school with a specific course of study in information technology, computer science, management information systems, data processing, or other area relevant to the information technology project(s) assigned, including or supplemented by 9 semester credits in an acceptable course of study. Appointments to this Assignment Level will be made by the Technology Steering Committee through the Department of Information Technology and Telecommunications.
SPECIAL NOTE
Maximum tenure for all Assignment Levels in the title of College Aide is 6 years. No student shall be employed more than half-time in any week in which classes in which the student is enrolled are in session. Students may be employed full-time during their vacation periods.
Additional Information
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.
Job Description
**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.
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.
This is an on-site internship.
TO APPLY
External applicants, please go to and search for Job ID #772666
Current City Employees may apply via Employee Self Service (ESS) Click on Recruiting Activities/Careers and Search for Job ID #772666
ADDITIONAL INFORMATION
To best serve the City we represent, Mayor's Office of Contract Services (MOCS) seeks individuals from a variety of backgrounds who can bring different perspectives to contribute to the work of the office. MOCS also seeks candidates who want to contribute to a work environment that values teamwork, inclusion and respect.
MOCS recognizes the unique skills and strengths gained through military service. Veterans and service members of the U.S. Armed Forces are strongly encouraged to apply. Special accommodations provided to applicants with disabilities. Please contact MOCS Disability Service Facilitator at or to request an accommodation.
COLLEGE AIDE (ALL CITY DEPTS) - 10209
Qualifications
For Assignment Level I:
Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school.
For Assignment Level II (Information Technology):
Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school with a specific course of study in information technology, computer science, management information systems, data processing, or closely related field, including or supplemented by 9 semester credits in an acceptable course of study.
For Assignment Level III (Information Technology Fellow):
Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school with a specific course of study in information technology, computer science, management information systems, data processing, or other area relevant to the information technology project(s) assigned, including or supplemented by 9 semester credits in an acceptable course of study. Appointments to this Assignment Level will be made by the Technology Steering Committee through the Department of Information Technology and Telecommunications.
SPECIAL NOTE
Maximum tenure for all Assignment Levels in the title of College Aide is 6 years. No student shall be employed more than half-time in any week in which classes in which the student is enrolled are in session. Students may be employed full-time during their vacation periods.
Additional Information
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.