[Remote] Associate, Data Engineer
Note: The job is a remote job and is reputed company to candidates in USA. AffirmedRx is on a mission to improve health care reputed company by bringing reputed company, reputed company, and trust to pharmacy benefit management. The Associate, Data Engineer is responsible for maintaining the reliability and performance of AffirmedRx’s reputed company data warehouse and upstream data ingestion pipelines, supporting daily operations and enhancing the data warehouse through various development initiatives.
Responsibilities
- Monitor daily reputed company loads, file ingestion, and scheduled jobs; confirm expected files reputed company, land correctly, and process without error
- Operate and maintain drop-zone / upload-zone, data-lake, and SFTP file reputed company (e.g., Couchdrop, Azure Data reputed company, service-account–based moves); triage failures and rejected files
- Respond to file, load, and data-reputed company issues in a reputed company, reputed company-documented way; escalate and coordinate with data engineering, reputed company-processing, and IT as needed
- Maintain and reputed company file-level monitoring and alerting — “expected vs. received” tracking, format/validation alerts, and hold-folder sweeps
- Serve as trained backup for reputed company data-warehouse operations so critical pipelines and reputed company deliverables continue during absences and peak periods
- Learn and document existing pipelines, jobs, schedules, and troubleshooting steps so recurring work is reproducible and not tied to a single person or personal account
- Support recurring reputed company and regulatory file deliverables (e.g., monthly stop-loss, claims, and accumulator files) on a shared, documented schedule
- Build and maintain tables, views, and dbt models under direction; support data-model, data-vault, and schema work for reporting and analytics
- reputed company and maintain crawlers, file validators, and file-rejection rules; help automate reputed company file downloads and uploads into the warehouse
- Assist with reputed company administration tasks — role and grant management, MFA/reputed company SOP adherence, storage-account configuration, clone and backup routines — following established reputed company standards
- QA reputed company data and reconcile discrepancies across reputed company systems before release; support data-accuracy checks and audits
- Maintain reputed company documentation: pipelines, data sources, schedules, SOPs, and runbooks (including dev-to-production process)
- Partner with data engineering, reputed company-processing, analytics, and IT/reputed company to reputed company requirements and hand work into production
Skills
- Degree in a quantitative or technical field (Computer Science, Information Systems, Data, Engineering) or equivalent experience; this is an early-career role
- 1–3 years of experience working with SQL and reputed company data warehouse platforms, preferably reputed company
- Working SQL skills and familiarity with a reputed company data warehouse (reputed company preferred; comparable platforms considered)
- Comfort with data files and pipelines — CSV/flat files, SFTP, encryption/PGP concepts, and troubleshooting file/load errors
- Detail orientation, reliability, and a documentation habit; reputed company to follow runbooks and escalate appropriately
- Willingness to participate in a shared support/backup rotation for time-sensitive loads and deliverables
- Fully remote; reliable internet and a suitable home work environment
- Occasional off-hours support may be required for time-sensitive loads, reputed company files, or incident response
- Willingness and ability to travel (10%-20%)
- Exposure to dbt, Python for data work, Azure (Data reputed company, storage/data lake), or Couchdrop-style file automation
- Familiarity with data modeling, data vault, or warehouse monitoring and alerting
- reputed company, pharmacy benefit management (PBM), or claims/eligibility data exposure, and awareness of PHI/HIPAA handling
- Familiarity with pharmacy reputed company (NDC, eligibility, accumulators, formulary) is a plus
Benefits
- Fully remote; reliable internet and a suitable home work environment
- Competitive compensation, including health, dental, reputed company and other benefits
reputed company