Lyric is an AI-first, platform-based healthcare technology company, committed to simplifying the business of care by preventing inaccurate payments and reducing overall waste in the healthcare ecosystem, enabling more efficient use of resources to reduce the cost of care for payers, providers, and patients. Lyric, formerly ClaimsXten, is a market leader with 35 years of pre-pay editing expertise, dedicated teams, and top technology. Lyric is proud to be recognized as 2025 Best in KLAS for Pre-Payment Accuracy and Integrity and is HI-TRUST and SOC2 certified, and a recipient of the 2025 CandE Award for Candidate Experience. Interested in shaping the future of healthcare with AI? Explore opportunities at lyric.ai/careers and drive innovation with #YouToThePowerOfAI.
SQL Engineer & Azure
Job Summary
We are seeking a seasoned SQL Developer to lead the design, optimization, and modernization of our data infrastructure. This role is critical to supporting our large-scale, event-driven platform built on .NET and Azure. The ideal candidate will have deep expertise in SQL Server, Azure data services, Kafka, and Databricks, with a strong background in performance tuning, data migrations, and legacy system modernization.
Job Responsibilities
- Architect and maintain scalable, secure, and high-performance SQL Server databases for enterprise-grade applications
- Design and implement event-driven data pipelines using Kafka, Azure Event Hubs, and Databricks
- Lead data migration efforts to modernize implementations for High Availability.
- Collaborate with backend engineers to optimize data access patterns and ensure seamless integration with .NET services
- Perform advanced SQL performance tuning, indexing strategies, and query optimization. And other performance tuning techniques on the DB level and application level along with scaling strategies like sharding, partitioning, and replication
- Implement data ingestion from on-premises and cloud sources (APIs, flat files, relational DBs, etc.)
- Define and enforce data governance, security, and compliance standards
- Implement high availability, disaster recovery, and backup strategies
- Work with DevOps to automate database deployments and manage infrastructure as code
- Conduct capacity planning, monitoring, and troubleshooting of production environments
- Collaborate with business analysts, data architects, and stakeholders to define data integration strategies.
- Monitor, debug, and optimize ADF pipelines, triggers, and linked services.
- Create and maintain technical documentation for ETL/ADF processes.
- Mentor developers and DBAs on best practices for database design and usage
Required Qualifications
- 7–10 years of experience with Microsoft SQL Server, including SSIS, SSRS, and T-SQL
- Strong experience with Azure SQL, Azure Synapse, Azure Data Factory, and Databricks
- Hands-on experience with Kafka or similar event streaming platforms
- Proven track record in legacy system migrations and data modernization
- Deep understanding of database performance tuning, query optimization, and execution plans
- Experience with .NET-backed systems and integration with ORM tools like Entity Framework
- Or experience working closely with .NET teams to ensure optimal data access patterns
- Familiarity with CI/CD pipelines for database deployments (e.g., Azure DevOps, Flyway)
- Strong knowledge of data modeling, normalization, and schema design
- Excellent problem-solving skills and ability to work in cross-functional teams
- Experience with data warehousing concepts (star schema, snowflake schema, fact & dimension modeling).
- Strong background in performance tuning and debugging ETL/ADF processes.
- Familiarity with CI/CD pipelines for ADF using Git/DevOps.
- Solid understanding of data governance, security, and compliance standards.
Preferred Qualifications
- Experience with real-time analytics and stream processing using Databricks Structured Streaming
- Familiarity with feature flagging and configurable data-driven architectures
- Exposure to NoSQL databases like Cosmos DB, MongoDB, or Redis
- Knowledge of data observability tools like SQL Sentry, Redgate, or Grafana
- Contributions to technical blogs, whitepapers, or open-source projects
- Knowledge of Databricks, Azure Functions, or Logic Apps.
- Experience with Power BI or other BI tools for reporting integration.
- Exposure to Python, .NET, or other scripting languages for data orchestration.
Top Skills
What We Do
Welcome. Let us help bring your health plan's payment accuracy and savings into the next era of savings and cost reduction. Learn more by visiting Lyric.AI
Welcome to Lyric. Building on the legacy of ClaimsXten, we bring over 30 years of expertise to deliver unmatched savings—more than $14 billion annually—to our valued clients, including 9 of the top 10 health payers nationwide.
Our cutting-edge solutions streamline complex claims processes, ensuring precision and efficiency for over 185 million lives under our care. Recognized by KLAS for our partnership excellence and value, we lead with top customer satisfaction scores and an A+ recommendation rate.
Apart from our market-leading pre-pay claim editing services, Lyric is at the forefront of integrating advanced technologies to drive greater savings and administrative cost savings through the payment integrity value chain. This includes strategic partnerships with leaders in the areas of genetic testing claims accuracy, coordination of benefits, and more.
Whether you are a current valued customer or new to Lyric, we are investing in helping health plans simplify the business of care.
Visit us at Lyric.AI
