ERP Administrator – Integrations

Role Overview

• Responsible for administering, designing, implementing, and managing secure reliable, scalable system-to-system data integrations across the enterprise.
• Develops and enforces data governance and building Extract, Transform, Load (ETL) processes.
• Administers, designs, develops, and maintains application-to-application integrations using APIs REST/SOAP, file-based interfaces SFTP/FTP, and database connections.
• Builds and supports ETL processes to extract, transform, and load data between systems.
• Develops and consumes RESTful APIs and web services using standard data formats JSON, XML.
• Implements data mappings, transformations, and validation rules to ensure accuracy, consistency, and reliability of exchanged data.
• Writes and optimizes 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.

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.

Tech Stack

• ETL
• SOAP
• SQL

Benefits

• Health insurance
• 401(k) matching
• Paid time off
• Flexible work arrangements
• Professional development opportunities