Penn State mark
All Jobs Information Technology Group
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)

Additional Levels

Additional levels that exist for this job profile can be seen below.

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
FLSA Exemption Status
Exempt
Minimum Education
Bachelor's Degree
Minimum Experience
6+ years of relevant experience
Equivalency
An equivalent combination of education and experience accepted