Business Intelligence Report Developer

Job Description

Job Description

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 be supervised by DOHMH. This is a grant-funded position ending in November 2027.

Program Overview:

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 provide, effective human resource management by developing and implementing policies, programs, and services in support of the values, vision, and mission of the agency. We attract, hire, and develop quality staff to provide an array of public health and mental health services and develop and manage Human Resource Information Systems to better streamline our transactional and reporting capabilities. Our HR Workforce Analytics Unit drives HR business process improvements including systems automation. This includes providing HR 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.

Position Summary:

The Bureau of Human Resources and Labor Relations, Workforce Analytics Unit, is seeking a Business Intelligence Report Developer to join our team. Our team relies heavily on completing complex and high visibility reporting and analytic tasks sometimes with quick turnaround. This position is critical for the success of business decisions made by the bureau, senior management, and leadership as it will help the team save time and improve HR ability. This position will report directly to the Senior BI Report Developer and will help to meet time sensitive complex demands, and high priority projects at times with short deadlines.

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. 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 be supervised by DOHMH. This is a grant-funded position ending on November 30th 2027.

Specifically, the Business Intelligence Report Developer will:

Duties will include but not be limited to:

• Work with all HR cross-functional teams, and other key stakeholders across the agency to identify and implement improvements within HR business process, 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 developing database queries and objects to analyze the effects and troubleshoot any issues
• Design and implement data models to support business intelligence
• Apply advance SQL skills to build data models that power BI Dashboards
• Migrate or replicate existing SSRS and Tableau reports to Power BI environment successfully
• Triage issues and manage support. Provide proper articulation and reporting of work productivity status to supervisor and HR stakeholders as well as conduct status meetings
• Create and establish project plans, 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.
• Ability to assist in analytics and other related projects across departments as needed.

Qualifications:

• Bachelors or Advanced Degree in Information Systems, Technology, Finance, Economics, or other relevant field is a plus, but not required.
• Strong experience developing and maintaining metrics, dashboards, scorecards, and management reports using Excel, Power BI, Tableau, or similar tools.
• 4-5 years of experience as a dedicated Power BI, SSRS, Tableau Developer
• Knowledge Power BI, and Tableau Server, Tableau Online and Tableau Desktop
• Extensive experience in developing, maintaining, and managing Power BI and Tableau-driven dashboards & analytics.
• Working knowledge of Power BI and Tableau administrator/architecture.
• Advanced Power BI, and Tableau development skills required.
• Understanding of advanced calculations and statistical functions
• Extensive understanding of SQL, rational databases, and normalization.
• Proficiency in use of query and reporting analysis tools, preferably MS SQL Manager
• High level of competency in Excel (macros, pivot tables, etc.)
• Proven ability to work with business owners in identifying reporting and dashboard requirements
• Exemplary oral and written communications skills, with the ability to translate technical concepts to non-technical community
• Ability to independently manage and prioritize tasks in a fast-paced, constantly evolving environment.
• High attention to detail, data confidentiality, and accuracy.

Benefits:

• Hybrid Work Schedule.
• Generous Paid Time Off and Holidays.
• An attractive and comprehensive benefits package including Medical, Dental and Vision.
• Flexible Spending Accounts and Commuter Benefits.
• Company Paid Life Insurance and Disability Coverage.
• 403(b) + employer matching and discretionary company contributions.
• College Savings Plan.
• Ongoing trainings and continuous opportunities for professional growth and development.

Additional Information:

• This is a temporary grant-funded position ending November 30, 2027.
• This individual must reside in the tri-state area (NY, NJ, CT) by their confirmed start date.
• Preference may be given to individuals residing in New York City (5 boroughs) or surrounding New York State counties.
• This individual will be expected to work non-business hours during emergencies.

At PHS, we place immense value on diversity within our teams, understanding that varied backgrounds and experiences significantly enhance our community and propel us toward our goals. If you find you don’t have experience in all the areas listed above, we still encourage you to apply and share your background and experiences in your application. We are eager to discover how your unique perspective can bring positive transformations to our team and help advance our mission of creating healthier, more equitable communities.

We look forward to learning more about you!

PHS is proud to be an equal opportunity employer and encourages applications from women, people of color, persons with disabilitnies, LGBTQIA+ individuals, and veterans.