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. 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.
Duties will include but not be limited to:
- Use existing technologies (R/Python/Pentaho/SQL) to develop a data pipeline from the current provider data warehouse to Salesforce using FHIR standards
- Develop a new provider data warehouse from existing DOHMH data sources
- Develop and share best practices around data integration with provider data
- Identify other public provider data to enhance the provider data warehouse
- Design, build, test, and maintain routine ETL (Extract, Transform, Load) jobs using Python and Pentaho
- Manage software feature upgrades using project management best practices
- Communicate complex technical data to both technical and non-technical stakeholders
- Perform record linking of external contact data to existing Salesforce data and perform QA checks on potential matches
- Perform deterministic and probabilistic record linking to deduplicate Salesforce data objects
- Produce analyses on data pipelines and business processes to identify trends and anomalies in the usage of Salesforce
- Use Salesforce Reports and Dashboards to summarize information
- Support cross-divisional data-sharing initiatives as assigned by agency leadership
- Conduct ad-hoc analysis of administrative and program outcomes data as needed
Preferred Skills:
- Demonstrable skills in data analytics; 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 prin