Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via emailLocation: This position is located at our Dublin OH campus with hybrid flexibility.
Who weare
Founded in 1999 and headquartered in Central Ohio were a privately-owned independent healthcare navigation organization. We believe that no one should have to navigate the cost and complexity of healthcare alone and were on a mission to make healthcare simpler and more effective for our millions of members. Our big-hearted tech-savvy team fights to ensure that our members get the care they need when they need it at the most affordable cost thats why we call ourselves Healthcare Warriors.
Were committed to building diverse and inclusive teams more than 2000 of us and counting so if youre excited about this position we encourage you to apply even if your experience doesnt match every requirement.
About the role
Quantum Health integrates with a wide variety of partners through data exchanges and API interactions. These integrations need technical guidance and coordination with both business partners internally as well as external counterparts in the partner organizations to operate smoothly. To be successful in this role the person must be very well versed in the technical aspects of all our integrations and touchpoints as well as be a strong communicator. It is essential for the person in this role to have a demonstrated ability to collaborate with cross-functional teams and be a liaison between the various parties. This role will serve as a partner to the Client Engagement executives/ onboarding project managers and help project-manage any technical changes that need to be instituted.
What youll do
Lead technical discovery and integration planning sessions with vendor technical teams to evaluate APIs define data exchange formats (e.g. JSON XML CSV) and determine appropriate transport methods (e.g. REST SOAP SFTP).
Design document and maintain technical integration specifications for external vendor systems including data mappings interface definitions transformation logic and delivery protocols. Ensure integration solutions meet scalability performance and security standards.
Serve as consultant and L3 support for the deployment and maintenance of robust ETL pipelines using tools like SQL Server Integration Services (SSIS) supporting automated data ingestion transformation validation and delivery between systems.
Write and optimize complex SQL queries and stored procedures to support large-scale data integration monitoring and reconciliation tasks. Ensure high availability and performance of backend data processes.
Act as the technical point of contact for all vendor integration issues owning problem resolution root cause analysis and long-term stability planning. Coordinate with infrastructure and development teams as needed.
Implement and maintain integration monitoring and alerting to proactively detect issues in data transfers latency and schema mismatches. Work with stakeholders to triage and resolve production incidents.
Establish and maintain strong working relationships with external vendors in a direct client facing role ensuring clear communication channels for ongoing integration needs enhancements troubleshooting and compliance requirements.
Serve as a trusted liaison between Quantum Health and vendor technical teams translating business requirements into actionable technical plans and ensuring vendor deliverables meet contractual and operational expectations.
Participate in vendor performance reviews to provide technical insight on integration health incident history and opportunities for improvement.
Collaborate with Legal Security and Compliance teams to ensure vendor integrations adhere to data privacy regulations (e.g. HIPAA) secure authentication practices and internal governance policies.
Support continuous improvement efforts by identifying integration automation opportunities reducing manual handoffs and contributing to architecture and process enhancements.
Other duties as assigned
What youll bring
Education: Bachelors degree in Information Technology or equivalent experience
Demonstrated experience with Cloud technologies like AWS or GCP.
Demonstrated expertise in developing ETL pipelines and Data Orchestration tools like Apache Airflow.
Strong understanding of Relational Database concepts (i.e. normalization constraints etc)
Good understanding of Web Technologies including APIs and SSO.
Proficient at troubleshooting technical issues (query performance data integration anomalies)
3 years of Relational Database experience (SQL Server preferred)
3 years of demonstrated experience in working with external partners
3-4 years or ETL experience (SQL Server Integration Services preferred)
1-2 years experience with Data Warehouse concepts
Excellent written and verbal communication.
Proficient in T-SQL/Stored Procedures
Protect and take care of our company and members data every day by committing to work within our company ethics and policies
Data modeling experience preferred
Cloud integration experience preferred
Health Care experience preferred
Protect and take care of our company and members data every day by committing to work within our company ethics and policies
Strong administrative/technical skills; Comfort working on a PC using Microsoft Office (Outlook Word Excel PowerPoint) IM/video conferencing (Teams & Zoom) and telephones efficiently.
A high degree of personal accountability and trustworthiness a commitment to working within Quantum Healths policies values and ethics and to protecting the sensitive data entrusted to us.
--
#LI-KT1
#LI-Hybrid
Whats in it for you
What you should know
Reasonable Accommodation: Should you require reasonable accommodation(s) to participate in the application/interview/selection process or in order to complete the essential duties of the position upon acceptance of a job offer click here to submit a recruitment accommodation request.
Recruiting Scams: Unfortunately scams targeting job seekers are common. To protect our candidates we want to remind you that authorized representatives of Quantum Health will only contact you from an email address ending in @. Quantum Health will never ask for personally identifiable information such as Date of Birth (DOB) Social Security Number (SSN) banking/direct/tax details etc. via email or any other non-secure system nor will we instruct you to make any purchases related to your employment. If you believe youve encountered a recruiting scam report it to the Federal Trade Commission and your states Attorney General.
Full-Time