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:

– Professional

Base Description:

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

Level Summary:

– Demonstrates baseline working knowledge of routine work tasks. Follows the standard principles and practices. Acts under direct and frequent supervision using established procedures with detailed instructions. Participates as a team member and actively contributes to completion of team goals. Clearly communicates information.

Supervisory Responsibilities:

– None

Fiscal Responsibilities:

– Typically none

Problem Solving:

– Encounters routine problems
– Follows recommended course of action and procedures to resolve problems

Independence of Action:

– Work is closely monitored by supervisor
– Detailed instructions and procedures are provided
– Applies standard operating procedures with limited guidelines for deviation

Communication and Collaboration:

– Typically communicates internally within working unit
– Collaborates closely with team members
– Clearly communicates information, ideas, or instructions verbally and in writing

• Comp Grade – 8
• Minimum – $51,000.00
• MidPoint – $62,500.00
• Maximum – $74,000.00