ERP Administrator – Integrations

Consumers Energy

ERP Administrator responsible for data integrations across ITC's enterprise systems. Designing and implementing secure, scalable system-to-system data integrations and data governance practices.

Posted 6/30/2026full-timeNovi • Missouri • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

ETLSOAPSQL

About the role

Key responsibilities & impact

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

What you’ll need

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.

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Data IntegrationETL ProcessesRESTful APIsSOAP APIsSQL QueriesData MappingData TransformationData ValidationTechnical DocumentationIntegration Testing

Soft Skills

Analytical Problem-SolvingStrong CommunicationCollaborationMultitaskingAdaptability

Certifications

Bachelor of Science DegreeCertified Technical IT Training