Penn State Job Catalog

Additional levels that exist for this job profile can be seen below.

The defined natural career progression within or between job profiles.

Data Warehouse Programming

The Data Warehouse Programming Specialist designs, develops, implements, and maintains a data warehouse; implements procedures to structure, integrate, and validate data to ensure data compatibility, accuracy, and reliability; develops data warehouse process models to define and display data flow between applications and systems.

• Define, create, and build data warehouse architecture and data systems to optimize data access, consistency, accuracy, and capabilities
• Develop, test, analyze, and implement extract, transform, and load (ETL) processes in order to accurately and efficiently pull and organize data into a warehouse; define and document data integration strategies
• Develop, implement, and test code according to design specifications
• Develop data warehouse process models; create data dictionaries to provide thorough and clear definitions of data; map data to illustrate the flow between systems
• Test and verify the structure, accuracy, and quality of warehouse data
• Utilize the third-party applications; append data and operate the application to ensure it is maintained in the data warehouse
• Discuss data projects with end users; assess and verify requirements and business needs to determine the appropriate specifications and the necessary systems needed to accomplish goals
• Resolve end-user data and report issues; troubleshoot data warehouse daily load jobs; verify results and communicate resolution/findings
• May supervise staff members, including hiring, development, and performance management

Level:

– Intermediate Professional

Base Description:

– Completes activities, tasks, and/or projects of a functional nature.

Level Summary:

– Demonstrates ability to perform intermediate tasks in defined skill areas. Demonstrates intermediate knowledge of internal procedures. Works under general supervision, performing assignments that may be varied and sometimes difficult. Supports team decisions and follows through with team responsibilities. Interprets and communicates information clearly and accurately. Demonstrates intermediate problem–solving skills.

Supervisory Responsibilities:

– May serve as direct supervisor for part–time, student, and/or temporary workers or volunteers

Fiscal Responsibilities:

– May validate and pay invoices

Problem Solving:

– Encounters generally routine problems; occasionally faces more complex and/or varied problems
– Typically follows recommended course of action and procedures to resolve problems
– Applies knowledge of larger unit goals, priorities, and related procedures in determining course of action

Independence of Action:

– Work is generally monitored by supervisor
– Detailed instructions and procedures are generally provided
– Uses available guidelines to make appropriate adaptations to routine situations and refers other situations to supervisor

Communication and Collaboration:

– Communicates internally within working unit and/or the University
– May communicate with external audiences
– Collaborates closely with team members
– Interprets and communicates information, ideas and instructions clearly and accurately both verbally and in written materials intended for distribution

• Comp Grade – 10
• Minimum – $61,800.00
• MidPoint – $75,700.00
• Maximum – $89,600.00