Lead the design, development, and implementation of robust, scalable software solutions for the healthcare domain, ensuring alignment with business goals and technical requirements
Architect and develop ETL solutions using SSIS (SQL Server Integration Services) and Azure Data Factory to support data movement and transformation
Develop and maintain efficient, optimized SQL queries and scripts; collaborate with other team members to ensure seamless database interactions
Analyze and optimize SQL performance, leveraging advanced techniques such as SQL Profiler and SQL Execution Plans to identify bottlenecks and improve query performance
Develop and maintain healthcare reporting systems using SQL Server Reporting Services (SSRS) to provide accurate and actionable insights
Collaborate closely with cross-functional teams including data architects, business analysts, and stakeholders to ensure data flows and business logic are correctly implemented
Provide mentorship to junior and mid-level engineers, helping them to grow in their technical skills and develop best practices
Stay up to date with the latest trends and technologies in the software development and healthcare industries, ensuring the team is using the most effective tools and practices
Participate in code reviews, ensuring high code quality and adherence to software engineering best practices
Requirements
12+ years of proven experience in software engineering
Proficient in EHR based workflows pertaining to Revenue Cycle Management
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
Familiarity with Medicaid and Medicare services, including regulatory requirements and payer-specific implementations
Ability to interpret and troubleshoot EDI files, ensuring compliance with HIPAA standards and payer-specific guidelines
Enterprise-class software architectural experience with a solid understanding of considerations of scale, support, and implementation
Experience with Microsoft tech stack hosted on Azure desired
Expertise in ETL processes, including hands-on experience with SSIS (SQL Server Integration Services) and Azure Data Factory
Deep working knowledge of SQL Server, including database design, optimization, and advanced SQL scripting
Strong understanding of SQL performance tuning, including experience with SQL Profiler and analyzing SQL Execution Plans
Experience in developing reports using SQL Server Reporting Services (SSRS) to deliver accurate business intelligence
Exposure to ASP.Net, C#.Net, and JQUERY with the ability to develop, enhance, and maintain web-based applications and services
Strong analytical and problem-solving skills, with the ability to quickly troubleshoot and resolve complex technical issues
Strong knowledge of software engineering best practices and methodologies, including agile development, continuous integration and deployment, and software testing
Excellent communication and collaboration skills, with the ability to work cross-functionally with product management, UX, and other teams
Benefits
Health insurance
Retirement plans
Paid time off
Flexible work arrangements
Professional development
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
ETLSSISAzure Data FactorySQLSQL Server Reporting ServicesSQL performance tuningASP.NetC#.NetJQUERYEHR workflows