SUMMER COLLEGE INTERN - Property and Aggregate Revenue - job 1 of 2

As a Summer College Intern for the Property and Aggregate Revenue team, your responsibilities will include collaborating on the development of a new database for daily tax collections, conducting data accuracy checks, and refining database workflows. You'll also be expected to draft documentation for new data reporting files and automate various reports, contributing significantly to the efficiency of the OMB's initiatives.

To be eligible for the Summer College Intern position with the Mayor’s Office of Management and Budget, you must be currently enrolled or accepted into an accredited college or university. Strong analytical and communication skills are required, alongside familiarity with database management and proficiency in Excel. Coursework or experience in scripting, querying, or statistical programming (like SQL or Python) is also essential.

The Summer College Intern role with the Mayor’s Office of Management and Budget emphasizes strong analytical abilities, attention to detail, and excellent communication skills. Knowledge of scripting languages like SQL or Python, alongside advanced Excel skills, is crucial. A self-directed and intellectually curious mindset is highly valued, along with a personable attitude.

The Summer College Intern at the Mayor’s Office of Management and Budget plays a key role in data management, which directly impacts financial operations. By assisting in the development and maintenance of databases related to property and aggregate revenues, you help ensure accurate forecasting of the city’s tax collections, which exceed $35 billion, thus supporting vital city services.

Interning at the Mayor’s Office of Management and Budget offers a unique and enriching experience. You’ll gain practical experience in public finance, enhance your technical skills, and build valuable connections in the field of government budgeting. It’s a chance to engage in meaningful work while collaborating with talented professionals dedicated to serving New York City's communities.

When answering this question, focus on your passion for public service and finance. Highlight specific aspects of property and tax revenue management that excite you, and discuss how the intern role aligns with your academic background and career aspirations in public policy.

Here, you should give examples of relevant projects or courses where you worked with data. Discuss any database management systems you have used, your comfort level with tools like SQL or Python, and how you ensured the accuracy of data in past projects.

Your response should detail your organizational strategies, such as using to-do lists, prioritization methods, or time management tools. Provide an example of how you effectively managed competing deadlines in the past to illustrate your ability to handle multiple priorities.

Discuss the systematic approaches you would take to validate data, such as cross-referencing sources, applying data validation techniques, and performing regular audits of the information. Emphasize your attention to detail and the importance of accuracy in public financial data.

Mention any relevant software tools you have used, such as Excel, SQL, or Python libraries for data analysis. Provide examples of tasks or projects where you employed these tools to analyze data or generate reports, showcasing your technical skills.

In your answer, discuss the direct effects of public policy and budgeting on citizens, such as funding for education, healthcare, and public safety. Highlight your understanding of how responsible budgeting ensures that resources are allocated effectively to serve the community.

Talk about the importance of communication, respect for diverse perspectives, and how you contribute to a positive team dynamic. Provide an example of a successful teamwork experience, focusing on your role in achieving a common goal.

Explain your belief that constructive criticism is valuable for growth. Discuss a specific instance where you received feedback, how you responded positively, and the ways it motivated you to improve your work processes or skills.

When responding to this question, highlight your ability to simplify complex data into understandable formats. Discuss potential tools like visual aids such as graphs or charts, and stress the importance of storytelling when presenting data to engage audiences.

Share your motivation for entering the public sector, emphasizing a desire to contribute to the community’s betterment. Discuss your interest in how budget management operates within municipal governments and how it aligns with your career goals.