Data Engineer
| Company | CVS Health |
|---|---|
| Location | California, USA, Jackson Township, NJ, USA |
| Salary | $79310 – $173040 |
| Type | Full-Time |
| Degrees | |
| Experience Level | Mid Level |
Requirements
- High proficiency with SQL/T-SQL, SSIS, and SSRS.
- Deep understanding of stored procedures, as well as T-SQL queries.
- Knowledge of data relationships, querying / processing data, and designing well-structured data flows.
- Experience with C# is nice to have.
Responsibilities
- Develop SSIS packages to extract, transform, and load (ETL) data from CVS Health pharmacy claims systems, 340B third-party administrator (TPA) platforms, Covered entity eligibility files, Drug inventory and pricing systems.
- Implement data validation rules within SSIS packages to ensure compliance with 340B program requirements (e.g., patient eligibility, drug utilization).
- Support incremental and full data loads to accommodate daily, weekly, and monthly data warehouse refresh cycles.
- Integrate data from disparate formats (e.g., CSV, XML, flat files, and relational databases) into a centralized SQL Server data warehouse.
- Ensure data quality through error checking and data validation using T-SQL and SSIS among other tools.
Preferred Qualifications
- Healthcare industry experience.
- 340B experience
- Performance tuning processes and T-SQL