With a workforce of over 25,000 people, and opportunities in more than 1,000 different job categories, the City of Philadelphia is the fifth largest city in the United States and one of the largest employers in Southeastern Pennsylvania. As an employer, the City of Philadelphia operates through the guiding principles of service, integrity, respect, accountability, collaboration, diversity and inclusion. Through these principles, we strive to effectively deliver services, to resolve the challenges facing our city, and to make Philadelphia a place where all of our residents have the opportunity to reach their potential.

The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia, headed by the Chief Information Officer (CIO). The Revenue IT Unit provides services to the Revenue Department and is led by the Revenue IT Director.

The primary responsibility of this position is software development for the Revenue Department’s water billing application, basis2. The software engineer will be responsible for taking business and technical analysis of key water billing enhancements and performing the design and programming for reporting solutions and other application enhancements. The person in this position will work closely with the Revenue Department, The Philadelphia Water Department, the Office of Innovation and Technology and other city departments as required, conducting all the activities related to successfully identifying, designing, documenting, communicating, and developing billing enhancements and other modifications for the Revenue Department. The current application portfolio is developed within Oracle’s E-Business Suite using an Oracle database and utilizing Oracle Forms, Reports, PL/SQL, and XML.

The successful candidate must reside in the City of Philadelphia or establish primary residence in the City of Philadelphia within six months of employment. This position is open to US Citizens and those that are authorized to work in the US.  

Essential Functions:

•  Create technical design documents and specifications
•  Identify, design, document, communicate, and develop billing system online, reporting, and batch process enhancements and other modifications.
•  Work with the Revenue IT business analysts to translate business requirements into technical requirements and design specifications.
•  Develop test cases, perform unit and integration testing, support user acceptance testing, deliver change control documentation and code according to release schedules
•  Diagnose software issues, document and develop resolutions
•  Provide time estimates for all assigned tasks, and track time as percentage of tasks complete.
•  Work closely with DBA team that supports Oracle applications.
•  Work effectively across various support teams and with IT and business management.
•  Participate in the technical mentoring, training and education of team members.
•  Provide evaluation, architecture, and integration skills to implement and support 3rd Party products within the Oracle framework. 
•  Learn new technologies and determine appropriate uses based on user requirements.
• Consult with users, management, vendors, and business analysts to complete programming needs and system requirements
• Other duties as assigned. 

Competencies, Knowledge, Skills & Abilities:

• Deep understanding of Oracle database
• Expert skills in Oracle's PL/SQL
• Development experience in Oracle Reports, Oracle Forms
• Strong background in the theory and practices of systems design methodologies
• Strong organizational skills and ability to meet delivery timeframes
• Proven ability to understand business analysis, define technical requirements and apply various technical solutions
• Extensive familiarity with System Development Life Cycle methodology.
• Familiarity with Agile development practices
• Excellent analytical and problem-solving skills – ability to communicate in a clear and succinct manner and effectively evaluate information/data to make decisions; anticipates obstacles and develops plans to resolve; creates actionable strategies and operational plans
• Excellent ability to communicate effectively with IT and functional managers at all levels; able to influence and engage across multiple teams; excellent verbal and written communication and documentation skills.
• Ability to manage time effectively, set priorities appropriately, operate with minimal supervision, work and act independently/as part of a team and maintain professional demeanor under stress
• Demonstrated customer focus – evaluates decisions through the eyes of the customer; builds strong customer relationships; creates processes from customer viewpoint; partners with customers to help shape their future initiatives

Education and Experience:

• Bachelor's degree in Computer Science or Software Engineering related field, or minimum of 4 years of equivalent relevant software engineering experience
• Minimum 5 years of Oracle Applications software development experience, including in-depth use of PL/SQL and Oracle development tools

Please submit a resume and cover letter with your application.

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. For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx

The successful candidate must reside in the City of Philadelphia or establish primary residence in the City of Philadelphia within 6 months of employment.