Principal Software Engineer

Job Description
About Streamline:
Streamline's 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.

Current Opening
We are seeking an experienced and highly skilled Senior Principal Software Engineer to join our team. This is a senior-level position focused on building innovative solutions for the healthcare industry, leveraging a wide array of technologies and frameworks. If you have a deep understanding of ETL processes, strong SQL Server expertise, and a passion for working on high-impact, complex healthcare data systems, we would love to hear from you.

Key Responsibilities

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

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

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.

Streamline Healthcare Solutions is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin, or any other characteristic protected under federal, state, or applicable local law.