Reporting Analyst, Finance Administration and Planning

Division/Program Summary Description:

The New York City Department of Health and Mental Hygiene (DOHMH), a recognized leader and innovator in public health and mental hygiene services nationally and internationally, seeks a dynamic Reporting Analyst o join its challenging, fast-paced division of Finance.

The Division of Finance has central responsibility and authority for policy analysis, program development, performance tracking and improvement, financial management, resource maximization, and technical assistance. Finance helps to ensure that programs and administrative operations have the information, analysis, funding and technical capacity to deliver critical services effectively and meet DOHMH’s objectives.

Finance values motivated, energetic individuals committed to achieving excellence in a public-sector environment and a desire to be part of a City agency that is revolutionizing public health and mental hygiene services. Finance positions require analytic, interpersonal communications and problem-solving skills. Opportunities for advancement exist both within the Bureau and throughout the Department.

Position Description:

The selected candidate for this position under the direction of the Financial Systems Manager and with wide latitude for independent initiative and judgment is responsible for leveraging data analysis and research for public health initiatives to inform decision-making and resource allocation. This role involves the collection, analysis, and interpretation of health and financial data to identify trends, evaluate public health program effectiveness, and drive evidence-based decisions. The successful candidate will possess strong analytical skills, expertise in data visualization tools, and the ability to collaborate effectively with diverse stakeholders.

DUTIES WILL INCLUDE BUT NOT BE LIMITED TO:

Research and analyze public health data from electronic health records, billing systems, and other relevant sources.

Develop and implement research standards to ensure high-quality and reproducible research.

Stay up-to-date on latest methodologies in data analysis and research.

Prepare comprehensive reports and presentations summarizing research findings on data relevant to city public health initiatives.

Prepare financial reports and presentations for department leadership and external stakeholders.

Utilize data visualization tools (e.g. Power BI) to create interactive dashboards and reports that effectively communicate complex data findings.

Develop data-driven insights and recommendations to inform decision-making by agency leadership.

Coordinate with multiple teams to manage shared resources and ensure efficient project workflows.

Manage ad-hoc requests related to health data systems from internal or external parties.

Respond to ad-hoc requests for health and financial data from internal and external stakeholders.

Ensure data quality and integrity through rigorous data cleaning and validation processes.

Provide general support of Finance systems; both internal and external

Other related tasks as assigned by the management staff

Technical Skills: Programming: Proficiency in Python, or R for building data pipelines and automation.

Database Systems: Strong SQL skills for querying and managing data within relational databases (e.g., MSSQL).

ETL/ELT: Experience designing, implementing, and maintaining Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) pipelines for data integration.

Data Warehousing: Understanding of building and maintaining structured data repositories (warehouses).

Reporting Skills: Data Visualization: Proficiency in tools like Power BI to create interactive reports and dashboards.

Data Analysis: Ability to extract insights from data using statistical methods and identify trends. Communication: Clearly conveying technical findings to non-technical stakeholders.

SQL Proficiency: Writing complex SQL queries to extract and aggregate data for reporting.

Preferred Skills:

Data Modeling: Designing data models that optimize for querying and reporting efficiency.
Software Engineering Best Practices: Version control, code review, and testing to ensure data pipeline reliability.
Problem Solving: Ability to troubleshoot and resolve technical issues.
Collaboration: Working effectively with data analysts, data scientists, and business stakeholders.
Communication: Explaining complex concepts to both technical and non-technical audiences.
Attention to Detail: Ensuring data accuracy and consistency in reporting.

Why you should work for us:

- Loan Forgiveness: As a prospective employee of the City of New York, you may be eligible for federal/state loan forgiveness and repayment assistance programs that lessen your payments or even fully forgive your full balance. For more information, please visit the U.S. Department of Education’s website (https://studentaid.gov/pslf/)
- Benefits: City employees are entitled to unmatched benefits such as:
o a premium-free health insurance plan that saves employees over $10K annually, per a 2024 assessment.
o additional health, fitness, and financial benefits may be available based on the position’s associated union/benefit fund.
o a public sector defined benefit pension plan with steady monthly payments in retirement.
o a tax-deferred savings program and
o a robust Worksite Wellness Program that offers resources and opportunities to keep you healthy while serving New Yorkers.
- Work From Home Policy: Depending on your position, you may be able to work up to two days during the week from home.
- Job Security - you could enjoy more job security compared to private sector employment and be able to contribute to making NYC a healthy place to live and work.

Established in 1805, the New York City Department of Health and Mental Hygiene (NYC Health Department) is the oldest and largest health department in the U.S., dedicated to protecting and improving the health of NYC. Our mission is to safeguard the health of every resident and cultivate a city where everyone, regardless of age, background, or location, can achieve their optimal health. We provide a wide array of programs and services focused on food and nutrition, anti-tobacco support, chronic disease prevention, HIV/AIDS treatment, family and child health, environmental health, mental health, and social justice initiatives. As the primary population health strategist and policy authority for NYC, with a rich history of public health initiatives and scientific advancements, from addressing the 1822 yellow fever outbreak to the COVID-19 pandemic, we serve as a global leader in public health innovation and expertise.

Come join us and help to continue our efforts in making a difference in the lives of all New Yorkers! .

The NYC Health Department is an inclusive equal opportunity employer committed to providing access and reasonable accommodation to all individuals. To request reasonable accommodation to participate in the job application or interview process, contact Sye-Eun Ahn, Director of the Office of Equal Employment Opportunity, at sahn1@health.nyc.gov or 347-396-6549.

CITY RESEARCH SCIENTIST - 21744