Sr. SQL Developer Data Interchange

US-CA-Irvine
Req No.
2017-2103
Category
Information Technology
Type
Regular Full-Time

Overview

ABOUT CONCERTOHEALTH 
ConcertoHealth Inc. is the leading provider of specialized primary care and supporting clinical services for complex, frail, elderly, and dual-eligible patients. Operating exclusively in value-based agreements, ConcertoHealth provides high-touch, individualized care for patients, and deploys wraparound clinical resources to extend the reach of primary care practices. This comprehensive medical management solution, elevated by Concerto’s proprietary population health technology, improves overall healthcare quality and patient outcomes, benefitting payers and their provider networks. The company is headquartered in Irvine, Ca. For more information, please visit www.concertohealth.com.
 
Implement and support multiple electronic data interchanges between healthcare partners while leveraging industry standards. This role must possess in-depth understanding of interchange methods and best practices.  Design and develop import and export structures used for business analytics, compliance, and monitoring.
This is a full-time position, based in the Concerto Healthcare offices in Irvine. The Senior EDI Developer will report to the Director of Data Solutions.

Responsibilities

  • Develop strategies for data acquisitions, archive recovery, and implementation of a database.
  • Design and manage the partner connectivity through SFTP, web service, or API.
  • Design, develop and unit test new database code to support requirements, using database triggers, stored procedures and views.
  • Development of both import and export processes utilizing SQL and SSIS.
  • Monitor file exchange to ensure timely receipt and successful load/submission.
  • Work cohesively with other members of the Data Solutions team to maintain data cleanliness and accuracy.
  • Lead and mentor team members and customers in best practices and techniques to implement and manage a successful Electronic Data Interchange system.
  • Develop and maintain system integration with HL7 and XML data exchange


Job Complexity:
Work on problems of diverse scope where analysis of data requires evaluation of identifiable factors. Demonstrate good judgment in selecting methods and techniques for obtaining solutions. Interact with senior internal and external personnel.

Qualifications

  • Advanced SQL Server with demonstrated capability using SSMS, SSIS, and other integration tools.
  • Data exchange (ETL) expertise
  • Experience working with EDI Healthcare standards (EDI 837, 834, 820, 278, HL7, Claims, Eligibility, Provider Network Management, CMS TRR, MMR, MOR, RAPS, EDPS)
  • Experience working with Healthcare Provider and Managed care data from a data profiling, analysis, and modeling perspective, with a solid understanding of the relevant Healthcare business processes.
  • Excellent analytic and problem solving capabilities.
  • Good organizational, interpersonal and team skills.
  • Attention to detail.
  • Good written and verbal communication skills.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed