Leading the design, development and implementation of robust scalable software solutions ensuring alignment with business goals and technical requirements
Translating product requirements into system design and architecture using SSIS and Azure Data Factory
Analyzing and optimizing SQL performance, leveraging advanced techniques such as SQL Profiler and SQL Execution Plans to identify bottlenecks and improve query performance
Applying your knowledge of Medicaid and Medicare regulations to system logic and design
Diagnosing root cause issues and communicating findings clearly to internal stakeholders
Collaborating closely with cross-functional teams including data architects, business analysts, and stakeholders to ensure seamless database interactions
Providing mentorship to junior and mid-level engineers, developing their technical skills and best practices
Requirements
Bachelor's degree in computer science, information technology, or a related field, or equivalent combination of education and experience
10+ years of professional software engineering experience with a strong emphasis on healthcare systems and EHR workflows pertaining to Revenue Cycle Management
Mastery of SQL Server development, optimization and query analysis – SQL Profiler and Execution Plans
Strong working knowledge of X12 EDI transaction sets, with a particular focus on 837P/837I (Claims), 835 (Electronic Remittance), and 276/277 (Claim Status).
Experience with healthcare billing formats such as UB-04 and CMS-1500
Solid understanding of HIPAA, Medicaid, and Medicare regulatory environments and payer specific implementations – ability to troubleshoot EDI files
Proven track record building scalable ETL pipelines using SSIS and Azure Data Factory
Familiarity with Microsoft stack (ASP.Net, C#.Net, JQuery) and DevOps tools and practices
Strong knowledge of software engineering best practices and methodologies including agile development, continuous integration/deployment and software testing
Refined communication, analytical and documentation skills – you thrive in a team-oriented environment
Intellectual curiosity - a mind that's always thinking about the best, most efficient, and cost-effective way to grow
Outcome-focused, results-oriented mindset—you see challenges as opportunities and approach work with optimism.
Benefits
full suite of benefits
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQL ServerSSISAzure Data FactorySQL ProfilerSQL Execution PlansETL pipelinesX12 EDI837P837IHIPAA