ETL Developer

ApolloMed (NASDAQ: AMEH) is a physician-centric, technology-powered healthcare management company. We are building and operating a novel, integrated, value-based healthcare delivery platform to empower our physicians to provide the highest quality of end-to-end care for their patients in a cost-effective manner. Our mission is to combine our clinical experience, best-in-class delivery network, and technological expertise in order to improve patient outcomes, increase access to healthcare, and make the US healthcare system more efficient.

With over a million managed lives across the country and terabytes of data generated, our software and applications need to be cutting-edge, efficient, and aligned with our core values of improving patient outcomes and empowering our providers.

We are looking for a full-time EDI/ETL Developer to join our fast-growing team (based in Los Angeles or remote).

You are:

• Comfortable with ambiguity and biased towards action. You can identify the 20% of the work that leads to 80% of the result and constantly execute at a high level. You enjoy thinking about complex and ambiguous problems and can consistently deliver compounding value
• Relentlessly resourceful. You enjoy taking ownership and can motivate others to get things done. You are resilient, detail-oriented, and truly believe that no task is beneath you
• Growth-oriented. You are able to evaluate all perspectives, even if uncomfortable, and have the courage to adjust your views if necessary. You have the expertise and communication skills to balance a growth mindset with a bias towards action
• Mission-driven. You are excited by the prospect of diving into complex problems that will drastically improve patient outcomes, while lowering the cost of a tremendously inefficient US healthcare system, where waste is over 40% and per-capita healthcare dollars spent is double that of other developed nations

What you’ll do:

• Facilitate and support electronic data transfers (inbound claims processing and outbound encounter submissions)
• Conduct data analysis, needs assessment, and cost/benefit determination to align EDI strategies with the goals of the organization
• Write P&Ps, manuals, and other technical EDI documentation
• Experience writing complex SQL queries
• Implement performance analysis to promote high quality EDI processes and optimize acceptance rates, volumes, timeliness, and overall execution efficiency
• Analyzes, designs, codes, tests, and implements application enhancements, as well as provides general production support, meets defined scope, target dates, and budgets with minimal or no defects.
• Implement and support data automation, healthcare EDI applications and application integrations
• Perform detailed functional and quality unit-level testing to ensure requirements are met
• Assist in or oversee implementation and maintenance of EDIFECS systems as required
• Complete user acceptance testing and production business validation testing for assigned projects
• Support relationships with internal and external clients
• Assist with IPA and health plan meetings pertaining to claims and encounter data as required
• Perform ad hoc duties, projects, and actions as needed

The opportunity:

• Join a team critical to operations with extremely high visibility
• Startup-like mentality and career trajectory in a recently IPO’d company
• Create and develop systems and documents that promote efficient and high-quality processes, enabling effective communication within the organization and with clients

Qualifications:

• Bachelor’s degree or equivalent software development or IT training from an accredited institution
• Minimum 6 Years of Experience in MS SQL SSIS/ETL
• A minimum of four years of health plan, IPA, or MSO experience recommended
• 4 Years of .NET(C#) development experience including cross platform communication technologies such as Web API or WCF
• Knowledge of health plan operations around membership, claims, and encounter data processing
• Expertise with HIPAA transaction standards and encounter data landscape, specifically 834, 835, 837P, 837I, 837D, 277,999, and TA1
• Proficiency with Microsoft Office (Word, Excel, PowerPoint)
• Proven ability to prioritize and organize multiple responsibilities simultaneously in a fast paced, changing environment while meeting deadlines and turnaround time requirements
• Excellent communication and documentation skills with the ability to creatively solve problems