JOB SUMMARY
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.
ESSENTIAL DUTIES & RESPONSIBILITIES
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-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)
Make a Power Move - For the Greater Grid: Reliable. Resilient. Ready.
As AI innovation, automation and economic growth reshape the way we live and work, the demand on our power infrastructure is growing fast. At ITC, we're building the greater grid that's ready for today's technology and tomorrow's possibilities.
Our people bring the power - fueling innovation and strengthening the grid every day. We're looking for individuals who are ready to make a power move and help us build a greater grid for a more reliable and affordable energy future.
ITC offers industry-leading compensation, benefits and opportunities to channel your energy into solutions. We foster a culture of belonging - where every voice is valued, differences are celebrated and everyone has the opportunity to thrive. Make a power move today.
