Company Overview:
The New York City Department of Health and Mental Hygiene (DOHMH) is a world-renowned agency with a long tradition of protecting and promoting health in the nation’s most culturally and linguistically diverse city. Our 7,000-plus team members bring an extraordinary array of languages, cultures, and experiences to bear on the work of public health. Our diversity fuels creativity because all perspectives are heard and valued. DOHMH aims to improve the health outcomes of all New Yorkers by centering persistent racial inequities and promotion of social justice at the core of its work.
Program Overview:
The Office of Strategic Operations and Performance Management (SOPM) in the Office of the Chief Operating Officer for DOHMH is responsible for leading the implementation of policy efforts across the agency. This office supports the overarching strategies of DOHMH, fosters organizational alignment with those strategies, and supplements divisional capacity as needed. SOPM supports the agency’s external, partner-facing public health programming through rapid development, deployment, and stewardship of data management tools.
Summary of Position:
Under the direction of the Data Engineering Specialist, the Data Analyst will support the agency’s partner management system, Public Health Partners Connect (PHPC), a Salesforce application which stores the agency’s community outreach and engagement data as well as select program administration and measurement data. The Data Analyst will be a primary driver of a data management strategy that promotes data cleanliness and accuracy. They will also analyze and visualize programmatic data and transactional metadata to help the agency better understand its public health initiatives and improve efficiency and functionality. Finally, the Data Analyst will serve as a technical support liaison to health program staff as they integrate their data and business processes into PHPC. This role is responsible for gathering requirements, building workflows, training users, and reporting results. The analyst will need to be flexible with respect to the tools and methods utilized.
The selected candidate will be an employee of Public Health Solutions, a nonprofit organization which is the fiscal and administrative manager of the grant. All duties performed will be assigned and supervised by DOHMH. This position will be based at the Health Department’s office in Long Island City, NY, with the possibility of hybrid work.
Job Duties:
- Perform deterministic and probabilistic record linking to deduplicate Salesforce data objects
- Map new data sets and sources into predefined schema or develop new schema as needed while maintaining data integrity of the overall system
- Produce analyses on data pipelines and business processes to identify trends and anomalies in the usage of PHPC
- Provide program data managers and outreach staff across the agency with direct technical assistance to maintain data fidelity in PHPC
- Design, build, test, and maintain ETL (Extract, Transform, Load) jobs using Python and Pentaho feature upgrades using project management best practices
- Communicate complex technical and data information to both technical and non-technical stakeholders
- Assist in the design and implementation of data visualizations using Tableau and PowerBI
- Use Salesforce Reports and Dashboards to summarize information from both within and outside of Salesforce
- Support cross-divisional data-sharing initiatives as assigned by agency leadership
- Conduct ad-hoc analysis of administrative and program outcomes data as needed.
Qualifications:
- At least 2 years work experience; a background in government settings is preferred
- Demonstrable skills in data management and data analytics, including familiarity with concepts on data management, database design, and statistical analysis
- Familiarity with SQL, R, or Python is a plus, but the desire to learn new technologies and possessing a strong analytical framework is more important than experience with implementing scripting languages
- Familiarity with principles of data visualization design and experience with data visualization software
- Experience with analyzing administrative and transactional metadata is a plus
- Background in program analysis or monitoring and evaluation is preferred
- Excellent written and oral communication skills
- Ability to work collaboratively in a cross-disciplinary team environment
- Demonstrated organizational skills and high degree of attention to detail
- Willingness to adapt to new work priorities and tackle novel problems creatively
- Ability to understand the concepts of institutional and structural racism and bias and their impact on underserved and underrepresented communities, along with a demonstrated commitment to supporting communities who have experienced systemic oppression and bias (e.g. people of color, LGBTQ+ people, immigrants, etc.)
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 training and continuous opportunities for professional growth and development.
- Salary: $95,000 - $95,000
Additional Information:
- This is a temporary grant-funded position ending in November 2027.
- This is a hybrid position where the individual will be required to come into the Long Island City, NY office at least 3 days a week.
- Please note that remote work schedules are subject to approval by the supervisor and are conditional on agency policies.
- 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 disabilities, LGBTQIA+ individuals, and veterans.