Consultant - Systems Integration & Data

Intra Management Solutions•Frisco, TX

4d•Remote

About The Position

Intra Management Solutions is growing and looking to hire an Integrations & Data Consultant. This is an exciting role that will work with clients to implement new technologies and processes. The role is remote, with approximately 25-30% travel required to support clients on-site. We are seeking a Consultant to design, develop, and support integrations between APIs, web services, databases, ERP platforms, and enterprise applications. This role combines hands-on technical implementation with direct client engagement in a rapidly growing market. The Consultant will be integrated into the IMS Technology Consulting practice and support implementation teams in helping create integrated systems and data environments. The ideal candidate will have a foundational understanding of APIs, databases, scripting, and enterprise business applications, with an interest in supporting integrations across ERP, finance, project management, and operational systems. Due to the nature of client engagements, U.S. Citizenship is required.

Requirements

Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field, or equivalent professional experience.
1–3 years of experience in systems integration, software development, data analysis, application support, or a related technical role.
Experience working with APIs and web services.
Familiarity with scripting languages such as Python, JavaScript, PowerShell, Bash, or similar technologies.
Experience writing SQL queries and working with relational databases.
Understanding of common data formats, including JSON, XML, CSV, and other structured data formats.
Basic understanding of data integration, ETL processes, and application connectivity.
Strong analytical, troubleshooting, and problem-solving skills.
Excellent verbal and written communication skills with the ability to work directly with clients and business stakeholders.
Strong organizational skills and attention to detail.
Ability to manage multiple priorities in a fast-paced consulting environment.
U.S. Citizenship

Nice To Haves

Exposure to enterprise integration platforms such as MuleSoft, Boomi, Azure Data Factory, Oracle Integration Cloud (OIC), Alteryx, or similar technologies.
Experience with cloud platforms such as AWS and/or Microsoft Azure.
Working knowledge of Oracle technologies and platforms an advantage
Familiarity with database design, data modeling, ETL processes, stored procedures, and enterprise data integration concepts.
Experience developing reports, dashboards, and data visualizations using Microsoft Power BI or similar business intelligence platforms.
Familiarity with data warehousing, big data, and data lake concepts.

Responsibilities

Design, develop, test, and support integrations between APIs, web services, databases, ERP systems, and business applications.
Create scripts and automation processes to extract, transform, validate, and synchronize data across multiple systems.
Develop and maintain integrations using REST APIs, SOAP services, SQL queries, and file-based data exchanges (JSON, XML, CSV).
Work directly with clients to gather business and technical requirements, understand system architecture, and define integration specifications.
Perform data mapping and transformation between source and target systems.
Troubleshoot and resolve integration, connectivity, performance, and data quality issues.
Participate in client meetings, workshops, requirements sessions, and implementation activities.
Assist with integration architecture, solution design, and technical recommendations.
Create and maintain technical documentation, including integration designs, data mappings, API specifications, testing plans, and support procedures.
Support testing, deployment, and post-implementation activities.
Collaborate with project managers, developers, solution architects, business analysts, and client stakeholders to deliver successful integration solutions.
Ensure solutions adhere to security, compliance, and data governance requirements.
Monitor and maintain production integrations, identifying opportunities for optimization and automation.