PostgreSQL Database Administrator and Business Analyst

Summary

Join Encoda's Data Operations team as a hybrid PostgreSQL Database Administrator and Business Analyst. This role blends database schema management with data transformation workflows, requiring expertise in practice management systems' financial data structures. You will work with ETL pipelines, API integrations, and the internal EDI transaction engine, ensuring clean and timely financial data transmission across various systems. Responsibilities include administering and optimizing PostgreSQL schemas, designing data mappings, leading data ingestion processes, overseeing API-based writebacks, and serving as a subject matter expert on PMS financial data flows. You will also monitor ETL pipelines, participate in architecture discussions, and collaborate with internal and external teams. This is a high-impact, 100% remote role crucial to data quality and client success.

Requirements

• 5+ years’ experience working directly with financial and scheduling data from medical practice management systems
• Strong understanding of the common financial data domains (charges, payments, adjustments, appointments, encounters, insurance mapping, medical practice financial reporting)
• Expertise in PostgreSQL database administration, including performance tuning, index optimization, and schema management
• Proven success building and troubleshooting complex ETL workflows across diverse systems using Python and SQL languages
• Experience with REST APIs for system integration (especially PMS or EHR APIs)
• Excellent analytical skills and attention to detail
• Bachelor’s degree in Computer Science, Information Systems, Healthcare IT, or related field (or equivalent experience)

Responsibilities

• Administer and optimize PostgreSQL schemas, indexes, and performance related to our central data warehouse
• Own the design and maintenance of data mappings and transformations between vendor systems and our unified schema while the practice management system remains the “system of record”
• Lead data ingestion processes from external practice management systems (PMS) into our financial and appointment data warehouse
• Oversee API-based writebacks from our EDI engine to source systems (both real-time and batch)
• Serve as the subject-matter expert on PMS financial data flows including payments, adjustments, charges, appointments, and claim activity
• Monitor ETL pipelines for failures, anomalies, or data quality issues and drive remediation
• Participate in architecture discussions around schema evolution and data pipeline improvements
• Collaborate with internal engineers, data analysts, client success teams, and third-party vendors

Preferred Qualifications

Experience with bash scripting, cron jobs, and job orchestration tools is a plus

Benefits

• Our associates work 100% remotely
• We offer a comprehensive benefit package, paid time off, medical and dental, matching 401k, and life insurance