- South America
Build and operate reliable data pipelines for a new healthcare and pharmacy‑finance platform.
Responsibilities
- 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 from the ground up to track ingestion, data freshness, failures, integrity, completeness, and processing performance
Requirements
- Nice to have: pharmacy rebate processing
- Nice to have: PBMs
- Nice to have: TPAs
- Nice to have: manufacturer reporting
- Nice to have: Python-based data engineering