Business Intelligence Report Developer

Public Health Solutions • New York, NY

1d • Hybrid

About The Position

The New York City Department of Health and Mental Hygiene (NYC DOHMH), a large public health agency serving 8 million New Yorkers, is undertaking a new initiative funded by the Centers for Disease Control and Prevention (CDC) to modernize its data infrastructure and capabilities. This initiative aims to improve public health outcomes and support equitable service delivery. The Business Intelligence Report Developer will be an employee of Public Health Solutions (PHS), a nonprofit organization managing the grant, but will work under the supervision of DOHMH. This is a grant-funded position ending in November 2027. The role is critical to the Bureau of Human Resources and Labor Relations, specifically within the Workforce Analytics Unit, which focuses on HR business process improvements, systems automation, and providing HR workforce reporting and analytic solutions. The position is essential for supporting complex, high-visibility reporting and analytic tasks, contributing to informed business decisions by bureau leadership.

Requirements

• 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 of 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.

Nice To Haves

• Bachelors or Advanced Degree in Information Systems, Technology, Finance, Economics, or other relevant field is a plus, but not required.

Responsibilities

• Work with HR cross-functional teams and other key stakeholders to identify and implement improvements in HR business processes, compliance management, Incident Command System Logistics, and other initiatives.
• Develop, maintain, and manage advanced reporting, analytics, dashboards, and other BI solutions, ensuring 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 BI Dashboards.
• Migrate or replicate existing SSRS and Tableau reports to a Power BI environment successfully.
• Triage issues and manage support, providing proper articulation and reporting of work productivity status to supervisors 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, and 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 analytics and other related projects across departments as needed.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree