ERP Administrator (Integrations)

ITC Holdings Corp.
Novi, United States of America
9 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Novi, United States of America

Tech stack

API
Application Integration Architecture
Bash
Data Governance
ETL
Data Mining
Database Connection
Software Design Documents
Linux
Electronic Data Interchange (EDI)
Event-Driven Programming
JSON
Python
Openshift
Oracle Applications
Public Key Infrastructure
Powershell
Regression Testing
Ansible
Simple Object Access Protocol (SOAP)
SQL Stored Procedures
SQL Databases
Data Streaming
Systems Integration
Web Services
XML
YAML
Scripting (Bash/Python/Go/Ruby)
File Transfer Protocol (FTP)
Git Flow
Kubernetes
Enterprise Integration
Integration Frameworks
Software Coding
REST
Docker

Job description

The 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., Integration 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

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)

Apply for this position