Junior Oracle Developer

17 May 2024

Vacancy expired!

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 feedsOnboarding of new data source feedsData quality assurance and analysis of issues during the loading phaseQuerying and data extractionSystem and process documentationSystem updates and optimization in coordination with the Oracle DBAThis 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 FunctionsConduct code reviews and participate in technical designAnalyze complex business problems, track down required information, document requirements, and develop technical solutionsEstablish and enforce quality, security, and compliance requirementsSupport business customers by providing insight into data warehouse structuresLead and participate in highly complex projects with IDEA team, business users and analystsResolves complex hardware/software compatibility and interface design considerationsDesigns, develops, codes, tests, and debugs in an effort to properly load, store, and extract dataPerform annual data reconciliations with source systemsCompetenciesExtensive knowledge of SQLGood knowledge of Oracle 11g or higher versionGood knowledge of Linux and Shell scriptingAbility to understand complex issues and facilitate resolutionAbility to be flexible and work analytically in a problem-solving environmentProficiency writing complex queriesFlexibility and capacity to manage multiple priorities with competing deadlinesKnowledge, Skills and AbilitiesExperience working with large datasets and relational databasesExperience working in health and/or human services field a plusBusiness writing and documentation; visualization of summary dataCommunication and interpersonal skills

  • ID: #49954530
  • State: Pennsylvania Philadelphia 19113 Philadelphia USA
  • City: Philadelphia
  • Salary: USD TBD TBD
  • Job type: Full-time
  • Showed: 2023-05-17
  • Deadline: 2023-07-16
  • Category: Et cetera