SQL Database Engineer, Healthcare Platform (Perm. Work Status Req'd)

CorroHealth hires a Database Engineer to build and support the data infrastructure behind its Utilization Management and Clinical Documentation Improvement businesses. The role develops and maintains ETL pipelines, integrations, databases, and reporting while supporting data quality, performance, HIPAA compliance, and production operations.

Responsibilities:

• Build and maintain ETL pipelines: design, build and support data pipelines using T-SQL stored procedures, PowerShell and Python, orchestrated through JAMS and SQL Agent
• Work on integrations: develop and support bidirectional Salesforce ↔ SQL Server sync (Relational Junction, DBAmp) and secure file-based integrations (SFTP / GoAnywhere MFT) with clients and partners
• Design databases: create and evolve schemas, views, stored procedures and indexing strategies that scale with the business
• Tune performance: diagnose and fix slow queries and jobs using execution plans, Query Store, wait statistics and index analysis
• Ensure data quality: build validation and reconciliation checks so data stays accurate from source to report. Investigate and resolve discrepancies when they come up
• Build reporting: develop and maintain SSRS reports and Power BI datasets that support operations and decision-making
• Protect PHI: build solutions that meet HIPAA requirements, including least-privilege access, secure transfer and auditability
• Support production: monitor scheduled jobs, troubleshoot failures and drive root-cause fixes. Take part in on-call rotation for after-hours monitoring of critical jobs
• Follow engineering practices: use source control (Azure DevOps Git repositories), take part in code review, and follow change-management processes for production deployments
• Document your work: write and maintain technical documentation and runbooks, and help capture undocumented process knowledge
• Collaborate: work with operations leaders, analysts and clinical teams to clarify requirements and explain technical tradeoffs in plain language

Requirements:

• Permanent Work Status Required (USC or GC)
• 3+ years of hands-on T-SQL development on Microsoft SQL Server
• Strong command of stored procedures, query tuning, indexing and data modeling
• Experience building and supporting production ETL processes, including scheduling, error handling and restartability
• Scripting experience in PowerShell and/or Python for automation and integration
• Experience working with healthcare data and an understanding of HIPAA obligations for PHI
• Experience with SSRS and/or Power BI
• Comfort with source control and working in a code-review culture
• Bachelor's degree in Computer Science, Information Systems or a related field, or equivalent practical experience
• Utilization management, clinical review, CDI, claims, denials or appeals data
• Salesforce data integration (DBAmp, Relational Junction or similar)
• JAMS or another enterprise job scheduler
• Azure data services
• Managed file transfer (GoAnywhere or similar)