Data Engineering Intern - job 2 of 2

As a Data Engineering Intern at the NYC Department of Buildings, you will have a range of exciting responsibilities. Primarily, you'll analyze and document Microsoft SSIS packages to ensure accurate data lineage tracking. Additionally, you'll create APIs to facilitate data sharing with external agencies, perform data quality checks, and use SQL to design queries for extracting data from the DOB data warehouse. Your role will also involve developing informative reports and dashboards using Power BI, which will be crucial for supporting decision-making processes within the agency.

To qualify for the Data Engineering Intern position at the NYC Department of Buildings, candidates must be either current college students or recent graduates in Computer Science, Data Science, or a related field. It's essential that interns are matriculated by June of the program year, as appointments are only valid during the summer internship, running from June to August. A passion for data analysis and hands-on experience with tools like SQL and Power BI are significant advantages.

Yes, the Data Engineering Intern position at the NYC Department of Buildings is a paid internship. Interns are expected to commit to working 35 hours per week in person and will receive compensation for the duration of the internship program, which lasts up to 13 weeks. This is a fantastic opportunity to gain invaluable hands-on experience while earning during your summer break!

For the Data Engineering Intern role at the NYC Department of Buildings, familiarity with SQL is crucial, as you'll be utilizing it to create queries for data extraction. Experience with Microsoft SSIS is highly advantageous, as tracking data lineage is a key responsibility. Moreover, knowledge of tools like Power BI for data visualization and reporting will significantly enhance your effectiveness in the role. Problem-solving skills and a keen eye for detail will also serve you well in ensuring data quality and consistency.

The Data Engineering Internship at the NYC Department of Buildings lasts for up to 13 weeks. The internship program typically begins in June and must conclude no later than September 5 each year. Interns are expected to work 35 hours per week, gaining valuable experience while contributing to the agency's goals during this impactful summer program.

In responding to this question, highlight specific instances where you utilized SQL in past projects or coursework. Explain how you created queries for data extraction or performed data analysis. Discuss any databases you have worked with, and mention how your skills will help you successfully perform the responsibilities associated with the Data Engineering Intern position at the NYC Department of Buildings.

To answer this question effectively, share the strategies you implement to maintain data quality. Talk about the importance of data validation and quality checks and describe any specific methods or tools you have used to manage data discrepancies. Emphasize your attention to detail and your proactive approach to resolving data-related issues, which will resonate with the expectations for a Data Engineering Intern.

When tackling this question, focus on a relevant project where you encountered a significant challenge regarding data management. Walk the interviewer through the problem, your analytical approach to finding a solution, and the outcome. Highlight your critical thinking skills and how they align with the responsibilities of a Data Engineering Intern at the NYC Department of Buildings.

Your response should reflect an understanding of the agency’s mission and values. Discuss your desire to contribute to community safety and building compliance in New York City. Mention specific aspects of the internship that excite you—like the chance to work on data analytics projects that have a real-world impact—and express enthusiasm for learning from experienced professionals in the field.

To prepare for this question, discuss your familiarity with Power BI or similar tools. Share specific examples of how you've created dashboards or visual reports to convey complex data effectively. Emphasize your understanding of the importance of data visualization in decision-making processes, which is vital for a Data Engineering Intern at the NYC Department of Buildings.

In this response, provide an example of a collaborative technical project you participated in. Discuss your role in the team, the communication strategies you employed, and how you navigated challenges together. Highlight your ability to work effectively in a team, which is essential for the collaborative environment at the NYC Department of Buildings.

When answering, outline your process for tackling new tools, including research, hands-on experimentation, and seeking guidance from colleagues or online communities. Emphasize your proactive nature and your commitment to continuous learning—qualities that are highly valued for a Data Engineering Intern.

Share your knowledge of fundamental data engineering concepts, such as data modeling, ETL processes, and data warehousing. Mention any coursework or projects where you applied these principles. This will demonstrate your foundational understanding of data engineering, relevant to the role.

In your response, outline the steps you would take to investigate the discrepancies. Discuss the significance of identifying and resolving issues transparently and promptly. Emphasize your problem-solving skills and your approach to conducting thorough checks to ensure data reliability, aligning your answer with the expectations for a Data Engineering Intern.

Express your excitement for the opportunity and specify your learning objectives. You might say you hope to enhance your technical skills, contribute meaningfully to data projects, and gain insights into the operations of a municipal organization. Emphasize your willingness to learn and grow in the field, which aligns well with the internship's goals.