Data Engineer (MSSQL, EDI-US Healthcare)

About Streamline:

Streamlines mission is to build innovative technological solutions that empower people who improve behavioral health and quality of life of those in need. We are a high growth technology company that delivers web-based software for healthcare organizations to provide and coordinate all service delivery processes. Streamline has been offering software in the behavioral health marketplace since 2003. Streamline has built and maintains systems for some of the premier behavioral health organizations in United States of America, using the latest web-based technology.

Required Skills and Experience:

• Proven experience (12+ years) in software engineering, with a strong focus on the healthcare domain and healthcare data systems.
• Proficient in EHR based workflows pertaining to Revenue Cycle Management.

• Strong working knowledge of X12 EDI transactions like Payment posting (manual and electronic remittances - 835), Client Fee setup, Retroactive charge reallocation, Electronic Eligibility verification (270/271), Accounts Receivable/GL Reporting etc.

• 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.
• 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.

Preferred Qualifications:

• Experience in cloud-based healthcare solutions (Azure, AWS, etc.) is a plus.
• Familiarity with HIPAA regulations and healthcare data security requirements.
• Experience with Scrum methodologies and related tools.