Okay, I've searched for Data Analytics Internships in New York, NY that require skills in Excel and SQL, aimed at students pursuing degrees in Data Science or Computer Science, and available as on-site roles. I have found 47 positions for you.

Sure. Here's the analysis:

Job Analysis:

This Data Analytics and Reporting Team Analyst Intern role at the Mayor’s Office of Contract Services (MOCS) is fundamentally designed to immerse a candidate in the intersecting worlds of public procurement, data analytics, and government operations. The core purpose is to support the agency’s mission to ensure transparency, efficiency, and fairness in New York City’s multi-billion-dollar procurement process by leveraging data analysis and visualization tools. Key responsibilities extend beyond just crunching numbers—they involve engaging with diverse stakeholders (internal teams, vendors, and city agencies), managing compliance reporting, and contributing to important policy-related projects through data-driven insights. Mastery of Excel (pivot tables, Power Query), familiarity with SQL, and developing basic Power BI visualizations are emphasized because accurate, timely, and insightful data directly influence procurement reform and operational excellence. The requirement for project management skills and meeting participation highlights expectations for organizational discipline, effective communication, and collaborative execution within a complex municipal environment. Success in this role means delivering high-quality reports that inform decision-making, spotting data anomalies, ensuring compliance timelines are met, and progressively deepening one’s understanding of government processes—ultimately enabling the MOCS team to optimize procurement impact across the city.

Company Analysis:

While this internship is for the City of New York via the MOCS agency, the job posting is facilitated through Lensa, a tech-forward career platform known for harnessing machine learning to streamline job matching. Lensa itself represents innovation in the recruitment space by emphasizing data-driven, candidate-centric hiring using sophisticated algorithms, game-based assessment of work styles, and a commitment to efficient talent acquisition. This context suggests that candidates applying through Lensa have the benefit of engaging with a company deeply invested in technology and analytic methods, mirroring some of the technical demands of the MOCS internship. For someone in the intern role, understanding Lensa’s mission underscores the importance of data accuracy, insightfulness, and user-focused solutions—qualities prized both by Lensa and MOCS. The City of New York, via MOCS, is a large, traditional public-sector institution focused on transparency, inclusivity, and systematic improvement of government operations. The culture here values collaboration, service orientation, and continuous learning, with clear goals to reduce bureaucracy and enhance equity in procurement. This dual environment—a forward-leaning tech platform connecting candidates and an established public agency pushing for data-driven reform—creates a unique strategic alignment. To thrive, a candidate must balance rigorous technical execution with an agile, stakeholder-focused approach, fitting well within government’s mission-driven framework while drawing inspiration from innovative data applications championed by facilitators like Lensa.

Absolutely. Here are some mock interview questions that could come up:

• Behavioral: Tell me about a time when you had to analyze complex data to inform a decision or influence a project. What was your approach and outcome?
• Behavioral: Describe an experience where you had to collaborate with multiple stakeholders or teams to complete a project. How did you manage communication and differing priorities?
• Behavioral: Give an example of when you identified an error or inconsistency in a dataset. How did you resolve it and ensure accuracy going forward?
• Behavioral: Have you ever contributed to improving a process or system through your analytical work? Walk me through how you approached it.
• Technical: How do you use Excel pivot tables and Power Query to analyze large datasets? Can you provide a specific example of a project or task where you applied these skills?
• Technical: Describe your experience with SQL for data manipulation. What kinds of queries do you typically write, and how do you ensure performance and accuracy?
• Technical: What is your familiarity with Power BI or similar BI tools? How would you approach creating a dashboard that communicates procurement data effectively to non-technical stakeholders?
• Technical: Walk me through the steps you take to perform data quality checks before producing reports. What tools or methods do you employ?
• Situational: Imagine that during quarterly compliance reporting you discover missing or conflicting data from a key vendor. How would you handle this issue to meet deadlines and maintain report integrity?
• Situational: You’re participating in a cross-agency meeting where priorities conflict about data reporting formats and timelines. How do you advocate for your team while achieving collaborative solutions?
• Situational: Suppose you are assigned to develop a new visualization dashboard for procurement indicators, but you lack clarity on the end-users’ specific needs. What steps would you take to ensure your deliverable is useful and actionable?
• Company Fit: What interests you most about working at the City of New York’s MOCS, particularly in the context of public-sector data analytics?
• Company Fit: How do your personal and professional values align with a government agency’s commitment to transparency, equity, and service?
• Company Fit: Given that this internship is offered via Lensa’s platform, how do you see your skills and experiences fitting with both technology-driven platforms and traditional government environments?
• Questions for Interviewer: Can you describe the typical career path for someone who starts as a Data Analytics Intern at MOCS?
• Questions for Interviewer: How does MOCS integrate data analytics into its policymaking and procurement reform initiatives on an ongoing basis?
• Questions for Interviewer: What kind of mentorship and learning opportunities are available to interns to deepen their understanding of government procurement processes?