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:

– Advanced Professional

Base Description:

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

Level Summary:

– Demonstrates proficient and comprehensive knowledge of defined skill areas/applications. Applies knowledge of principles, practices, and procedures of a particular field to decision-making and problem–solving. Works under minimum supervision on varied and sometimes difficult work assignments, conferring with supervisor or subject matter experts on unusual matters. May lead others or a team in completion of complex assignments. Interprets and communicates information clearly, accurately, and persuasively. Researches and tries new approaches when solving difficult or novel problems.

Supervisory Responsibilities:

– Indirect supervisor or mentor 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
– May monitor/track budgets and funding

Problem Solving:

– Encounters generally routine problems with progressively more complex and/or varied problems
– Typically follows recommended course of action and procedures to resolve problems
– May apply specialized knowledge and skills to resolve complex and/or varied problems, with supervisor oversight
– Researches and tries new approaches when solving problems

Independence of Action:

– Works with minimal supervision on more difficult work assignments, conferring with supervisor on unusual matters
– Follows precedents and procedures
– May set priorities and organize work within general guidelines established by supervisor

Communication and Collaboration:

– Communicates internally and externally within working unit and the University
– May communicate with external audiences for business purposes
– Promotes open communication in a manner that builds relationships among team members
– Applies appropriate strategies for managing conflict; negotiate reasonable compromises; propose and evaluate possible solutions
– Interprets and communicates information, ideas and instructions clearly, accurately and persuasively both verbally and in written materials intended for distribution

• Comp Grade – 10
• Minimum – $61,800.00
• MidPoint – $75,700.00
• Maximum – $89,600.00

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