IT Intern Bureau of Application Development and Database Administration

Established in 1805 the New York City Department of Health and Mental Hygiene (the NYC Health Department) is the oldest and largest health department in the country. Our mission is to protect and improve the health of all New Yorkers in service of a vision of a city in which all New Yorkers can realize their full health potential regardless of who they are how old they are where they are from or where they live.

As a worldrenowned public health agency with a history of building transformative public health programming and infrastructure innovating in science and scholarship to advance public health knowledge and responding to urgent public health crises from New York Citys yellow fever outbreak in 1822 to the COVID19 pandemic we are a hub for public health innovation expertise and programs and services. We serve as the population health strategist and policy and planning authority for the City of New York while also having a vast impact on national and international public policy including programs and services focused on food and nutrition antitobacco support chronic disease prevention HIV/AIDS treatment family and child health environmental health mental health and racial and social justice work among others.

Our Agencys five strategic priorities building off a recentlycompleted strategic planning process emerging from the COVID19 emergency are:
1) To reenvision how the Health Department prepares for and responds to health emergencies with a focus on building a responseready organization with faster decisionmaking transparent public communications and stronger surveillance and bridges to healthcare systems 2) Address and prevent chronic and dietrelated disease including addressing rising rates of childhood obesity and the impact of diabetes and transforming our food systems to improve nutrition and enhance access to healthy foods
3) Address the second pandemic of mental illness including: reducing overdose deaths strengthening our youth mental health systems and supporting people with serious mental illness
4) Reduce black maternal mortality and make New York a model city for womens health
5) Mobilize against and combat the health impacts of climate change

Our 7000plus team members bring extraordinary diversity to the work of public health. True to our value of equity as a foundational element of all of our work and a critical foundation to achieving population health impact in New York City the NYC Health Department has been a leader in recognizing and dismantling racisms impacts on the health of New Yorkers and beyond. In 2021 the NYC Board of Health declared racism as a public health crisis. With commitment to advance antiracist public health practices that dismantle systems that perpetuate inequitable power opportunity and access the NYC Health Department continues to work in and with communities and community organizations to increase their access to health services and decrease avoidable health outcomes.

PROGRAM AND JOB DESCRIPTION:



College Aide IIA (Information Technology Undergraduate)1020B2A

The nations leading local health department seeks a College Aide Intern to join its awardwinning innovative technology team in revolutionizing public health IT. The New York City Department of Health and Mental Hygiene (DOHMH) uses the latest technologies and enterprise wide application solutions in its groundbreaking work to promote and protect New Yorkers health and improve DOHMHs business operations. The Bureau of Application Development & Database Administration is committed to providing high quality customized software business solutions and database administration/advisory services that aligns with the agencys strategic goals and public health vision. The mission of the Data Services team within the Bureau of Application Development & Database Administration is to provide innovative efficient and scalable data services and solutions for NYC DOHMH initiatives as well as those of collaborating Agencies and institutions.

DUTIES WILL INCLUDE BUT NOT BE LIMITED TO:

ETL & standardization of different data sources into one common SQL table structure for deduplication.

Design and populate a relational Data Warehouse (SQL DB) where the normalized personcentric matched analytic data will be maintained and will need comprehensive knowledge and skills working with complex relational SQL DB.

Data mining analytic and data quality assurance skills to match different datasets on person centric variables.

Create and present analytic reports.

Qualifications :

For Assignment Level I:
Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school.
For Assignment Level II (Information Technology):
Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school with a specific course of study in information technology computer science management information systems data processing or closely related field including or supplemented by 9 semester credits in an acceptable course of study.
For Assignment Level III (Information Technology Fellow):
Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school with a specific course of study in information technology computer science management information systems data processing or other area relevant to the information technology project(s) assigned including or supplemented by 9 semester credits in an acceptable course of study. Appointments to this Assignment Level will be made by the Technology Steering Committee through the Department of Information Technology and Telecommunications.

SPECIAL NOTE
Maximum tenure for all Assignment Levels in the title of College Aide is 6 years. No student shall be employed more than halftime in any week in which classes in which the student is enrolled are in session. Students may be employed fulltime during their vacation periods.

Additional Information :

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 individuals sex race color ethnicity national origin age religion disability sexual orientation veteran status gender identity or pregnancy.

Remote Work :

No

Employment Type :

Parttime