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 Supervisor

Base Description:

– Supervises direct reports, but primarily completes activities, tasks, and/or projects of a functional nature.

Level Summary:

– Demonstrates comprehensive knowledge to perform own work; spends majority of time on tasks related to own job responsibilities. May demonstrate subject matter expertise. Demonstrates intermediate to advanced planning, organizing, directing, and facilitating skills. Demonstrates the ability to coach assigned employees. Assigns and reviews completed work to verify accuracy, quality, and adherence to professional standards. Trains, coaches, mentors, and motivates staff. Anticipates potential problems, issues, and opportunities; researches and recommends solutions within defined policies. May develop creative recommendations for solving problems.

Supervisory Responsibilities:

– Typically oversees at least 2 full–time direct reports or equivalent team of part–time and/or student workers (for Professional track, performs work at the Senior Professional level or higher)

Fiscal Responsibilities:

– May validate and pay invoices
– Monitors and tracks budgets for specific area and/or grant(s)
– May assist in planning and forecasting budgets

Problem Solving:

– Encounters moderately complex problems
– Applies general precedents and practices and specialized knowledge and skills to resolve problems
– Understands benefits, limitations and impact of potential solutions
– Anticipates potential problems and recommends possible solutions within general guidelines

Independence of Action:

– Works independently on moderately complex work assignments, reviews progress, and evaluates results
– Organizes work of direct reports and sets team priorities
– Reviews the work of others to verify accuracy, quality, and adherence to professional standards

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
– Collaborates closely with team members; may interact with other staff outside of area
– Utilizes a communication style that is appropriate for a given situation
– Interprets and communicates information, ideas and instructions clearly, accurately and persuasively both verbally and in written materials intended for distribution

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