Consultant - Systems Integration & Data

Intra Management Solutions is growing, and we are looking to hire an Integrations & Data Consultant! This is an exciting role that will work with our clients to implement new technologies and processes. 

If you thrive on variety and love to help others grow their capabilities, this is the role for you. You will be part of a team that works together to deliver excellence for our clients. 


Consultant – Systems Integration & Data

About the Role

This 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 IMS Technology Consulting practice and support our 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 our client engagements, U.S. Citizenship is required. 

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

Required Qualifications 

• 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 

Preferred Qualifications 

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

What Makes Someone Successful in This Role 

We’re looking for someone who can; 

• Independently develop and support API, database, and ERP integrations.  

• Support senior consultants in client integration workshops and requirements-gathering sessions.  

• Troubleshoot and resolve production integration issues.  

• Create comprehensive technical documentation and integration specifications.  

• Develop expertise in enterprise applications, integration platforms, and cloud technologies.  

• Contribute to successful implementations for aerospace, defense, government, and commercial clients.  

• Build trusted relationships with client stakeholders and project teams. 

Why Join Us 

• Opportunity to work on challenging client engagements across industries  

• Exposure to project controls, technology implementation, and consulting advisory work  

• Collaborative team environment with opportunities for mentorship and growth  

• Ability to expand your expertise across project delivery technologies and business transformation initiatives 

Come join the IMS team, where we put people first. IMS offers a competitive compensation package including base salary, incentives, fully paid medical coverage for our team members, and a 401 (k) with match. We believe in working hard and playing harder, and offer standard holidays and generous vacation time. 

#LI-hybrid