Job Description
Job Description
Position Summary :
The Data Application Specialist works as a member of the HealthIT team under the Sr. Data Engineer to support the DPH goals of enhancing department research and public services and facilitating the establishment and maintenance of department-wide data governance. This position is responsible for executing on project plans, and maintaining existing data-related solutions for department and divisional needs and services. This is multi-faceted position with responsibility within multiple database types, data integration, ETL, and application knowledge.
Duties and Responsibilities :
- Participation in development and maintenance o f departmental and divisional data and governance programs
- Database maintenance, optimization, and administration, as needed, to support DPH initiatives
- Working closely with DPH, HealthIT, and OIT colleagues to choose and create appropriate solutions, using existing City and department resources whenever possible.
- Creation of scripts, queries, stored procedures, and use of data APIs and Web services to integrate disparate data sources, create reports, and ensure data integrity.
- Suggest tools for use within DPH for working with, reporting on, visualizing, and managing data.
- Creation and maintenance of data visualizations, as directed
- Application administration of and high-level support for DPH data management and visualization tools
- Maintaining awareness of emerging technologies in related areas including awareness of visualization tools, new databases and data formats, integration techniques and common scripting languages
- Observing DPH needs and proactively recommending to Sr. Data Engineer or IT Director, demonstrating, and implementing techniques, tools and solutions.
- Ensuring data security as per the appropriate standards of both IT and Public Health professions
- Working with vendors and contractors to ensure DPH receives appropriately built, maintainable, integration- friendly solutions
- Operate as a member of the HealthIT team, including participation in team meetings, projects, and initiatives, and regularly use team communication tools
- Create and maintain documentation on data-related solutions as implemented or used by DPH
Skills Required :
Demonstrated ability to learn and apply new languages, tools, techniques, and technologiesFundamental understanding of databases, data structuresFamiliarity with SQL, and SQL variationsAbility to script fluently in at least one common scripting language such as Python, Perl, or RubyFamiliarity with data and database security; general knowledge of application controls and securityKnowledge of data visualization tools such as GIS (ArcGIS, QGIS, QGIS) BI and dashboarding (Tableau) and emerging / open source toolsKnowledge of data analysis tools such as R, SASUnderstanding of data APIs and Web servicesDemonstrated ability to produce human-readable data reportsAbility to learn quickly and become comfortable with unfamiliar software and hardware environmentsAbility to work, learn, and research independentlyAbility to work as a team member, and to proactively help improve the skills of team members through knowledge sharing and demonstrationWork within established policies and procedures, and also exhibit good judgementAbility to translate between technical and non-technical solutions in a business contextAbility to respectfully work through challenging situations with clients and colleaguesDedication to respecting others and treating others equally regardless of differences of any kind.Basic customer service skillsAbility to manage time and tasks in a complex environment with multiple prioritiesEffective oral and written communication skillsOrganizational and operational adaptabilityPresentation and proposal writing skillsEducation and Experience :
Minimum of 3-5 years data management, engineering, integration and / or visualizationCertification or coursework in relevant technologies or topics a plusBachelor's degree from an accredited college or university or equivalent work experience in a relevant positionDemonstrated experience in data management, integration, reporting and visualization preferably in a healthcare or public health environmentEqual Opportunity Employment :
PMHCC, Inc. is committed to equal opportunity. It is our policy to support equal employment for all employees and applicants without regard to race, religion, color, sex, sexual preferences, age, national origin, disability, behavioral health status, military status or any other characteristic protected by law.
Americans with Disabilities Act :
Employees as well as applicants who are currently, or become disabled, must be able to perform the functions of the job with either reasonable accommodation or unaided. PMHCC, Inc. will examine reasonable accommodations on a case by case basis in accordance with the law.