Associate Data Engineer

🕒 il y a 9 jours

Postuler Maintenant

Trouver des Emplois à Distance Similaires

Configurer une alerte email pour les nouveaux emplois

📊 Vérifiez votre score de CV pour ce poste

Améliorez vos chances d'obtenir un entretien en vérifiant votre score de CV avant de postuler.

Télécharger le CV

AffirmedRx, a Public Benefit Corporation

Site WebLinkedInTous les Emplois

11 - 50 employés

🏥 Santé

⚕️ Assurance santé

Healthcare • Healthcare Insurance

AffirmedRx est une Société d’intérêt public dédiée à la transformation de l'industrie de la gestion des avantages pharmaceutiques (PBM). Axée sur la transparence, les soins centrés sur le patient et des solutions innovantes, AffirmedRx vise à surmonter les complexités et l'opacité qui frappent traditionnellement le secteur du PBM. En autonomisant les individus et les organisations, la société offre une clarté et un soutien inébranlable pour naviguer dans les avantages pharmaceutiques. AffirmedRx incarne l'intégrité et le partenariat, s'efforçant d'offrir une expérience de gestion des avantages pharmaceutiques plus saine et mieux informée tout en s'attaquant audacieusement aux coûts croissants des soins de santé et des médicaments.

Description

• Monitor daily Snowflake loads, file ingestion, and scheduled jobs; confirm expected files arrive, land correctly, and process without error • Operate and maintain drop-zone / upload-zone, data-lake, and SFTP file movement (e.g., Couchdrop, Azure Data Factory, service-account–based moves); triage failures and rejected files • Respond to file, load, and data-quality issues in a timely, well-documented way; escalate and coordinate with data engineering, pre-processing, and IT as needed • Maintain and act on file-level monitoring and alerting — “expected vs. received” tracking, format/validation alerts, and hold-folder sweeps • Serve as trained backup for core data-warehouse operations so critical pipelines and client 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 client 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 • Develop and maintain crawlers, file validators, and file-rejection rules; help automate manual file downloads and uploads into the warehouse • Assist with Snowflake administration tasks — role and grant management, MFA/security SOP adherence, storage-account configuration, clone and backup routines — following established security standards • QA loaded data and reconcile discrepancies across source systems before release; support data-accuracy checks and audits • Maintain clear documentation: pipelines, data sources, schedules, SOPs, and runbooks (including dev-to-production process) • Partner with data engineering, pre-processing, analytics, and IT/security to gather requirements and hand work into production

🎯 Exigences

• 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 cloud data warehouse platforms, preferably Snowflake • Working SQL skills and familiarity with a cloud data warehouse (Snowflake 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; able to follow runbooks and escalate appropriately • Willingness to participate in a shared support/backup rotation for time-sensitive loads and deliverables • Exposure to dbt, Python for data work, Azure (Data Factory, storage/data lake), or Couchdrop-style file automation • Familiarity with data modeling, data vault, or warehouse monitoring and alerting • Healthcare, pharmacy benefit management (PBM), or claims/eligibility data exposure, and awareness of PHI/HIPAA handling • Familiarity with pharmacy data concepts (NDC, eligibility, accumulators, formulary) is a plus • Fully remote; reliable internet and a suitable home work environment • Occasional off-hours support may be required for time-sensitive loads, client files, or incident response • Willingness and ability to travel (10%-20%)

🏖️ Avantages

• Competitive compensation, including health, dental, vision and other benefits