[Remote] Consultant - Systems Integration & Data
Note: The job is a remote job and is open to candidates in USA. Intra Management Solutions, Inc. is growing, and they are looking to hire an Integrations & Data Consultant. This role involves designing, developing, and supporting integrations between APIs, web services, databases, and enterprise applications, while engaging directly with clients to implement new technologies and processes.
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
Skills
- 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
- 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
Benefits
- Competitive compensation package including base salary, incentives
- Fully paid medical coverage for our team members
- 401 (k) with match
- Standard holidays
- Generous vacation time
Company Overview