Programmer/Analyst 3

Penn State University

Campus/Location:
University Park Campus
Campus City:
University Park, PA
Date Announced:
09/06/2019
Date Closing:
09/12/2019
Job Number:
90531
Level/Salary Band:
03 – K – Exempt
Work Unit:
Outreach
Department:
Outreach Information Technology
Full/Part Time:
Full–Time

Description

Outreach Information Technology is looking for a highly motivated, talented and experienced Database Developer. The successful candidate will be responsible for the design, development, and implementation of complex data integration processes, using Microsoft SSIS, SQL stored procedures, and transact SQL; query performance tuning; providing operational support; and creating documentation. Typically requires a Bachelor's degree or higher plus four years of related experience, or an equivalent combination of education and experience. The ideal candidate must be detail oriented, have strong data analysis skills, identify and solve problems independently, handle sensitive data professionally, have a strong commitment to customer service, have excellent written and interpersonal communication skills, and work independently as well as collaboratively within a team. The ideal candidate should be able to draw from previous experience to demonstrate competency in the following required skills: designing and delivering data warehouse Extract, Transform and Load components using technology platforms such as SQL Server Integration Services (SSIS) and Microsoft SQL Server 2012 or 2016. Experience with CI/CD, DevOps, Git, Jenkins, and/or RedGate tools is a plus. Comprehension of full software development lifecycle as well as change control processes and practices is desired. We seek candidates who are able to demonstrate experience and the ability to advance Outreach’s diversity initiative. This is a fixed-term appointment funded for one year from date of hire with good possibility of re-funding.

These salary bands have been established to provide salary guidelines for staff positions.

Salary Band Minimum Midpoint Maximum
A $16,584 $24,456 $32,328
B $18,240 $26,904 $35,556
C $19,728 $29,592 $39,456
D $21,708 $32,568 $43,416
E $24,312 $36,468 $48,612
F $27,228 $40,848 $54,456
G $30,012 $45,744 $61,500
H $34,188 $52,140 $70,080
I $38,988 $59,424 $79,908
J $43,716 $67,740 $91,812
K $50,712 $78,600 $106,488
L $58,836 $91,176 $123,528
M $68,232 $105,756 $143,292
N $80,508 $124,788 $169,068
O $93,492 $147,252 $201,024
P $110,340 $173,760 $237,192
Q $126,396 $199,056 $271,728
R $151,668 $238,872 $326,088