Associate, Data Engineer
Summary
Build and maintain Snowflake data pipelines, dbt models, and file ingestion for a healthcare PBM platform, ensuring data quality and security compliance.
Responsibilities
- Monitor daily Snowflake loads, file ingestion, and scheduled jobs to ensure data processes run without error
- Operate and maintain data-lake, SFTP file movement, and Azure Data Factory pipelines
- Triage failures, rejected files, and data-quality issues in a timely and documented manner
- Build and maintain tables, views, and dbt models under the guidance of the Data Warehouse Manager
- Assist with Snowflake administration, including role management and security SOP adherence
- QA loaded data and reconcile discrepancies across source systems
- Maintain clear documentation for pipelines, data sources, schedules, and SOPs
Requirements
- Degree in a quantitative or technical field (Computer Science, Information Systems, Data, Engineering) or equivalent experience
- 1–3 years of experience working with SQL and cloud data warehouse platforms, preferably Snowflake
- Proficiency with SQL and familiarity with cloud data warehouses
- Experience with data files and pipelines (CSV, SFTP, encryption/PGP)
- Exposure to dbt, Python, or Azure Data Factory
- Familiarity with data modeling, data vault, or warehouse monitoring
- Knowledge of healthcare, PBM, or claims data and PHI/HIPAA handling
- Ability to travel 10%-20%
About the Company
AffirmedRx is on a mission to improve health care outcomes by bringing clarity, integrity, and trust to pharmacy benefit management through state-of-the-art technology.