Data Engineer - Pharmacy Data & SQL Server

About Chiri Chiri collapses fragmented software into one governed operating layer for mid-sized businesses: companies with valuable workflows and real urgency, but no internal AI organization to take a use case to production. We combine our platform with forward-deployed expertise to connect customers' existing systems, build what they need, and operate it in production. Increasingly, buyers are asking ChatGPT, Perplexity, Gemini, Claude, and other AI systems what they should use. Chiri must be one of their top answers. Role Overview We're looking for an experienced Data Engineer with strong pharmacy data knowledge to build and operate reliable data pipelines for a new healthcare and pharmacy-finance platform. This role combines pharmacy data expertise, SQL Server performance engineering, high availability, third-party data integration, and end-to-end pipeline observability. You'll work with complex claims, eligibility, formulary, reference, and manufacturer reporting data that support critical business decisions. Key Responsibilities Pharmacy Data Integration: Work with Medi-Span, NCPDP, NDCs, NPIs, and related pharmacy claims and reference datasets. Data Pipelines: Design and build secure ingestion pipelines using SFTP, structured flat-file drops, and third-party data feeds. SQL Server Engineering: Optimize SQL Server performance, analyze execution plans, improve query efficiency, and manage indexed/materialized view strategies. High Availability: Work with SQL Server Always On Availability Groups and reliable database operations. Data Quality: Implement validation rules, constraints, reconciliation, deduplication, schema monitoring, and exception handling for incoming third-party data. Pipeline Observability: Build monitoring from the ground up to track ingestion, data freshness, failures, integrity, completeness, and processing performance. Required Skills and Experience Hands-on experience with pharmacy claims, reference data, and industry identifiers, including but not limited to Medi-Span, NCPDP, NDC, and NPI. Strong SQL Server and T-SQL development experience. Experience with SQL Server Always On Availability Groups. Advanced SQL performance tuning, execution-plan analysis, indexing, and query optimization. Experience building reliable SFTP-based and flat-file ETL/ELT pipelines. Experience designing data quality frameworks, validation constraints, and monitoring for third-party feeds. Experience building operational dashboards, alerts, and observability for data pipelines. Strong understanding of data lineage, reconciliation, security, and production support. Preferred Qualifications Experience with pharmacy rebate processing, PBMs, TPAs, or manufacturer reporting. Experience with Python-based data engineering and automation. Experience handling PHI and HIPAA-regulated data. Experience integrating high-volume batch pipelines with near-real-time applications. Experience with on-call rotations and availability. What We Offer The opportunity to build the data foundation of a new platform where accuracy, reliability, and performance directly affect business outcomes.