Job DescriptionJOB SUMMARYThe ERP Administrator (Integrations) is responsible for administering, designing, implementing, and managing secure reliable, scalable system-to-system data integrations across the enterprise. This role develops and enforces data governance and building Extract, Transform, Load (ETL) processes, Application Programming Interface (API) based integrations, and real-time and batch data exchanges to ensure consistent, accurate, and compliant data flows between internal platforms and external systems.
ESSENTIAL DUTIES & RESPONSIBILITIESIntegration Development and Support- Administrates, designs, develops, and maintains application-to-application integrations using APIs Representational State Transfer/Simple Object Access Protocol (REST/SOAP), file-based interfaces Secure File Transfer Protocol/File Transfer Protocol (SFTP/FTP), and database connections.
- Builds and supports ETL processes to extract, transform, and load data between systems using SQL and integration tooling.
- Develops and consumes RESTful APIs and web services using standard data formats JavaScript Object Notation (JSON), Extensible Markup Language (XML).
- Implements data mappings, transformations, and validation rules to ensure accuracy, consistency, and reliability of exchanged data.
- Writes and optimizes Structured Query Language (SQL) queries, stored procedures, and data extraction logic in support of integrations.
- Collaborates with functional teams, analysts, and application owners to translate business requirements into technical integration solutions.
- Troubleshoots and resolves integration defects, data issues, and interface failures.
- Creates and maintains technical documentation, including interface specifications, data mappings, integration flow diagrams, configuration workbooks, design documents, and knowledge materials.
- Supports testing activities, including unit, system, and regression testing, for integration solutions.
- Ensures integrations follow security, data governance, and coding standards.
- Demonstrates working knowledge of Public Key Infrastructure (PKI), including certificate-based. authentication used by platforms such as Kubernetes.
- Demonstrates familiarity with event driven messaging.
Problem Solving and Analytical Skills- Evaluates technical risks and recommends approaches that improve solution reliability, maintainability, and long-term supportability.
- Breaks down complex technical and business problems into clear analysis, options, and actionable recommendations.
- Identifies solution options, constraints, and tradeoffs that may not be immediately apparent to stakeholders.
- Applies deep business process understanding to anticipate downstream impacts, avoid future pitfalls, and identify improvement opportunities.
- Accurately scopes and estimates effort required for new functionality and break-fix work.
REQUIREMENTS- Bachelor of Science degree or two years of certified technical IT training as identified in job posting supplement, or relevant, equivalent experience and/or education.
- Minimum of three (3) years of experience in application integration, ETL development, or system-to-system data exchange
- Must possess sound research and analytical problem-solving capabilities.
- Strong communication skills with the ability to convey complex issues to non-technical colleagues.
- Positive attitude towards collaboration.
- Willingness to work in a fast-paced, high-intensity environment, which may require longer hours.
- Working knowledge of the systems detailed within the duties and responsibilities.
- Ability to multitask and balance workload based on business priorities.
- Ability to work with minimal supervision.
- Participates in 24/7 support of the supported systems.
- Applicants must be authorized to work in the United States for any employer. ITC does not sponsor employment visas, such as H-1B or TN visas.
Supplement: Additional Responsibilities and Qualifications - Experience supporting CI/CD pipelines using Git-based workflows
- Experience with integration tools like IBM CP4I or Oracle ODI
- Familiarity with Linux
- Familiarity with common scripting languages like Python, Bash, PowerShell used to support integrations
- Familiarity with Containerized or orchestrated environments (examples Kubernetes, Docker, OpenShift, Ansible, YAML and related platform related tools)
