HireFT
Browse JobsHow it worksPricingSuccess Stories
    Back to jobs
    CH

    Chiri

    Software Engineering

    Data Engineer - Pharmacy Data & SQL Server

    Any, ANYRemoteFull-timePosted 1w ago
    All Chiri jobs

    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.

    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.

    Job details are sourced from the employer's original posting.

    Open job posting
    CH

    About the company

    Chiri

    Chiri is a company focused on developing scalable technical solutions and optimizing application performance, reliability, and maintainability. They emphasize writing clean, maintainable, and well-tested code, and contribute to engineering best practices through code reviews and architecture discussions.

    View all Chiri jobs
    Industry
    Software Engineering
    Open roles
    11

    Interested in this role?

    Apply with HireFT

    Free to start — no card required.

    Your fit

    How well do you match?

    Sign in to see how your résumé lines up with this role.