Data Engineering Intern - job 2 of 2

At the NYC Department of Buildings, we are responsible for ensuring the safe and lawful use of buildings and properties by enforcing the NYC Construction Codes, Energy Code and Zoning Resolution. We facilitate compliant development with integrity, efficiency, and professionalism. As an Agency, we are committed to remaining a premier municipal building organization, dedicated to enhancing the quality of life for all New Yorkers and making our city safer. As an employer, we are committed to improving our performance and developing procedures that are streamlined, understandable, and transparent.

About the Team

Department of Buildings Information Technology is responsible for the data processing functions and operations of systems that provide operational, analytical, and managerial support functions, as well as IT resource management for the Agency. DOB IT develops and maintains application software for such systems. Working closely with owner/client bureaus within the Agency, IT develops and implements both custom and packaged applications, and maintains the requisite technical infrastructure, using in-house project resources and hired consultants. We encourage innovation, creativity, and a think outside of the box attitude when solving complex problems and implementing new solutions.

NOTE: This summer internship is for up to 13 weeks, starting from the first day of the internship and ending no later than September 5, 2025. Interns are expected to work 35 hours per week in person.

Position Responsibilities:
Under the direction and supervision of Senior Analytics Developer and Director of Data Engineering, the intern will:
- Analyze and document Microsoft SSIS packages to help track data lineage
- Create API to extract and share data with external agencies
- Perform data quality checks, ensuring data accuracy, consistency, and completeness
- Use SQL to create queries to pull data from DOB data warehouse
- Develop reports and dashboards using Power BI

Major/ Field of Study
- Computer Science, Data Science, or related fields

SUMMER COLLEGE INTERN - 10234

As of June of the Program year the prospective interne must be a student matriculated in a college or be a recent college graduate (winter/spring term of the Program year).
NOTE: Appointment to this title is only valid for the duration of the Program, June - August each year.

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.