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:

– Senior Professional

Base Description:

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

Level Summary:

– Demonstrates advanced knowledge of principles, practices, and procedures of a particular field. Works independently on moderately complex work assignments under limited oversight, reviews progress, and evaluates results. Monitors work and projects ensuring timeliness, quality, and efficiency. Identifies and mobilizes resources to achieve outcomes. Trains others and reviews progress with management. Presents ideas, concepts, and instructions in a clear and persuasive manner. Develops new techniques, concepts, and approaches and applies them to moderately complex and strategic and/or operational issues.

Supervisory Responsibilities:

– Indirect supervisor for other full–time employees
– May serve as direct supervisor for part–time, student, and/or temporary workers, volunteers, or a full–time employee

Fiscal Responsibilities:

– May validate and pay invoices
– Monitors and tracks budgets and funding

Problem Solving:

– Encounters moderately complex problems
– Applies specialized knowledge and skills to resolve problems
– Understands benefits, limitations, and impact of potential solutions

Independence of Action:

– Works independently on moderately complex work assignments, reviews progress, and evaluates results
– May set priorities and organize work within general guidelines established by supervisor
– May review the work of others to verify accuracy and conformance to required procedures and special instructions

Communication and Collaboration:

– Communicates internally within working unit and the University
– Communicates with external audiences for scheduling/coordination
– May communicate with external audiences for business purposes
– Coaches others in using appropriate strategies for resolving conflict; negotiating reasonable compromises; and proposing and evaluating possible solutions
– Give candid and constructive feedback to others to influence and persuade managers and employees to accept and implement findings and recommendations

• Comp Grade – 12
• Minimum – $76,700.00
• MidPoint – $95,900.00
• Maximum – $115,100.00