
Information Security Project and Service Management Software and Applications Systems and Infrastructure User Success
Management Professional Supervisory
Penn State Job Catalog
Automation and Integration Specialist – Senior Professional (PSU1674)
Job Summary and Representative Duties
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 Matrix
- 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
Salary Structure
- Comp Grade – 11
- Minimum – $68,200.00
- MidPoint – $85,200.00
- Maximum – $102,300.00
Critical Skills
- Data Analysis
- Debugging
- Document management
- Incident management
- Information governance
- Process design
- Software testing
- Technical development
- User experience