
Data Engineer - Pharmacy Data & SQL Server at Chiri (South, United States)
Chiri· South, United States·
Role details
Job description
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.
Why work at Chiri
- Culture: Described as ambitious, with a focus on shaping the future of Human+AI teams. The company emphasizes a "Sherpa" mentality—carrying the weight for clients and not leaving them at base camp.
- Remote/Hybrid Policy: Hybrid workspace; employees engage in a combination of remote and on-site work. Typical on-site time is not specified but roles are listed as remote across 18-20 locations.
- Notable Perks/Engineering Culture: Engineers own features end-to-end and work directly with clients to deliver measurable business outcomes. Roles emphasize backend focus, API design, AI-powered features, and collaboration across product and client teams. Open roles include Full Stack, Mobile (iOS/Flutter), QA, and Data Platform engineers.