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.

Automation and Integration

IT Workload Automation

Automation and Integration Specialists manage and enhance the University’s enterprise automation and data integration platforms; are responsible for designing, developing, and maintaining robust, scalable, and efficient workflows and integrations using BMC Control-M and Informatica; collaborate with cross-functional teams to automate business processes, ensure data flow accuracy, and enhance the performance and reliability of University systems; ensure that all production schedules and scripts are executed on various server platforms as scheduled; analyze the production job flow, correct anomalies, source code maintenance, maintain job schedules, as well as build, coordinate, and implement new and existing integrations and workflows.

• Design, develop, and maintain enterprise workflows using BMC Control-M Workflow Orchestration

• Build, maintain, and optimize ETL (Extract, Transform, Load) data integration solutions using Informatica Integration Platform

• Translate business requirements into scalable, reliable, and secure technical solutions

• Debug, test, and document workflows and integrations throughout the software development lifecycle

• Implement data validation, error handling, and logging mechanisms to ensure data integrity throughout the ETL process

• Manage and oversee scheduled jobs, resolving failures or performance issues; provide solutions or workarounds for detected problems

• Investigate data and/or program problems, perform root cause analysis, take corrective actions; communicate and escalate degradations, outages, or failures associated with batch services to the responsible service contact and/or incident manager

• Ensure operational issues impacting service quality are escalated, communicated, and/or resolved in an expedient fashion

• Prepare and maintain disaster recovery procedures, user operations manuals, and other documentation   

• Ensure solutions comply with security, compliance, and University policies

• Evaluate and recommend improvements to system architecture, scalability, and performance

• Collaborate with application owners, database administrators, infrastructure teams, and business systems analysts to support integration needs

• Implement automation best practices to reduce manual intervention and streamline operations

Level:

– Principal Professional

Base Description:

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

Level Summary:

– Displays mastery of defined skill areas/applications, principles, theories and practices. Evaluates and enhances existing practices. Recognizes emerging trends in area of expertise. Works independently on complex or strategic assignments. Directs and delegates appropriate tasks to others. Implements strategies to ensure achievement of initiatives. Prepares written and/or verbal presentations or proposals on complex issues and deliver to broad audiences. Identifies and implements innovative solutions to important, highly complex 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:

– Validates and pays invoices
– Monitors and tracks budgets and funding
– May plan and forecast budgets

Problem Solving:

– Encounters complex and novel problems
– Applies policies, practices, 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 complex or strategic assignments
– Uses existing practices as guidelines as well as working knowledge to determine specific work methods
– Carries out work activities independently, with supervisor available to resolve problems
– Reviews work of others to verify technical soundness

Communication and Collaboration:

– Communicates with both internal and external audiences
– Collaborates closely with team members and area leads across the University
– Prepares written and/or verbal presentations or proposals on complex issues and delivers to a broad variety of audiences
– Establishes and maintains networks to facilitate successful communication among units

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

• Data Analysis
• Debugging
• Document management
• Incident management
• Information governance
• Process design
• Software testing
• Technical development
• Technical documentation
• User experience