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.

Our SCOUT Values

Our values are not wall art. They describe how we expect people to operate.

Seek to Understand

Assume you might be wrong. Clarity before action.

Call It Out

See something, say something. Say the hard thing.

Ownership Mentality

"That's not my job" does not exist.

Use Human Judgment

Judgment, context, and care come from us. AI is a tool.

Talk with Precision

Concise. Intentional.