ERP Administrator (Integrations)

ITC Holdings•Novi, MI

About The Position

The ERP Administrator (Integrations) is responsible for administering, designing, implementing, and managing secure, reliable, and scalable system-to-system data integrations across the enterprise. This role develops and enforces data governance and builds 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.

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.

Nice To Haves

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)

Responsibilities

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.
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.