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

Data Warehouse Programming Specialists perform duties related to data warehouse design and configuration. Provide support for data warehouse and responsible for coding and documenting procedures, and programming, testing and debugging data warehouses.

• Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements
• Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies
• Develop data models for data warehouse, data dictionaries to provide thorough and clear definitions of data.
• Verify the structure, accuracy, or quality of warehouse data
• Provide or coordinate troubleshooting support for data warehouses
• 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