Data Analytics and Reporting Team Analyst Intern

Job Description

About the company and job description

Lensa is a career site for job seekers at every stage of their career. Our client, City of New York, is seeking professionals in New York, NY.

Job Description

Data Analytics and Reporting Team Analyst Intern

The Mayor’s Office of Contract Services (MOCS) manages procurement citywide, aiming to ensure a fair, transparent, efficient, and cost-effective process. MOCS uses technology, publishes enriched data, hosts public hearings, and provides assistance to stakeholders.

MOCS team members work collaboratively in a service-oriented environment. 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.

The Data Analytics and Reporting Team provides strategic, analytical, and reporting support to drive data-informed decision-making at MOCS. The team develops and enhances data-driven insights, manages key reporting initiatives, and streamlines data processes.

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.

MOCS Summer Internship Program Timeline:

• Applications reviewed on a rolling basis
• Program Dates: 6/2/25 – 8/15/25 (with a possibility of an extension)

College Aide Qualifications:

• Assignment Level I: Matriculation at an accredited college or graduate school.
• Assignment Level II (Information Technology): Matriculation at an accredited 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.
• Assignment Level III (Information Technology Fellow): Matriculation at an accredited college or graduate school with a specific course of study relevant to the information technology project(s) assigned, including or supplemented by 9 semester credits in an acceptable course of study.

Special Notes:

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