Integrations Specialist

Digital Resource; United States; Remote; USD 80,000 - 120,000; Full time

Job summary

Digital Resource is seeking an Integration Specialist to focus on integrating enterprise applications used to maintain and update our client reporting platforms. The role enhances business processes by seamlessly connecting systems through SQL queries, CSV file transfers, and API integrations.

A solid technical background, a keen eye for detail, and a passion for streamlining data flow are essential. You will join the Tech Ops Team within our marketing agency and report directly to the Tech Ops

Qualifications

• Bachelor’s degree in Computer Science or related field or equivalent experience.
• Minimum of 2 years experience in a similar role.
• Proficiency in writing complex SQL queries for data extraction/ETL.
• Hands-on experience with CSV file manipulation and data transformation.
• Basic programming skills (e.g., Python, Java).
• Experience with API integration tools and frameworks (REST, SOAP, GraphQL).
• Experience with Google Cloud Platform for data ingestion and warehouses.
• Familiarity with project management fundamentals; Basecamp is a plus.

Responsibilities

• Design, develop, and implement SQL queries to extract data from multiple sources.
• Create and manage CSV file transfer processes.
• Build, test, and maintain API integrations for real-time data exchange.
• Troubleshoot integration issues and ensure data flow.
• Develop documentation for integration processes including data mapping and SOPs.
• Monitor performance and address bottlenecks.
• Stay updated on industry trends in integration, data management, and security.

Skills

SQL queries

Data integration

API integrations

CSV handling

Programming basics (Python/Java)

REST/SOAP/GraphQL

Google Cloud familiarity

Attention to detail

Education

Bachelor's degree in Computer Science or related field

Tools

Postman

Insomnia

Google Cloud Platform

Job description

We’re looking for an Integration Specialist to focus on integrating enterprise applications used to maintain and update our client reporting platforms. This position enhances business processes by seamlessly connecting various systems through SQL queries, CSV file transfers, and API integrations. This specialist must exhibit a solid technical background, a keen eye for detail, and a passion for streamlining data flow across complex enterprise environments.

This role will join the Tech Ops Team within our marketing agency and report directly to the Tech Ops Manager. This is a fully remote role.

Responsibilities

• Design, develop, and implement SQL queries to extract data from multiple source systems, ensuring data accuracy and optimal performance.
• Create and manage efficient CSV file transfer processes that move data between various systems while maintaining data integrity and security.
• Build, test, and maintain API integrations to facilitate real-time data exchange between various applications and platforms.
• Troubleshoot and resolve integration-related issues, ensuring smooth data flow and uninterrupted business processes.
• Assist with developing documentation for integration processes, including technical specifications (if needed), data mapping, and standard operating procedures.
• Monitor ongoing integration performance and proactively address any performance bottlenecks or issues that may arise.
• Stay up-to-date with industry trends and best practices related to application integration, data management, and security.

Qualifications

• Bachelor’s degree in Computer Science or related field - OR equivalent experience is preferred.
• Minimum of 2 years experience in a similar role
• Proficiency in writing complex SQL queries for data extraction, transformation, and loading (ETL) processes
• Hands‑on experience with CSV file manipulation, data parsing, and transformation techniques
• Basic programming skills are a plus (e.g., Python, Java, or others used for API development)
• Experience with API integration tools and frameworks (e.g., REST, SOAP, GraphQL, Postman, Insomnia, etc.)
• Experience developing applications using Cloud providers, preferably Google Cloud. (e.g., building VM, data warehouse, data ingestion, etc.)
• Understanding of project management fundamentals. Experience with Basecamp is a plus.