Data Engineer – Pharmacy Data & SQL Server
South America · Central America · United…Data and AIPosted November 6, 2026
Open to people in the United States and BrazilApply for this job Write my CV for this job Early access
- Pay
- Not stated
- Required
- SQL Server, T-SQL, SQL Server Always On Availability Groups, SFTP, Medi-Span, NCPDP, NDC, NPI
- Nice to have
- Python
- Posted
- November 6, 2026
- Company
- Chiri
Who it can hire
We read the post for each of the 21 countries we cover.
Open to people in the US and Brazil
The employer lists this job as remote there: “South America · Central America · United States”.
Not open to people in the other 19 countries we cover, as far as the post says.
The job post
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.First Monday isn’t the employer or a recruiter and isn’t affiliated with Chiri. Details may have changed since; confirm with the employer before you apply.