Microsoft SQL Server Engineer
Core
Design, build, and optimize Microsoft SQL Server database infrastructure, including stored procedures, SSIS packages, and automated jobs to process healthcare claims data.
Role type
Senior IC database engineer (SQL Server/ETL)
Builds
Production data pipelines and stored procedures supporting Elixir-based healthcare applications
Domain
Healthcare technology / Claims processing
Required skills
T-SQL, SQL query optimization, SSIS package development, SQL Server Agent job management, ANSI 837 standard parsing (HCFA/UB formats), data modeling, ETL processes, data security and compliance
Preferred skills
Elixir backend integration, EDI transaction sets (835, 834), healthcare payer/clearinghouse environment experience, high-volume claims data ingestion design
Technologies
Microsoft SQL Server, SSIS, SQL Server Agent, GitLab, Elixir
Responsibilities
Design and maintain complex T-SQL stored procedures; Parse, validate, and process ANSI 837 healthcare claim data; Develop and maintain SQL Server Agent jobs and SSIS packages for automated data workflows; Ensure database security and compliance; Troubleshoot database issues and perform root-cause analysis; Document database processes; Implement strategies for database scalability
Seniority
Senior, hands-on IC