Electronic Data Interchange Developer

Company: Community Health Center Network
Location: San Leandro
Posted on: February 17, 2021

Job Description:

Organizational DescriptionThe Community Health Center Network (CHCN), sister organization to the Alameda Health Consortium, is made up of the eight federally qualified community health centers in Alameda County.--CHCN functions as the managed care MSO for our health centers, contracting with the Alameda Alliance for Health and Anthem Blue Cross.--In order to help our health centers meet their missions of providing the best possible care to their communities, we also provide a broad range of training, technical assistance, quality improvement, information technology, and data analytic services.Position Title: EDI Developer Department: Information Technology Reports To: Applications Development Manager Classification: Exempt Status: Full-Time TemporaryPOSITION SUMMARYThe EDI Application/Developer will program and monitor HIPAA EDI transactions using T-SQL and 3rd party applications and assist in developing web based applications using VB.NET and C Sharp.ESSENTIAL POSITION RESULTSThe essential functions listed are typical examples of work performed by positions in this job classification. They are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks and responsibilities. Employees may perform other duties as assigned.* Application Development/Programming using Microsoft T-SQL, SSIS, 3rd party systems of electronic data interchanges of HIPAA (e.g., extract, load, transformation (ETL) of ANSI x12 834, 837, 277, 278, 274, 270, 271) and Health Information Exchange (e.g. CCDA, HL7) systems.* Monitor MS SQL jobs to export/import files from MS SQL databases to data trading partners* Monitor and audit automated processes to exchange data with our trading partners - HMOs, health centers, clearing houses and providers.* Assist in the development and monitoring of a reporting mechanism to reconcile data exchanges.* Assist in design, development and procurement of new processes, system enhancements and upgrades.HIPAA Designated Access"For the purposes of the job duties of this position, the person in this position requires access only to the following HIPAA protected information data sets" 1. MSO Membership2. MSO Claims3. MSO Referral/Auth.4. MSO Capitation5. Data Warehouse6. Chart Audit/QI7. Disease RegistrySUPERVISORY RESPONSIBILITIESNone MINIMUM QUALIFICATIONSCompetencies * At least 2 years' experience as a data specialist in ETL/data exchange and SQL programmer on Microsoft SQL Server 2012 - 2019* Experience in design, development, and troubleshooting of ETL transactions, particularly with health care standard data sets (e.g., ANSI X12, 834, 837, 277, 278, 274, 270, 271 )* Highly skilled in SQL* Minimum of one year of experience in web application development using VB.NET or C Sharp* Proficiency with Microsoft Access and Microsoft Excel* Excellent communication and documentation skills* Preferred to have experience in health careCERTIFICATES AND/OR LICENSESBachelor's degree in computer related field or 2 years of related experiencePHYSICAL DEMANDS The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.While performing the duties of this Job, the employee is regularly required to sit and use hands to finger, handle, or feel. The employee is frequently required to talk or hear. The employee is frequently required to stand; walk; reach with hands and arms and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 15 pounds.--Specific vision abilities required by this job include close vision and ability to adjust focus.WORKING CONDITIONS AND ENVIRONMENTThe work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.While performing the duties of this job, the employee is regularly exposed to an inside environment.The Community Health Center Network is an Equal Opportunity Employer.

Keywords: Community Health Center Network, San Leandro , Electronic Data Interchange Developer, IT / Software / Systems , San Leandro, California