Job Description

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

Qualifications

• 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

Additional Information

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 faqpchr@phila.gov.

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