Data Integration Specialist (Application Support)

Make your next big career move by applying as KMC Solutions' next DATA INTEGRATION SPECIALIST! SOCi, the marketing platform for multi-location brands, is currently looking for a Technical Support Engineer to join our growing team to help us achieve our next stage of rapid growth. The Technical Support Engineer is responsible for onboarding new customers onto SOCi's data ingestion platform, as well as monitoring and managing ongoing data ingestion processes across both API and SFTP platforms. This includes understanding complex configurations and data setups, transforming data to a standardized format, and taking ownership of each account from initial data onboarding through the entire ingestion lifecycle. The process will range from straightforward items to complex, multi-faceted problem solving. In this role, the Engineer will be actively onboarding new customers by configuring and validating their data ingestion pipelines, debugging ingestion issues, engaging directly with customers to gather data requirements, and ensuring that data flows are operating accurately and efficiently. They will be leveraging a multitude of technology stacks. The ideal candidate must have sufficient technical aptitude to manage difficult and/or complex customer situations and be a strong communicator with the ability to provide clear guidance towards a positive resolution. To be successful in this role, the candidate must be able to execute with a high degree of competency in identifying problems and ensuring that appropriate Product or Engineering teams are notified in order to resolve issues impeding the overall process. End to end accountability along with attention to detail, quality assurance, and documentation are all necessary for this role. On top of your salary, here are the exciting benefits you can look forward to: Health Insurance/HMO Enjoy unlimited MadMax Coffee Diverse learning & growth opportunities Accessible Cloud HR platform (Sprout) Above standard leaves The main responsibilities of a TECHNICAL ONBOARDING & SUPPORT ENGINEER include: Design, write, and maintain scripts and cron jobs to automate data pulls from customer APIs and SFTP sources, ensuring reliable and timely data ingestion into SOCi's platform. ● Monitor and manage ongoing data ingestion processes, proactively identifying and debug issues, system bottlenecks and long term structural fi xes to ensure data fl ows are operating accurately and effi ciently. Lead API implementation projects for enterprise clients and third-party agencies (e.g., coordinating automation integration requests from external marketing agencies, validating, and monitoring their data pipelines across API and SFTP channels.) ● Engage directly with customers to gather data requirements, translate business needs into technical confi gurations, and provide clear guidance throughout the data ingestion lifecycle. Investigate and resolve data quality issues in the location database, including missing address components, zip codes, categories, images, and URLs. Diagnose the downstream effects of bulk database uploads on listing status and data integrity. Provision and manage API keys for client accounts. Troubleshoot API-related technical defects, including payload mismatches between production and sandbox environments, failed or missing webhook event deliveries, and malformed API response data Own SSO/SAML implementation and rollout for new and existing enterprise clients, across both web and mobile app login. Diagnose SAML authentication failures, such as invalid SAML response and "SAML not enabled" errors. Maintain and support SSO configurations for enterprise clients, including certificate renewals, coordination of SOC2 Type II documentation for security reviews, migrations to new or multiple identity providers, bulk email-domain updates, and resolution of day-to-day login issues (expired tokens, disabled SSO options, shared-account access) ● Leverage Claude, ChatGPT, or other AI engines to streamline troubleshooting, accelerate data debugging, automate repetitive ingestion tasks, and improve overall support efficiency. To apply, you must be an expert on the following requirements: 3+ years of experience as a technical support engineer/application support specialist or programmer. Experience writing scripts in Python, Bash, JavaScript or similar languages to automate data pulls from customer APIs and SFTP sources, with the ability to build, test, and maintain them in a production environment. Solid working knowledge of REST APIs, API key management, webhooks, and debugging data across sandbox and production environments. Have working web stack knowledge including HTTP, browser console, and JavaScript. Strong experience with structured data fi les and fi le transfer protocols such as SFTP/FTP. Proven knowledge of SSO/SAML authentication fl ows, including certifi cate renewal and troubleshooting SAML error codes across web and mobile clients. Experience designing and managing cron jobs or similar task scheduling tools to automate and monitor recurring data ingestion processes, ensuring reliable and timely execution. Knowledge of and/or experience in: ○ Calling RESTful APIs ○ SQL Joins ○ Cloud computing (especially navigating and reading logs) ○ Basic testing principles as well as basic software engineering principles Familiarity with API authentication methods including OAuth, API keys, webhooks, and token-based authentication, with the ability to troubleshoot and confi gure them within a customer integration environment. ● Have a solid understanding of Application Programming Interfaces and how they are deployed and used in a customer environment. Become knowledgeable in SOCi's APIs and how to implement and support them in a production environment. Exceptional communication skills, both written and verbal are an ABSOLUTE must, for both technical and non-technical audiences. Comfort working directly with enterprise clients and their external agencies on technical implementation projects. Strong organizational and analytical skills with keen attention to detail The ability to self-direct as circumstances change and priorities shift, based on organizational needs, without the need for constant management Respect processes but be adaptable to change Coachable, open to feedback, and dedicated to constant self-improvement Prior experience with ticketing systems (such as Zendesk), basic SQL or database concepts, and identity provider platforms is benefi cial. Proven ability to manage a sizable number of service delivery projects with keen prioritization and multitasking abilities Education: B.S. in Computer Science or other degree with appropriate work experience It will also be favorable if you are knowledgeable in: Additional relevant knowledge or experience related to the above requirements will be considered an advantage.