[Hiring] SQL Database Engineer @CorroHealth

Role Description

The Database Engineering team owns the data infrastructure behind CorroHealth's Utilization Management (UM) and Clinical Documentation Improvement (CDI) lines of business. That includes the ETL pipelines, integrations, and databases that every downstream analytics product depends on. As a Database Engineer, you'll build and support mission-critical pipelines processing data on sometimes rapid frequencies. You'll work with operations and clinical stakeholders to turn business needs into reliable, well-documented data solutions. You'll report to the Director of Database Development & Operations and join a small team of experienced engineers. This is a remote position.

Essential Duties and 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.

Qualifications

• 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

Nice to Have

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

Benefits

• Quality of life with a remote predictable, full-time schedule
• Competitive Salary commensurate to experience
• Medical, Dental, Vision coverage and more
• Long-term disability insurance, and life insurance
• Ample parental leave
• 401K with company match
• Certification and Tuition Reimbursement
• Holidays, Flexible Time Off

Physical Demands

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions as described. Regular eye-hand coordination and manual dexterity is required to operate office equipment. The ability to perform work at a computer terminal for 6-8 hours a day and function in an environment with constant interruptions is required. At times, Team Members are subject to sitting for prolonged periods. Infrequently, Team Member must be able to lift and move material weighing up to 20 lbs. Team Member may experience elevated levels of stress during periods of increased activity and with work entailing multiple deadlines.