Business Intelligence Report Developer

Company Overview

With an annual budget of $2.3 billion and more than 7,000 employees throughout the five boroughs, the New York City Department of Health and Mental Hygiene (NYC DOHMH) is one of the largest public health agencies in the world, serving 8 million New Yorkers from diverse ethnic and cultural backgrounds. We're tackling a broad range of public health issues with innovative policies and programs and getting exceptional results, but our work is never finished.

The breadth of our innovative programs provides the widest range of choices for every member of our team.

With grant funds from the Centers for Disease Control and Prevention (CDC), DOHMH is undertaking a new initiative that will meet critical infrastructure needs and make possible strategic investments that will have lasting effects on public health. Investments and improvements through this initiative will help modernize DOHMH’s foundational capabilities and data infrastructure, enabling it to partner in complex health and health care environments and, in turn, support better public health outcomes, including COVID-19.

This initiative supports larger efforts to rebalance investments in public health and more equitably serve communities and populations.

The selected candidate will be an employee of Public Health Solutions, a nonprofit organization which is the fiscal and administrative manager of the grant but will work supervised by DOHMH. This is a grant‑funded position ending on November 30, 2027.

This position is critical to support the core functions of the Division of Administration, Bureau of Human Resources, Workforce Analytics Unit.

The Bureau of Human Resources and Labor Relations provides, by developing and implementing policies, programs, and services, human resource management that supports the values, vision, and mission of the agency. The HR Workforce Analytics Unit drives HR business process improvements including systems automation, providing workforce reporting analytic solutions and visualizations, fulfilling day‑to‑day data analysis requests across the agency, and overseeing user permission access authorization for HR Central applications.

The Bureau of Human Resources and Labor Relations, Workforce Analytics Unit, is seeking a Business Intelligence Report Developer to join our team. This role reports directly to the Senior BI Report Developer. The position is critical for the success of business decisions made by the bureau, senior management, and leadership by delivering time‑sensitive, complex reporting and analytic projects with short deadlines.

• Work with all HR cross‑functional teams and other key stakeholders across the agency to identify and implement improvements within HR business processes, Human Resources compliance management, Incident Command System logistics, and other initiatives.
• Develop, maintain, and manage advanced reporting, analytics, dashboards and other BI solutions for scalability, manageability, extensibility, performance, and re‑use.
• Work through iterative review cycles to deliver results that meet or exceed user expectations.
• Perform and document data analysis, data validation, and data mapping/design.
• Review and improve existing systems and collaborate with teams to integrate new systems.
• Conduct unit tests and develop database queries and objects to analyze effects and troubleshoot issues.
• Design and implement data models to support business intelligence.
• Apply advanced SQL skills to build data models that power Power BI dashboards.
• Migrate or replicate existing SSRS and Tableau reports to the Power BI environment successfully.
• Triage issues and manage support, providing proper articulation and reporting of work productivity status to supervisor and HR stakeholders and conducting status meetings.
• Create and establish project plans and tasks to ensure timelines/deadlines are met.
• Develop requirement documents, prepare design specifications, document existing data transmission, loading and reporting processes.
• Establish and monitor best practices, policies, procedures and documentation for HR Analytics new solutions in our data warehouse.
• Assist in…