Web & SQL Developer
City of Philadelphia3 months ago
Philadelphia, PA, USAMid Level
Base Salary
$80k - $87k/yr
Responsibilities
- Support, maintain, enhance, and develop HR web and client-server applications.
- Develop and optimize HR websites, queries, scripts, macros, views, and reports.
- Gather user requirements and create application designs, prototypes, functional specifications, and code.
- Use SQL, PL/SQL, web-based methodologies, and reporting tools across multiple database environments.
- Create documentation, operating procedures, quality-assurance documentation, and test plans.
- Participate in code and high-level design reviews and follow requirements, architecture, coding, and testing practices.
- Coordinate application development and maintenance projects with OHR, OIT, production support, help desk, QA, vendors, and other departments.
- Diagnose software and hardware issues, support upgrades or application repurposing, and propose solutions to application inefficiencies.
- Help establish technical standards and maintain development frameworks and code libraries.
Requirements
- Bachelor’s degree from an accredited college or university with major coursework in computer science, management information systems, or a related field.
- 2–3 years of experience with human resources systems, including configuration, customization, and preferably web/SQL development and HR-system interfacing.
- 2–3 years of programming experience with HTML, ASP, JavaScript, XML, MS Access, SQL, PL/SQL, or similar products.
- 2–3 years of experience with HR reporting tools or data-warehouse technologies such as EiS, Report Writer, Cognos, OBIEE, or similar tools.
- Working knowledge of web and client-server architecture, web services, stored procedures, SQL queries, scheduled jobs, Microsoft tools, and application or network architecture.
- Knowledge of PeopleAdmin, testing software, VB, MS Access coding, network administration, Active Directory, desktop services, hardware and software configuration, and LAN/WAN support is preferred or beneficial.
- Ability to work collaboratively in a knowledge-sharing environment and communicate effectively with management, administrative staff, technical staff, vendors, and users.
- Ability to document code and processes, solve practical problems, interpret instructions, and deliver work on time.
Benefits
- Comprehensive health coverage for employees and eligible dependents.
- Wellness program eligibility for a discounted medical plan.
- Paid vacation, sick leave, and holidays.
- Retirement savings options.
- Eligibility for the Public Service Loan Forgiveness program.
- Free SEPTA transportation through the SEPTA Key Advantage Program for eligible employees.
- Tuition discounts and scholarships through partner colleges and universities.
- The role is onsite/in-person, and the successful candidate must become a City of Philadelphia resident within six months of hire.
Tech Stack
Categories
About City of Philadelphia
The City of Philadelphia is the municipal government serving residents, businesses, and visitors through public safety, infrastructure, licensing, social services, and digital services. It is funded by taxes, fees, and grants, and develops and operates citizen-facing portals, data platforms, and internal tools; current initiatives include a hybrid AWS GovCloud and Commercial cloud environment. Headquartered in Philadelphia, PA, it is the primary public-service provider for the city and a major regional employer.