Data Integration Engineer

Simplified IT Solutions; Sacramento (CA); On-site; USD 80,000 - 110,000; Full time

Job summary

Join a forward-thinking company as a Data Integration Engineer, where you will play a crucial role in ensuring the reliability and accessibility of enterprise applications. This exciting position involves designing and implementing integrations that connect various data sources and platforms, including ERP and CRM systems. You will leverage your expertise in API development and ETL processes to create scalable and reusable solutions. Collaborating with cross-functional teams, you will contribute to the success of mission-critical business functions while enhancing your skills in a dynamic environment. If you are passionate about data integration and looking to make a significant impact, this opportunity is perfect for you.

Qualifications

• Extensive experience with API development and ETL processes is essential.
• Proficiency in SQL and advanced integration tools is required.

Responsibilities

• Design and implement integrations for enterprise applications.
• Collaborate with teams to analyze requirements and design solutions.

Skills

API Development

ETL Processes

SQL

Data Integration

Communication Skills

Problem Solving

Education

Bachelor's degree in Computer Science

Management Information Systems

Tools

Informatica Intelligent Cloud Services (IICS)

Open API Specification

REST/SOAP Services

GraphQL

Unix Shell Scripting

Job description

Company Description

Simplified IT is a global IT Staffing and Managed Services company. We have been rated top 10 staffing companies in the country for 3 years in a row. We serve technology, financial, auto, logistics & distribution companies across the United States, providing either IT staffing or technology solutions — or both. With decades of experience and a nationwide network of highly qualified, certified IT professionals, our goal is to build a lasting relationship with each client based on trust and consistent, reliable services.

Job Description

Job Overview:

The Data Integration Engineer will provide technical support to ensure the reliability, integrity, accessibility, and usability of enterprise applications supporting mission-critical business functions. This role focuses on designing and implementing integrations to connect multiple data sources, platforms, and applications, including ERP, CRM, REST services, and unstructured data. The ideal candidate will leverage their expertise in API development, ETL processes, and integration frameworks to create scalable, reusable, and reliable data integration solutions. They will play a critical role in supporting institutional goals through efficient data exchange processes and collaboration with cross-functional teams.

Key Responsibilities:

• Design, develop, and unit test ETL and API/Data Service implementations to support seamless integration of enterprise applications.
• Create and maintain integrations using tools like Informatica Intelligent Cloud Services (IICS) and API Management platforms.
• Develop APIs using Open API Specification, REST/SOAP services, and GraphQL to support data exchange across systems.
• Collaborate with data architects on data model and logical interface designs to ensure scalability, quality, and efficiency.
• Troubleshoot and resolve technical issues in data integrations, ensuring rapid response to production challenges.
• Adhere to data architecture standards, reuse code bases, and create detailed design artifacts to document solution metadata and implementation.
• Provide Tier 2 on-call production support for implemented solutions.
• Participate in peer design and code reviews to ensure adherence to quality standards.
• Work collaboratively with business and IT stakeholders to analyze business requirements and design integration solutions.

Qualifications:

Required Knowledge, Skills, and Abilities:

• Extensive experience with Ellucian Ethos API development, Open API Spec Design and Development, and system integrations.
• Expertise in Enterprise API (or Web) Services, SQL, and ETL development.
• Proficiency in technologies such as PL/SQL, Pro*C, Unix Shell scripting, XML, JSON, and advanced integration tools (e.g., Informatica CDI/CAI).
• Experience with REST/SOAP APIs, Open API Specification, and GraphQL.
• Knowledge of secure data transmission and integration techniques.
• Strong communication and collaboration skills across technical and non-technical teams.
• Proven ability to analyze technical issues effectively and provide innovative solutions.
• Ability to define and document integration requirements and design artifacts.
• Commitment to customer focus and continuous improvement.
• Experience in analyzing, designing, and coding data exchange or integration solutions.

Preferred Skills:

• Knowledge of advanced scripting languages like PERL or Node.js.
• Java programming experience.
• Familiarity with Salesforce CRM integration features.
• Knowledge of Agile or SCRUM practices.

Education and Experience:

• Bachelor’s degree in Computer Science, Management Information Systems, or a related field (or equivalent combination of education and demonstrable work experience).
• Progressively responsible experience in the analysis, design, and implementation of data exchange and application integrations.

Certifications (Preferred):

• Agile or SCRUM methodologies.
• Salesforce Platform certifications.
• Informatica iPaaS certifications.

All your information will be kept confidential according to EEO guidelines.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Information Technology

Industries

• IT Services and IT Consulting