Associate, Data Engineer

AffirmedRx is on a mission to improve health care outcomes by bringing clarity, integrity, and trust to pharmacy benefit management. We are committed to making pharmacy benefits easy to understand, straightforward to access and always in the best interest of employers and the lives they impact. We accomplish this by bringing total clarity to business practices, leading with clinical approaches, and utilizing state-of-the-art technology. Join us in improving health care outcomes for all! We promise to do what’s right, always. Position Summary: The Associate, Data Engineer is responsible for maintaining the reliability and performance of AffirmedRx’s Snowflake data warehouse and upstream data ingestion pipelines. This hands-on role supports daily operations by monitoring file ingestion, data movement, transformation processes, scheduled loads, and troubleshooting data-related issues. The position also assists in expanding and enhancing the data warehouse through new tables, dbt models, automation, monitoring, and other development initiatives under the guidance of the Data Warehouse Manager. As a designated backup to the Senior Data Warehouse Engineer, the role helps ensure continuity of critical warehouse operations and reduces key-person dependency. Over time, the engineer will build technical expertise and assume greater ownership of data warehouse processes and solutions. What you will do: Warehouse and Pipeline Operations: 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 Backup and Continuity: 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 Warehouse Build and Enhancement: 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 Validation, Documentation, and Collaboration: 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 What you need: 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…