Partnership HealthPlan of California

SQL/EDI Developer

Job Locations US-CA-Fairfield
Job ID
FLSA Status
Hiring Range
$ 91,163.24 - $ 118,514.23


To assist in developing and maintaining HIPAA compliant ANSI X12 EDI healthcare transactions for PHC. Responsibilities include programming the federal and/or state mandated transactions and other EDI applications using tools & technologies such as EDI Translators, Microsoft SSIS/SSRS package solutions, Microsoft Transaction SQL blocks and Oracle PL/SQL.


  • Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all EDI applications.
  • Implement the data models required by the EDI application development team and provide optimal design solutions to improve system quality and efficiency.
  • Understand business requirements and accordingly develop database solutions for EDI application development team.
  • Browse, create, edit, and delete schema objects on Oracle and Microsoft SQL database servers.
  • Write server-side Oracle PL/SQL and MS SQL server Transaction SQL blocks, edit and debug SQL program units on Oracle and SQL Servers.
  • Develop SSIS/SSRS packages and ETL solutions to meet business needs
  • Recommend system enhancements and modifications to improve performance efficiency.
  • Maintain in-depth knowledge on HIPAA EDI 5010 TR3 technical specifications and the current HIPAA EDI rules from both technical and user perspectives.
  • Provide training and assistance to less experienced staffs as needed.
  • Create and maintain documentation for all projects and participate in team meetings, conferences and problem solving discussions.



  • Perform other assigned or needed activities required to assure success of the EDI development role and to support other work of the IT Department.


Education and Experience

Bachelor’s degree in Computer Science, Business or a related field preferred.   Five years of experience in Information Systems. Two to five years of experience in health care. Demonstrated experience with large, highly complex projects.



Special Skills, Licenses and Certifications

Strong experience in SQL - with an understanding of relational databases, including advanced query writing, table creation and manipulation, query optimization, and code debugging. At least 3 years of experience with Database Development with Oracle, SQL Server 2005 and/or 2008. Advanced SQL experience in relational database DDL, DML, Transact SQL, PL/SQL / stored procedures, SSIS / SSRS, data modeling and SQL optimization. Experience with EDI and knowledge of translators is preferred. Experience with .NET technologies such as VB.NET, ASP.NET, ADO.NET is a plus. Certification on either the Microsoft or Oracle platform is plus. Detail oriented.  Knowledge of health care coding systems. Writing and verbal ability important.




Performance Based Competencies

Ability to quickly acquire in-depth knowledge of AMYSIS software and managed care issues.  Strong written and oral communication skills with ability to interpret and understand technical requirements. Excellent analytical skills to troubleshoot and resolve systems problems.



Work Environment And Physical Demands

More than 50% of work time is spent at a video display terminal. May be required to bend, stoop, kneel, crawl, or work in other non-standing and non-sitting positions to install cabling, systems hardware and other related equipment.




All Healthplan employees are expected to:


  • Provide a high level of service to clients;
  • Promote teamwork and cooperative effort among employees;
  • Maintain safe practices; and
  • Abide by the Healthplan’s policies and procedures as they may from time to time be updated.



$ 91,163.24 - $ 118,514.23




The job duties, elements, responsibilities, skills, functions, experience, educational factors and the requirements and conditions listed in this job description are representative only and not exhaustive of the tasks that an employee may be required to perform.  The employer reserves the right to revise this job description at any time and to require employees to perform other tasks as circumstances or conditions of its business, competitive considerations, or work environment change.


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