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.

Agency Description

The Managing Director’s Office (MDO) is responsible for overseeing the City of Philadelphia’s daily operations and delivering efficient, effective, and responsive public services in every neighborhood in Philadelphia. The Managing Director’s Office is a cabinet-level office with oversight of the City’s operating departments. The MDO works with operating departments to (for additional information go to: https://www.phila.gov/departments/managing-directors-office/)

1.       Create and successfully enact new policies

2.       Deliver efficient, effective, and responsive public services

3.       Implement the mayor’s vision

The Office of Integrated Data for Evidence and Action (IDEA) sits within the MDO and is responsible for developing and maintain the City’s integrated data system. The integrated data system brings together, links, and securely stores data from across City agencies to inform the delivery of services to Philadelphians. Agencies use this information for analytics, research, case coordination, development, and direct client outreach to benefit City clients. IDEA has built a team with a broad range of skills including database administration, data querying, data use/visualization, and research methods. We seek individuals with both the required skills and a commitment to using data to better serve the people of Philadelphia

The goal of integrated data is to bring together in one place the capacity to answer questions about the efficacy of the programs used to support citizens. Sharing data across systems holds out promise beyond what can be learned from any one data system. The integration of administrative data systems provides potentially even more compelling information on patterns of multi-system program use, costs, and outcomes.

The system is utilized by the City of Philadelphia (the “City”) to coordinate client services to improve safety, health, and well-being outcomes of clients and their families. The role of the IDEA technical team is to maintain the source feeds, maintain the existing data warehouse, and ensure the integrity of the data as well as high data availability.

IDEA operates and maintains the integrated data system, which receives and integrates individual data from 12 unique source databases across HHS, the Office of Children and Families, and criminal justice agencies.

IDEA is seeking a candidate with Oracle development experience who can assist our Senior Oracle Developer with the following activities:

• Maintenance of existing source feeds
• Onboarding of new data source feeds
• Data quality assurance and analysis of issues during the loading phase
• Querying and data extraction
• System and process documentation
• System updates and optimization in coordination with the Oracle DBA

This position will increase capacity in IDEA to convert raw data into information that is used for service design and planning, service coordination, internal analytics, and research.  More specifically, this position will increase the capacity of the city to integrate data sets across departments in an effort to identify and perform outreach to individuals at-risk or impacted by the opioid crisis.

This employee will report to the Director of IDEA.

Essential Functions

• Conduct code reviews and participate in technical design
• Analyze complex business problems, track down required information, document requirements, and develop technical solutions
• Establish and enforce quality, security, and compliance requirements
• Support business customers by providing insight into data warehouse structures
• Lead and participate in highly complex projects with IDEA team, business users and analysts
• Resolves complex hardware/software compatibility and interface design considerations
• Designs, develops, codes, tests, and debugs in an effort to properly load, store, and extract data
• Perform annual data reconciliations with source systems

Competencies

• Extensive knowledge of SQL
• Good knowledge of Oracle 11g or higher version
• Good knowledge of Linux and Shell scripting
• Ability to understand complex issues and facilitate resolution
• Ability to be flexible and work analytically in a problem-solving environment
• Proficiency writing complex queries
• Flexibility and capacity to manage multiple priorities with competing deadlines

Knowledge, Skills and Abilities

• Experience working with large datasets and relational databases
• Experience working in health and/or human services field a plus
• Business writing and documentation; visualization of summary data
• Communication and interpersonal skills

• Bachelor’s degree in Computer Science, Information Systems, or related

• 3 to 5 years of Oracle experience; 11g or higher

• 3 to 5 years’ experience developing ETL applications

• 3 to 5 years’ PL/SQL experience

TO APPLY: Interested candidates must submit a cover letter and resume.

Salary Range: $92,000 - $97,000

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 [email protected].

For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx