The New York City Department of Health and Mental Hygiene (DOHMH) is the nation's leading public health agency protecting and promoting health of all New Yorkers. Our 7,000-plus team members bring an extraordinary array of languages, cultures, and experiences to bear on the work of public health.

Our diversity fuels creativity because all perspectives are heard and valued. DOHMH aims to improve the health outcomes of all New Yorkers by centering persistent racial inequities and promotion of social justice at the core of its work.

The Division of Information Technology’s mission and vision is to promote and protect the health of all New Yorkers through the use of innovative technology and health information that is useful and available, such that we envision a city where all New Yorkers can realize their full health potential, regardless of who they are, where they are from or where they live.

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 agency's strategic goals and public health vision to "Promote and Protect the City's Health." Together we can make a difference in the health of all New Yorkers.

The Data Integration Manager will be responsible for overseeing the integration of various IT systems and platforms across the agency. This role requires a strategic thinker with strong technical expertise, leadership skills, and a track record of successful IT integrations. The candidate will work closely with cross-functional teams to ensure seamless integration, optimal performance, and alignment with business goals. Must have hands-on experience with development in day-to-day role.

This is a full-time position that requires residency in NYC or the tristate area. The selected candidate will be required to work onsite for at least three months. After this period, a telework option of up to two days per week may be available.

Applicants must have the ability to work in the US without sponsorship. No Corp-to-Corp arrangements will be considered.

Responsibilities:

Lead the planning, execution, and management of IT platform integration projects.

Develop and implement integration strategies to align with organizational goals.

Collaborate with stakeholders to gather requirements and define integration solutions.

Ensure the interoperability of various systems, applications, and platforms.

Manage a team of IT professionals, providing guidance, mentorship, and performance management.

Identify and mitigate risks associated with integration projects.

Stay current with emerging technologies and industry best practices to drive continuous improvement.

Oversee the development and maintenance of integration documentation and processes.

Ensure compliance with data security and privacy regulations.

Report on integration project status, milestones, and outcomes to senior management.

Qualifications:

Bachelor’s degree in Computer Science, Information Technology, or a related field; Master’s degree preferred.

10 years of experience in IT, with a focus on system and platform integration.

5 years of leadership experience in a similar role.

Must have hands-on experience with development in day-to-day role.

Proven track record of managing complex integration projects from inception to completion.

Strong understanding of integration technologies, protocols, and best practices (e.g., APIs, microservices, middleware).

Excellent problem-solving skills and the ability to work under pressure.

Strong interpersonal and communication skills, with the ability to work effectively with stakeholders at all levels.

Experience with cloud platforms (e.g., AWS, Azure, Google Cloud) and SaaS solutions is a plus.

Project management certification (e.g., PMP) is a plus.

Skills:

Minimum 5 years of strong hands-on experience of database development developing T-SQL in Microsoft SQL 2008R2/2012R2 environment.

Demonstrated expertise in writing T-SQL scripts for tables, keys, constraints, indexes, views, triggers, stored procedures, etc.

Demonstrated expertise in creating and troubleshooting SQL Server Integration Services (SSIS) packages.

Demonstrated expertise in creating and troubleshooting SQL Server Reporting Services (SSRS) reports.

Ability to analyze, understand, and create complex data processes.

Ability to transform data from Oracle to SQL Server is a plus.

Experience translating business requirements to technical specifications and database designs.

Ability to work well in a team environment.

Strong oral and written communication skills.

Strong analytical skills.

Strong desire to keep up to date on latest technology trends.

Job Type: Full-time

Pay: $120,000.00 - $145,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Employee assistance program
• Employee discount
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Parental leave
• Professional development assistance
• Retirement plan
• Tuition reimbursement
• Vision insurance

Experience level:

• 10 years
• 5 years

Schedule:

• 8 hour shift
• Monday to Friday

Experience:

• Management: 5 years (Preferred)

Ability to Commute:

• Long Island City, NY 11101 (Required)

Ability to Relocate:

• Long Island City, NY 11101: Relocate before starting work (Required)

Work Location: Hybrid remote in Long Island City, NY 11101