Job Description
Job Description
As a Business Analysis - Sr Consultant, you will be providing database development, data analysis and data mining to help produce forecasts, monthly rebate accruals, and FP&A reporting requirements. You will assist in the extraction of information from multiple data warehouses, tables, and other sources and calculate complex rebate terms and contribute to creative solutions. This role is a blend of both a system and business analysis, mostly focusing on the technology and systems side, but also requires a broader understanding of the business needs and development.
In this role, you will support the formulary rebate business and will review and account for all rebates from drug manufacturers along with reviewing the rebates that can be passed along to clients. You will work to understand client commitments and track performance against them. Your experience in data systems and applications will allow you to directly impact the Company's P&L.
You will gain heavy insight into complex, varying contract terms and our data environment in order to be able to accurately calculate and report the financial position of rebates and analyze variances and driver. By utilizing your expertise in Microsoft Excel, Microsoft Access and SQL, you will perform data mining activities using large data sets. Knowledge of Visual Basic is a plus.
The Rebates FP&A team is an exciting fast-paced environment where every single day is rarely the same as the previous. We highly value excellent customer service and aim to provide accurate and timely information. Our team is responsible for budgeting, forecasting, and accounting for all formulary rebates for CVS Health. The Rebate FP&A teams reports and analysis are critical to the companys success, guiding decisions and driving results.
This position will be located in Scottsdale, AZ.
Position duties & responsibilities:
- Manage complex databases to assist in the manipulation of large data sets.
- Provide variance analysis to understand potential risk and opportunities with respect to financial results
- Ability to automate workbooks and databases using SQL, Access, or VBA
- Complete ad-hoc reporting and analysis to support broader finance group as needed.
- Work with business partners to frame the financial impact and communicate up through financial organization.
Required Qualifications
- 2 or more years of professional experience in Financial Planning & Analysis or Analytic role(s)
- 2 or more years using Microsoft Access, or other SQL applications to extract and summarize data from large data warehouses.
- 2 or more years experience using Microsoft Excel to prepare reports.
Preferred Qualifications
- Experience with Visual Basic, SAP, Tableau, Teradata, Toad, or SQL Server
- Experience using business analytics to solve data-driven questions.
- Experience working in a large corporate environment
- Self-starter, goal- oriented, ability to manage multiple assignments with strict deadlines
Education
Bachelor's Degree required.
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.
As a Business Analysis - Sr Consultant, you will be providing database development, data analysis and data mining to help produce forecasts, monthly rebate accruals, and FP&A reporting requirements. You will assist in the extraction of information from multiple data warehouses, tables, and other sources and calculate complex rebate terms and contribute to creative solutions. This role is a blend of both a system and business analysis, mostly focusing on the technology and systems side, but also requires a broader understanding of the business needs and development.
In this role, you will support the formulary rebate business and will review and account for all rebates from drug manufacturers along with reviewing the rebates that can be passed along to clients. You will work to understand client commitments and track performance against them. Your experience in data systems and applications will allow you to directly impact the Company's P&L.
You will gain heavy insight into complex, varying contract terms and our data environment in order to be able to accurately calculate and report the financial position of rebates and analyze variances and driver. By utilizing your expertise in Microsoft Excel, Microsoft Access and SQL, you will perform data mining activities using large data sets. Knowledge of Visual Basic is a plus.
The Rebates FP&A team is an exciting fast-paced environment where every single day is rarely the same as the previous. We highly value excellent customer service and aim to provide accurate and timely information. Our team is responsible for budgeting, forecasting, and accounting for all formulary rebates for CVS Health. The Rebate FP&A teams reports and analysis are critical to the companys success, guiding decisions and driving results.
This position will be located in Scottsdale, AZ.
Position duties & responsibilities:
- Manage complex databases to assist in the manipulation of large data sets.
- Provide variance analysis to understand potential risk and opportunities with respect to financial results
- Ability to automate workbooks and databases using SQL, Access, or VBA
- Complete ad-hoc reporting and analysis to support broader finance group as needed.
- Work with business partners to frame the financial impact and communicate up through financial organization.
Required Qualifications
- 2 or more years of professional experience in Financial Planning & Analysis or Analytic role(s)
- 2 or more years using Microsoft Access, or other SQL applications to extract and summarize data from large data warehouses.
- 2 or more years experience using Microsoft Excel to prepare reports.
Preferred Qualifications
- Experience with Visual Basic, SAP, Tableau, Teradata, Toad, or SQL Server
- Experience using business analytics to solve data-driven questions.
- Experience working in a large corporate environment
- Self-starter, goal- oriented, ability to manage multiple assignments with strict deadlines
Education
Bachelor's Degree required.
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.
52355767