Data Analytics and Reporting Team Analyst Intern
Are you applying to the internship?
Job Description
About Company:
Lensa is the leading career site for job seekers at every stage of their career. Our client is the City of New York.
Job Description:
Data Analytics and Reporting Team Analyst Intern
The Mayor’s Office of Contract Services (MOCS) is seeking a Data Analytics and Reporting Team Analyst Intern to support its mission of ensuring a fair, transparent, efficient, and cost-effective procurement process for New York City. The Data Analytics and Reporting Team provides strategic, analytical, and reporting support to drive data-informed decision-making at MOCS.
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)
