A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact. 
As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else. We offer a vibrant work environment, comprehensive health care and benefits, and the experience you need to grow and excel. If you’re interested in working with a passionate team of people who care about the future of Philadelphia, start here.

What We Offer:
Impact - The work you do here matters to millions. 
Growth - Philadelphia is growing, why not grow with it? 
Diversity & Inclusion - Find a career in a place where everyone belongs.
Benefits - We care about your well-being.

The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia headed by the Chief Information Officer (CIO). OIT oversees all major information and communications technology initiatives for the City of Philadelphia - increasing the effectiveness of the information technology infrastructure, where the services provided are advanced, optimized, and responsive to the needs of the City of Philadelphia’s businesses, residents, and visitors. OIT responsibilities include: identifying the most effective approach for implementing new information technology directions throughout city government; improving the value of the city’s technology assets and the return on the city’s technology investments; ensuring data security continuity; planning for continuing operations in the event of disruption of information technology or communications services; and supporting accountable, efficient and effective government across every city department, board, commission and agency.

The Philadelphia Department of Public Health’s mission is to protect and promote the health of all Philadelphians and to provide a safety net for the most vulnerable. We provide services, set policies, and enforce laws that support the dignity of every man, woman, and child in Philadelphia. We work together to make Philadelphia a healthy place to live, work and play.

The Data Application Specialist works as a member of the Health IT team under the Enterprise Data Services Manager 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 a multi-faceted position with responsibility within multiple database types, data integration, extract-transform-load (ETL), and application knowledge.

Essential Functions
Enterprise Data Management
•    Participation in development and maintenance of departmental and divisional data and governance programs.
•    Assisting in development of R as a programming language within PDPH, including managing a server and assisting users with programming questions.
•    Working closely with DPH, Health IT, 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.
•    Working on Data Modernization efforts within PDPH, updating applications and processes to match more current methods.
•    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 standard, including HIPAA/HITECH, PA Act 59, industry standards, and the ethical standards of both IT and Public Health professions.
•    Operate as a member of the Health IT 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.
Relationship Management
•    Build and maintain collaborative and consultative relationships with OIT, DPH Divisions/Units supported by DPH Health IT.
•    Gain an understanding of OIT and DPH processes and requirements as they relate to the DPH supported systems.

Competencies, Knowledge, Skills, and Abilities
•    Demonstrated ability to learn and apply new languages, tools, techniques and technologies
•    Fundamental understanding of databases and data structures
•    Understanding of Linux and basic server administration and maintenance
•    Strong understanding of R and implementation of an R Server
•    Familiarity with SQL and SQL variations
•    Familiarity with data and database security; general knowledge of application controls and security
•    One or more of the following (more a plus)
o    Knowledge of data visualization tools such as GIS (ArcGIS, QGIS, etc.), BI and dashboarding (Tableau), and emerging/open source tools.
o    Knowledge of data analysis tools such as SAS, etc.
o    Knowledge of HL-7
o    Understanding of data APIs and Web services
o    Demonstrated ability to integrate data and/or automate extract-transform-load (ETL) procedures
o    Demonstrated ability to produce human-readable data reports
•    Ability to learn quickly and become comfortable with unfamiliar software and hardware environments
•    Ability to work as a team member, and to proactively help to improve the skills of team members through knowledge sharing and demonstration
•    Working within established policies and procedures, and also exhibit good judgement
•    Ability to work closely and effectively on complex data storage, management and analysis solutions with business users, providing services to translate technical to non-technical solutions.
•    Ability to respectfully work through challenging situations with clients and colleagues
•    Dedication to respecting others and treating others equally regardless of differences of any kind
•    Basic customer service skills
•    Ability to manage time and tasks in a complex environment with multiple priorities
•    Effective oral and written communication skills
•    Organizational and operational adaptability
•    Presentation and proposal writing skills

•    Minimum of 3-5 years in data management, engineering, integration and/or visualization
•    Certification or coursework in relevant technologies or topics a plus
•    Bachelor’s degree from an accredited college or university or equivalent work experience in a relevant position
o    Significant course work in Computer Science, information science, data analysis, software engineering, or a related field a plus
o    A masters’ degree or advanced coursework in a related field a plus
•    Demonstrated experience in data management, integration, reporting, and visualization, preferably in a healthcare or public health environment; government experience a plus
•    Any combination of experience and education deemed equivalent and sufficient by hiring manger and human resources

Salary Range: $80,000 - $90,000

Starting salary to be determined based on experience and qualifications. 

Important: To apply, candidates must provide a cover letter and a resume.

Did you know?
●    We are a Public Service Loan Forgiveness Program qualified employer
●    25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities
●    We offer Comprehensive health coverage for employees and their eligible dependents
●    Our wellness program offers eligibility into the discounted medical plan
●    Employees receive paid vacation, sick leave, and holidays
●    Generous retirement savings options are available

*The successful candidate must be a city of Philadelphia resident within six months of hire. 

Please note that effective September 1, 2021, the City of Philadelphia is requiring all new employees to present proof of vaccination against COVID-19. 

The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race, ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, source of income, familial status, genetic information or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at 215-686-4670 or send an email to faqpchr @phila.gov. For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx