Encoda is a revenue cycle company that has developed innovative solutions to simplify complexities in medical reimbursements using technology, automation, and data.
The company offers a cloud-based (SaaS) claims and denials management platform that bridges workflow gaps between Practice Management Systems, clearinghouses, and payers.
The role of PostgreSQL Database Administrator and Business Analyst involves responsibilities in database schema management and data transformation workflows.
The ideal candidate should have experience with practice management systems' financial data structures and understand the importance of normalized, unified data for interoperability.
Responsibilities include administering and optimizing PostgreSQL schemas, designing and maintaining data mappings, leading data ingestion processes, overseeing API-based writebacks, and serving as a subject-matter expert on PMS financial data flows.
The candidate will monitor ETL pipelines, participate in architecture discussions, and collaborate with internal teams and third-party vendors.
The position requires 5+ years of experience with financial and scheduling data from medical practice management systems and expertise in PostgreSQL database administration.
Requirements:
Candidates must have 5+ years of experience working directly with financial and scheduling data from medical practice management systems.
A strong understanding of common financial data domains such as charges, payments, adjustments, appointments, encounters, insurance mapping, and medical practice financial reporting is required.
Expertise in PostgreSQL database administration, including performance tuning, index optimization, and schema management, is essential.
Proven success in building and troubleshooting complex ETL workflows using Python and SQL is necessary.
Experience with REST APIs for system integration, particularly with PMS or EHR APIs, is required.
Excellent analytical skills and attention to detail are mandatory.
Experience with bash scripting, cron jobs, and job orchestration tools is a plus.
A Bachelor’s degree in Computer Science, Information Systems, Healthcare IT, or a related field (or equivalent experience) is required.
Benefits:
The position offers a comprehensive benefits package, including paid time off, medical and dental insurance, matching 401k, and life insurance.
Employees have the opportunity to work 100% remotely.
The role is high-impact and central to the company's data quality and client success strategy.
Employees will be part of a leading technical team with a strong mission, core values, and a supportive and inclusive culture.
