FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in SQL Server performance tuning, data ingestion pipeline design, and data quality frameworks, with a strong focus on pharmacy claims and industry identifiers. Proficient in building operational dashboards and monitoring systems to ensure data integrity and compliance with regulatory standards.
Highest-signal resume keywords
SQL Server Performance TuningData Ingestion Pipeline DesignPharmacy Claims ExperienceT-SQL DevelopmentData Quality Frameworks
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQL ServerT-SQLData IngestionETL/ELT PipelinesExecution Plan AnalysisQuery OptimizationData ValidationReconciliationMonitoringData Freshness
Tools & Technologies
SFTPFlat-File DropsOperational DashboardsAlertsObservability
Industry Keywords
Medi-SpanNCPDPNDCNPIPBMsTPAsHIPAAPHIRebate ProcessingHigh-Volume Batch Pipelines
Tech Stack
Tools & technologiesETLPythonSQL
About the role
Key responsibilities & impact- Work with Medi-Span, NCPDP, NDCs, NPIs, and related pharmacy claims and reference datasets
- Design and build secure ingestion pipelines using SFTP, structured flat-file drops, and third-party data feeds
- Optimize SQL Server performance, analyze execution plans, improve query efficiency, and manage indexed/materialized view strategies
- Work with SQL Server Always On Availability Groups and reliable database operations
- Implement validation rules, constraints, reconciliation, deduplication, schema monitoring, and exception handling for incoming third-party data
- Build monitoring to track ingestion, data freshness, failures, integrity, completeness, and processing performance
Requirements
What you’ll need- Hands-on experience with pharmacy claims, reference data, and industry identifiers, including 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: Experience with pharmacy rebate processing, PBMs, TPAs, or manufacturer reporting
- Preferred: Experience with Python-based data engineering and automation
- Preferred: Experience handling PHI and HIPAA-regulated data
- Preferred: Experience integrating high-volume batch pipelines with near-real-time applications
- Preferred: Experience with on-call rotations and availability
Benefits
Comp & perks- The opportunity to build the data foundation of a new platform where accuracy, reliability, and performance directly affect business outcomes.