Job Details

EDI & DATABASE PRODUCT ENGINEER

Palco is a visionary company pioneering an emerging health-care movement that empowers people with disabilities and those aging to live independent and quality lives. Made possible by our amazing team, Palco provides technology and financial services to aid individuals and their families to thrive in their home and communities. Partnered with government agencies and fortune 500 managed care organizations across the country, we are dedicated to creating exceptional outcomes for our clients and the millions of people that count on them. We are a highly organized company that offers a solid work/life balance, autonomy, generous paid time off, bonus potential, and career advancement opportunities. Our staff make long-lasting impact on the lives of people every day.

We are seeking a highly skilled EDI Data Engineer & Product Analyst to manage and optimize our ANSI X12-compliant billing system. This role requires a deep understanding of 837, 835, 276, 277, 270, 271, and 834 transactions, along with expertise in SQL Server and MySQL databases. You will be responsible for analyzing, modifying, and optimizing data processes, writing queries, and developing ETL scripts, while also serving as a key liaison between internal teams and payor EDI/MMIS/MCO teams. Additionally, you will gather requirements, translate them into technical specifications, and drive product enhancements, acting as both an engineer and a product strategist. This is a hands-on role that requires technical expertise, critical thinking, and strong communication skills to ensure seamless data flow, system efficiency, and compliance with payor requirements.

This is a hybrid technical and product-focused role, perfect for someone who thrives on solving complex data challenges while also shaping system improvements. If you are a detail-oriented, analytical thinker who enjoys both engineering and product strategy, we'd love to hear from you!

Key Responsibilities:

• EDI & Database Management
  • Maintain and optimize 837, 835, 277, 276, 270, 271, and 834 EDI transactions.
  • Write and execute SQL queries to extract, manipulate, and analyze data.
  • Modify database structures and manage SQL Server and MySQL environments.
  • Develop and maintain ETL scripts for data transformation and movement.
• Product & Process Optimization
  • Gather and analyze requirements from business and operational teams.
  • Translate business needs into technical specifications and efficient data processes.
  • Propose and implement streamlined, maintainable code that avoids unnecessary complexity.
  • Drive process improvements that enhance system functionality and reduce inefficiencies.
• Collaboration & Communication
  • Serve as the primary liaison with payor EDI teams, including MMIS and MCO representatives.
  • Work closely with internal billing, operations, and development teams to resolve data issues.
  • Clearly document system changes, workflows, and data specifications.

Qualifications & Experience:

• Strong knowledge of ANSI X12 transactions (837, 835, 277, 276, 270, 271, 834).
• 3-5 years of SQL experience. Expertise (SQL Server and MySQL), including query writing, database changes, and optimizations.
• Experience writing ETL scripts and handling large data sets.
• Ability to gather requirements, define specifications, and drive product improvements.
• Strong critical thinking and problem-solving skills.
• Experience working with healthcare, Medicaid, or managed care organizations, specifically with billing and payor systems.
• Excellent verbal and written communication skills, with the ability to collaborate across technical and non-technical teams.
• Familiarity with EDI file structures and payor system integrations.
• Knowledge of scripting languages (e.g., PowerBI, etc.) for automation.

Join Us

This position is remote/work-from-home role. Enjoy the convenience of working from home and maximize your time by unplugging at the end of your workday.

Company benefits designed for you:

• Generous Paid time off.
• Quarterly/Annual bonus potential.
• Retirement Savings: We will support you as you save for your future.
• Career Growth Opportunities: We help you thrive, so together, we can grow. We provide opportunities to advance your career with a vast portfolio of businesses and a global footprint.
• Paid Training: Earn while you learn, and continue to grow with access to internal and external learning opportunities.
• Great Work Environment: We are proud of our company culture of collaboration and the recognition we've received for our diversity efforts.

When you join Palco, you are engaged in creating the future - both our company's, the people we serve, and your own. We understand that our success is directly related to the success of our team. We strive to create a culture where you can:

• Bring your authentic self to work.
• Grow and thrive, both personally and professionally.
• Make a difference with our clients, in our communities, and with the millions of people we support.
• Experience work/life balance.
• Feel value and a greater purpose through the work you do.

Palco, Inc. is an Equal Employment Opportunity (EEO) employer and does not discriminate in any employer/employee relations based on race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.