Vendor Integration Specialist

- I will lead technical discovery sessions and integration planning with vendor technical teams to assess APIs, define data exchange formats (such as JSON, XML, CSV), and determine suitable transport methods (e.g., REST, SOAP, SFTP). - I will design, document, and uphold technical integration specifications for external vendor systems, including data mappings, interface definitions, transformation logic, and delivery protocols while ensuring integration solutions meet scalability, performance, and security standards. - I will provide consultation and L3 support for the implementation and maintenance of robust ETL pipelines using tools like SQL Server Integration Services (SSIS), aiding automated data ingestion, transformation, validation, and delivery between systems. - I will craft and optimize intricate SQL queries and stored procedures to bolster large-scale data integration, monitoring, and reconciliation tasks, ensuring high availability and performance of backend data processes. - I will act as the technical point of contact for all vendor integration concerns, taking ownership of problem resolution, root cause analysis, and long-term stability planning. I will collaborate with infrastructure and development teams as needed. - I will execute and maintain integration monitoring and alerting systems to proactively identify issues in data transfers, latency, and schema mismatches, working with stakeholders to triage and resolve production incidents. - I will establish and maintain robust working relationships with external vendors in a client-facing capacity, ensuring clear communication for ongoing integration needs, enhancements, troubleshooting, and compliance requirements. - I will serve as a trusted connection between Quantum Health and vendor technical teams, translating business needs into actionable technical plans and ensuring vendor deliverables align with contractual and operational expectations. - I will engage in vendor performance reviews to provide technical insights on integration health, incident history, and improvement opportunities. - I will collaborate with Legal, Security, and Compliance teams to ensure vendor integrations comply with data privacy laws (e.g., HIPAA), secure authentication practices, and internal governance policies. - I will support ongoing improvement initiatives by identifying opportunities for integration automation, minimizing manual handoffs, and contributing to architecture and process advancements. - I will perform other duties as required.