Associate Data Engineer

Stack

Responsibilities

• ▹Monitor daily Snowflake loads, file ingestion, and scheduled jobs
• ▹Operate drop-zone/upload-zone, data lake, and SFTP file movement (e.g. Couchdrop, Azure Data Factory), triage failures
• ▹Respond to file, load, and data-quality issues in a timely, well-documented way
• ▹Serve as a trained backup for core data warehouse operations to ensure continuity
• ▹Build and maintain tables, views, and dbt models under guidance
• ▹Develop crawlers, file validators, and rejection rules, automate manual file operations
• ▹QA loaded data and reconcile discrepancies across source systems
• ▹Maintain documentation: pipelines, data sources, schedules, SOPs, runbooks

Soft skills

About the company

AffirmedRx is on a mission to improve health care outcomes by bringing clarity, integrity, and trust to pharmacy benefit management, making pharmacy benefits easy to understand and access for employers and the people they serve.