Data Engineering Intern - job 1 of 2

As a Data Engineering Intern at the NYC Department of Buildings, you will engage in various responsibilities such as analyzing and documenting Microsoft SSIS packages to trace data lineage, creating APIs to facilitate data sharing with external agencies, performing data quality checks to ensure accuracy and completeness, using SQL to retrieve data from the department's data warehouse, and developing reports and dashboards with Power BI. This diverse set of tasks will immerse you in practical data engineering applications and enhance your technical skills.

To qualify for the Data Engineering Internship at the NYC Department of Buildings, candidates must be a student matriculated in a college or a recent graduate (as of June of the program year) in Computer Science, Data Science, or a related field. This internship requires a strong foundation in data analysis and management, allowing interns to gain valuable insights and experiences in the field of data engineering.

For the Data Engineering Intern position at the NYC Department of Buildings, proficiency in SQL is essential for pulling data from the department's data warehouse. Additionally, having experience with Microsoft SSIS and familiarity with data visualization tools like Power BI will greatly enhance your capability to fulfill the responsibilities of the role effectively. These skills will help you contribute positively to the team's objectives while advancing your career in data engineering.

The Data Engineering Internship at the NYC Department of Buildings lasts for up to 13 weeks, running from the internship's start date until no later than September 5, 2025. Interns are expected to work in person for 35 hours each week, providing a comprehensive, immersive experience that fosters learning and professional development in the field.

Yes, the Data Engineering Internship at the NYC Department of Buildings is a paid position. The internship provides not only compensation for your valuable contributions but also an incredible opportunity to gain hands-on experience and practical knowledge in data engineering within a municipal context, supporting the city's mission of enhancing the quality of life for all New Yorkers.

When answering this question, focus on specific projects where you utilized data engineering skills, whether through academic work or personal projects. Discuss the tools and methodologies you used, such as data cleaning, data transformation, or creating visualizations. Be sure to highlight your problem-solving approach and what you learned from the experience.

To ensure data quality and accuracy, outline your methodology, which could include implementing data validation checks, regularly auditing data sets, and utilizing automated tools for data cleansing. Discuss your understanding of the importance of data integrity, particularly in a governmental context like the NYC Department of Buildings, and how you would maintain these standards.

In your response, highlight any coursework or projects where you've actively used SQL. Discuss specific tasks you've completed, such as writing complex queries, optimizing database performance, or retrieving data for analysis. If you have experience with database design or administration, mention that as well to showcase your versatility within SQL.

Microsoft SSIS, or SQL Server Integration Services, is a platform for building enterprise-level data integration and data transformations solutions. Share any hands-on experience you have, whether it's creating ETL processes, managing data flows, or troubleshooting issues with SSIS packages. Be enthusiastic about its role in streamlining data management, particularly within a municipal setting.

This is your chance to showcase your problem-solving skills! Choose a relevant and challenging scenario where you resolved a data-related issue. Explain the context, the specific issue at hand, your analytical approach to finding a solution, and the end results. Highlight how the experience improved your skills and prepared you for future challenges.

Discuss your experience with data visualization tools, emphasizing tools like Power BI. Share specific instances where you created dashboards or visual reports, detailing the data sources you used and how the visualizations helped stakeholders make informed decisions. Point out any feedback received on your visualized data.

Managing tight deadlines effectively requires excellent time management and prioritization skills. Discuss how you plan your tasks, avoid procrastination, leverage teamwork, and communicate with stakeholders to ensure project completion. Provide an example showcasing your ability to deliver quality work under pressure.

This question is an opportunity to convey your passion for data engineering while contributing to a meaningful cause. Discuss your interest in enhancing New Yorkers' lives through technology, the department's innovative projects, and how you align with their mission. Your enthusiasm will demonstrate to interviewers that you're not just looking for a job, but are genuinely eager to contribute to their objectives.

Indicate your commitment to continuous learning by mentioning specific resources like online courses, seminars, or communities you follow. Discuss any blogs, podcasts, or professional organizations relevant to data engineering that you engage with to keep your skills fresh and stay at the forefront of technological advancements in the field.

Share your strategic approach to learning new programming languages or tools, such as setting a learning schedule, identifying key resources, and applying your knowledge through small projects or collaborative efforts. Highlight your adaptability and determination to keep growing in the field of data engineering, making you an asset to the NYC Department of Buildings.