Web & SQL Developer

Cityofphiladelphia

Philadelphia (Philadelphia County)

On-site

USD 80,000 - 87,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Comprehensive health coverage
Wellness program with discounted plan
Paid vacation, sick leave and holidays
Generous retirement savings option

Job summary

City of Philadelphia is seeking an IT professional to join the Office of Human Resources IT unit. The role supports HR applications, develops documentation, tests plans, and enhances HR reporting using Web-based methods and SQL tools.

You will work with OHR and OIT staff to implement short- and long-term projects, follow SDLC, review code, and help create operating documentation. On-site work setting in Philadelphia.

Qualifications

  • Bachelor's degree in CS, MIS or related field.
  • 2–3 years of HR systems experience including configurations and customizations.
  • 2–3 years of HTML, ASP, JavaScript, XML, MS Access, SQL, PL/SQL or similar.
  • 2–3 years HR reporting tools or data warehouse knowledge (EiS, Cognos, OBIEE, etc.).
  • Team experience in a knowledge-sharing environment.

Responsibilities

  • Support and facilitate the use of HR applications as part of the department team.
  • Develop quality documentation and test plans with project team members.
  • Develop or maintain HR Websites, queries, scripts, and views.
  • Learn new software technologies and apply them to user requirements.
  • Develop and optimize HR reporting using Web methods, EiS/OBIEE or SQL tools.
  • Coordinate inter-departmental tasks with OHR and OIT teams.
  • Follow SDLC through requirements, architecture, coding and testing.

Skills

HTML
ASP
XML
C-Sharp
JavaScript
PHP
CSS
SQL
VB

Education

Bachelor's Degree in CS/MIS/related field

Tools

MS Access
EiS
OBIEE
Cognos
Report Writer
Sigma
Scantron

Job description

The Office of Human Resources (OHR) IT unit is responsible for supporting OHR's mission of collaborating with client departments to deliver quality customer service. This position will be a member of a small team that supports existing and evolving applications using HTML, ASP, XML, SQL, MS Access, Excel, and various Reporting tools. Applications are both web applications and client server deployed. Support for off-the-shelf software is also required, as well as the development of new applications.

Essential Functions

Participate as a team member to support and facilitate the use of applications in the department which includes understanding Human Resources operations

Work closely with the project team members to develop quality documentation and test plans

Develop or maintain efficient HR Websites, queries, scripts, macros, views and other methods requests

Demonstrated ability to learn new software and/or technologies and determine appropriate uses based on user requirements

Develop and optimize complex HR reporting needs using Web based methodologies, existing EiS and/or OBIEE reporting tools, and/or MS/Oracle SQL reporting tools in multiple database environments

Work well with Office of Human Resources (OHR), Office of Innovation and Technology (OIT) resources and other departments on inter-departmental tasks and projects

Gather user requirements and develop applications, Web based, and otherwise

Help coordinate the implementation of short- and long-term projects, objectives, policies and procedures for the production and maintenance of all application development related issues

Follow SDLC methodology including requirements gathering, solution architecture, coding, and testing

Review code and high-level designs by other team members to ensure that strategic objectives and business needs are met

Proactively identify application inefficiencies and propose solutions

Identify, create, and maintain development frameworks and code libraries

Create prototypes and functional specifications for application development projects

Work closely with the team members and QA analysts to develop quality assurance documentation and test plans

Work closely with production support and help desk staff to develop operating documentation.

Make suggestions on creating technical standards for specific applications and the City as a whole

Competencies, Knowledge, Skills and Abilities

Apply application development standards and best practices

Understand application and network architecture

Reliably deliver work of the highest standards on time

Solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists

Interpret a variety of instructions, furnished in written, oral, diagram, or schedule form and communicate them effectively

Include documentation both external to, and internal to, applications

Document code or processes written by other programmers or vendors

Diagnose and communicate software & hardware issues, suggest fixes, as appropriate to vendors

Upgrade or repurpose existing applications & equipment

Demonstrate exemplary communication skills with management, administrative and technical staff

Working Knowledge of:

HTML, ASP, XML, C-Sharp, JavaScript, PHP, CSS

PeopleAdmin, Testing Software i.e. Sigma, Scantron

Client Server architecture & Web architecture, including Web services

SQL, stored procedures and efficient use of SQL query language, and scheduled jobs.

Microsoft tools, VB, MS Access coding a plus

Network Administration, Active Directory, Desktop Services, Hardware & Software configurations

LAN / WAN support knowledge

Required:

Completion of a Bachelor's Degree program at an accredited college or university that includes major course work in computer sciences, management information systems or a related field

2-3 years of experience with Human Resources Systems including configurations, customizations - Preferably with Web/SQL development and interfacing with HR systems

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 based reporting tools or Data Warehouse knowledge such as EiS, Report Writer, Cognos, OBIEE, similar transaction based / data warehousing and reporting tools

Working with a team in a knowledge sharing environment

Salary Range: $80,000 - $87,000

Starting salary to be determined based on experience and qualifications.

All applications should include the following:
  • Cover Letter clarifying your interest and qualifications for the role.
  • Resume

We won't accept or review incomplete applications.

Work Setting: in-person (onsite)

Discover the Perks of Being a City of Philadelphia Employee:
  • 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 option
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

HR Web & SQL Developer (Applications & Reporting)
HR Web & SQL Developer (Applications & Reporting)

Cityofphiladelphia • Philadelphia

On-site
USD 80,000 - 87,000
Comprehensive health coverage
Wellness program with discounted plan
Paid vacation, sick leave and holidays
+1
Employee Development & Engagement Coordinator
Employee Development & Engagement Coordinator

City of Philadelphia • Philadelphia

On-site
USD 50,000 - 60,000
Health coverage
Wellness program
Paid time off
+4
ERP Integrations Developer
ERP Integrations Developer

City of Philadelphia • Philadelphia

On-site
USD 81,000 - 99,000
SEPTA transit access
Paid parental leave
Comprehensive health coverage
+2
Office of Community Engagement and Opportunity - Human Resources Specialist
Office of Community Engagement and Opportunity - Human Resources Specialist

Philadelphia PA • Philadelphia

On-site
USD 57,000 - 61,000
Transportation: free SEPTA public fare
Parental leave: 8 weeks
Comprehensive health coverage
+4
HRIS Administrator I
HRIS Administrator I

S&T Bancorp, Inc. • West Fairview (PA)

On-site
USD 36,000 - 81,000
Low Code Specialist
Low Code Specialist

City of Philadelphia • Philadelphia

On-site
USD 80,000 - 90,000
Office of Community Engagement and Opportunity - Human Resources Specialist
Office of Community Engagement and Opportunity - Human Resources Specialist

City of Philadelphia, PA • Philadelphia

On-site
USD 57,000 - 61,000
Transportation: Free SEPTA transit
Parental leave
Comprehensive health coverage
+5
ERP Test Planning Analyst
ERP Test Planning Analyst

City of Philadelphia, PA • Philadelphia

On-site
USD 81,000 - 99,000
Health coverage for employees and and/
Wellness program with discounted plan
Paid vacation, sick leave, and holid"
+1
HRIS Administrator I
HRIS Administrator I

S&T Bancorp, Inc. • Pittsburgh

On-site
USD 36,000 - 81,000
Sr IT Administrative Analyst
Sr IT Administrative Analyst

Philadelphia, PA • Philadelphia

On-site
USD 40,000 - 67,000
Health coverage
Paid vacation
Retirement savings
+1