At CVS Health, the business problem is to ensure that data received from external parties are successfully ingested and available for processing in the transactional system, while also ensuring that file extracts for external business partners are produced and delivered on the agreed upon schedule.
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-Sharp is nice to have
- Healthcare industry experience.
- 340B experience
- Performance tuning processes and T-SQL
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.
Other
- Bachelor’s degree in Computer Science, Data Analytics or Information Technology or equivalent work experience.
- 40 Anticipated Weekly Hours
- Full time
- Travel requirements not mentioned
- No clearance requirements mentioned
