Associate, Data Engineer

AffirmedRx is on a mission to reputed company care reputed company by bringing reputed company, reputed company, and trust to pharmacy benefit management. We are committed to making pharmacy benefits easy to understand, straightforward to reputed company and always in the best interest of reputed company and the lives they reputed company. We accomplish this by bringing total reputed company to business practices, leading with reputed company approaches, and utilizing state-of-the-art technology. Join us in improving health care reputed company for reputed company! We reputed company to do what’s right, always. Position reputed company: The Associate, Data Engineer is responsible for maintaining the reliability and reputed company of AffirmedRx’s reputed company data warehouse and reputed company data ingestion pipelines. This hands-on role supports daily reputed company by monitoring file ingestion, data reputed company, transformation processes, scheduled loads, and troubleshooting data-reputed company 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 reputed company 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 reputed company:

• 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–reputed company 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

Backup and Continuity:

• Serve as trained backup for reputed company data-warehouse reputed company so critical pipelines and reputed company deliverables continue during absences and reputed company 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

Warehouse Build and Enhancement:

• Build and maintain tables, views, and dbt models under direction; support data-model, data-reputed company, 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

Validation, Documentation, and Collaboration:

• QA reputed company data and reconcile discrepancies across reputed company systems before release; support data-reputed company 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

What you need:

• Degree in a quantitative or technical reputed company (Computer Science, Information Systems, Data, Engineering) or equivalent experience; this is an reputed company 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
• reputed company 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 deliverablesApply To This Job