Reporting Analyst, Finance Administration and Planning

Overview

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 to 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.

The selected candidate, under the direction of the Financial Systems Manager, will leverage data analysis and research for public health initiatives to inform decision‑making and resource allocation. The role involves the collection, analysis, and interpretation of health and financial data to identify trends, evaluate program effectiveness, and drive evidence‑based decisions.

• 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, and respond to requests for health and financial data.
• 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.

• 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 ETL or ELT pipelines for data integration.
• Data Warehousing:
  Understanding of building and maintaining structured data repositories (warehouses).
• Reporting
  
  Skills:
  • Data Visualization:
    Proficiency in Power BI and similar tools 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.

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

• Loan Forgiveness:
  Eligible for federal/state loan forgiveness and repayment assistance programs.
• Premium‑free health insurance plan that saves employees over $10,000 annually per a 2024 assessment.
• Health, fitness, and financial benefits may be available based on the position’s associated union/benefit fund.
• Public sector defined benefit pension plan with steady monthly payments in retirement.
• Tax‑deferred savings program.
• Robust Worksite Wellness Program that offers resources and opportunities to keep staff healthy while serving New Yorkers.
• Work From Home Policy:
  Depending on the position, work up to two days a week from home.
• Job Security – more stability compared to private sector employment…