Bring your heart to CVS Health. Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand — with heart at its center — our purpose sends a personal message that how we deliver our services is just as important as what we deliver.
Our Heart At Work Behaviors™ support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable.
This is a full time, hybrid position.
Position Summary
The Trade Finance Data Analyst is part of a small team that is responsible for design, implementation, and support of the trade finance data model. This role will be assisting with data migration, quality control and governance activities. You will play a crucial role in designing and building of a centralized data mart by combining several existing data sources. This allows the opportunity to support and work alongside the Commercial, Medicare Part D, Specialty, and ZINC Health Services Trade Relations teams.
Key role aspects include:
- Analyze, interpret, understand, and/or triage complex data and reporting requests
- Conduct data quality review and issue root cause analysis and resolution
- Design, test, implement and maintain ETL procedures, that support large volumes of data.
- Collaborate with technical and non-technical audiences to ensure strong data quality
- Supporting Management in the development and maintenance of ad-hoc reporting and analysis
- Providing analytic support to the Trade Relations, Underwriting Analytics, and Formulary departments
- The candidate should have a strong passion for data integrity with an eye for detail, but also be in tune with the big picture.
- Maintaining various Industry Analysis data and data sources
- Automation of existing processes to drive analytic quality and efficiencies
This individual will interact with various departments, members of management, and internal stakeholders. A small amount of travel may be required.
Required Qualifications
- 6 months+ experience in writing and troubleshooting SQL queries
- 6 months+ experience working with multiple RDBMS database platforms such as Oracle, Teradata, and DB2
- 1+ years’ in MS Excel
Preferred Qualifications
- Prior experience in the PBM, Pharmacy, or Healthcare industry
- 1+ years’ experience working with ETL tools and Data Languages. (I.e. Python, SAS, R, VBA, Alteryx, SSIS )
- 1+ years’ Advanced SQL techniques and Functions
- Knowledge of Power BI, Tableau development
- Ability to manage multiple ongoing tasks, projects and deadlines
- Experience with organizing, visualizing, presenting, and migrating large data sets.
- Experience in financial modeling, underwriting or analytics
- Excellent analytic skills
- Ability to dissect large data sets
- Problem solving skills
- Good communications skills
Education
Bachelor's Degree or equivalent work experience.
A bachelor’s degree in a technical or analytic field is preferred.
Business Overview
At CVS Health, we are joined in a common purpose: helping people on their path to better health. We are working to transform health care through innovations that make quality care more accessible, easier to use, less expensive and patient-focused. Working together and organizing around the individual, we are pioneering a new approach to total health that puts people at the heart.
We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion based on race, ethnicity, sex/gender, sexual orientation, gender identity or expression, age, disability or protected veteran status or on any other basis or characteristic prohibited by applicable federal, state, or local law. We proudly support and encourage people with military experience (active, veterans, reservists and National Guard) as well as military spouses to apply for CVS Health job opportunities.
Pay Range
The typical pay range for this role is:
$40,600.00 – $87,500.00
This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.
In addition to your compensation, enjoy the rewards of an organization that puts our heart into caring for our colleagues and our communities. The Company offers a full range of medical, dental, and vision benefits. Eligible employees may enroll in the Company’s 401(k) retirement savings plan, and an Employee Stock Purchase Plan is also available for eligible employees. The Company provides a fully-paid term life insurance plan to eligible employees, and short-term and long term disability benefits. CVS Health also offers numerous well-being programs, education assistance, free development courses, a CVS store discount, and discount programs with participating partners. As for time off, Company employees enjoy Paid Time Off (“PTO”) or vacation pay, as well as paid holidays throughout the calendar year. Number of paid holidays, sick time and other time off are provided consistent with relevant state law and Company policies.
For more detailed information on available benefits, please visit jobs.CVSHealth.com/benefits
CVS Health requires certain colleagues to be fully vaccinated against COVID-19 (including any booster shots if required), where allowable under the law, unless they are approved for a reasonable accommodation based on disability, medical condition, religious belief, or other legally recognized reasons that prevents them from being vaccinated.
You are required to have received at least one COVID-19 shot prior to your first day of employment and to provide proof of your vaccination status or apply for a reasonable accommodation within the first 10 days of your employment. Please note that in some states and roles, you may be required to provide proof of full vaccination or an approved reasonable accommodation before you can begin to actively work.
CVS Health is committed to recruiting, hiring, developing, advancing, and retaining individuals with disabilities. As such, we strive to provide equal access to the benefits and privileges of employment, including the provision of a reasonable accommodation to perform essential job functions. CVS Health can provide a request for a reasonable accommodation, including a qualified interpreter, written information in other formats, translation or other services through ColleagueRelations@CVSHealth.com If you have a speech or hearing disability, please call 7-1-1 to utilize Telecommunications Relay Services (TRS). We will make every effort to respond to your request within 48 business hours and do everything we can to work towards a solution.