SQL Developer - Healthcare Domain

About the role

The SQL Developer - Healthcare Domain Lead II - Software Engineering position at UST is seeking an experienced professional with a strong background in the healthcare domain. The role involves developing, maintaining, and optimizing complex T-SQL queries, designing and deploying reports using SQL Server Reporting Services (SSRS), building and maintaining ETL packages using SQL Server Integration Services (SSIS), and ensuring data integrity, consistency, and performance across systems and reports.

Responsibilities

• Develop, maintain, and optimize complex T-SQL queries, stored procedures, views, and functions.
• Design and deploy reports using SQL Server Reporting Services (SSRS).
• Build and maintain ETL packages using SQL Server Integration Services (SSIS).
• Use SQL Server Management Studio (SSMS) and Visual Studio for database development and troubleshooting.
• Ensure data integrity, consistency, and performance across systems and reports.
• Collaborate with stakeholders to gather reporting requirements and translate them into technical specifications.
• Troubleshoot data-related issues and ensure accuracy of healthcare data processing.

Requirements

• 8+ to 10+ years of hands-on experience as a SQL Developer.
• Proficiency in SSRS, SSMS, SSIS, and Visual Studio.
• Strong experience with T-SQL and relational database concepts.
• Background in the healthcare domain, including understanding of claims, eligibility, or provider data.
• Familiarity with HIPAA regulations and handling of PHI data.
• Strong analytical, problem-solving, and communication skills.

Preferred Qualifications

• Experience with performance tuning and query optimization.
• Exposure to healthcare data standards such as EDI (e.g., 837, 835), HL7, or FHIR.
• Familiarity with Azure SQL, Power BI, or other reporting tools.
• Experience working in Agile/Scrum environments.
• Understanding of data warehousing and data marts.

Benefits

• Paid vacation, sick leave, and holidays.
• Participation in the Company’s 401(k) Retirement Plan with employer matching.
• Medical, dental, and vision insurance.
• Short- and long-term disability benefits.
• Health Savings Account (HSA) and Flexible Spending Account (FSA).