Posted: 11-May-23
Location: TEMECULA, California
Type: Full Time
Salary: $65,000-$75,000
Required Education:
This organization participates in E-Verify.
Position Summary
Under the Supervision of the PM Team, provide analysis and financial information related to Manufacturer Admin Fees (ADFI) to successfully support the company’s goals and objectives. The analyst will work with people at all levels and departments of the organization to create reports, analyze data and monitor and manage key financial analytics related admin fees in (ADFI). In addition, manage the CVM program, assist with new product and new vendor set up and other administrative duties as assigned.
Essential Functions and Duties
- Support Product Management in the creation, tracking, validation, and analysis of manufacturer contract fees.
- Decipher manufacturer contracts and enter all fees, special programs, rebates, and incentives into Vistex with validation from Product Management and Finance.
- Maintain FFS Spreadsheet in TEAMS making all required updates within 48 hours of receipt of a contract change.
- Validate FDA licensing and provide changes to Sr. VP Product Management.
- Run monthly sales and purchasing reports for use in analysis of fees.
- Develop, maintain and coordinate the automated reports sent weekly/monthly/quarterly to suppliers, including sales reports, inventory reports, etc.
- Monitor actual monthly results of financial data analysis against settlement report from SAP/Vistex and documentation from Supplier. Initiate and prepare monthly variance reports. Highlight, research, analyze and document variances and work with PM Team and Supplier to correct.
- Create dashboards showing fees by manufacturer, effectiveness of collection, ranking of manufacturer based on total fees and payment accuracy, timeliness of payments, etc.
- Maintain ADFO spreadsheet ensuring accurate ADFO is loaded for each product.
- Enter ADFO into SAP based on GPO agreements. Analyze ADFO reporting on a monthly basis.for accuracy of admin fee payments to suppliers. Make updates and ensure payments are processing correctly.
- Create Dashboards showing fee payments to GPO over time with comparison by GPO.
- Upon request, create profitability reports using established TEMPLATE.
- Develop tracking spreadsheet for each manufacturer to log monthly expected vs actual fees received. Work with PM Team and Finance to correct data and collect any unpaid fees from suppliers.
- Coordinate the CVM process with upload of monthly allocation files, monitoring CVM email for change requests, validating and performing changes per established procedures.
- Analyze sales data for establishment of CVM allocation values with approval from the Product Manager.
- Work with FFF IT Department to create required reporting to ensure accuracy and efficiency.
- Manage the CVM Mailbox ensuring all emails are answered within 2 hours.
- Review all FSA adjustments and track for payment from Supplier if required.
- Coordinate receipt of all required forms and information for set up of a new vendor and/or new item.
- Continuously strive to improve processes, service quality to internal and external customers.
- Work to identify and implement efficiencies through process improvements and/or systems enhancements. Assist with testing of new SAP programs as required.
- Adheres specifically to all company policies and procedures, Federal and State regulations and laws.
- Display dedication to position responsibilities and achieve assigned goals and objectives.
- Represent the Company in a professional manner and appearance at all times.
- Understand and internalize the Company’s purpose; Display loyalty to the Company and its organizational values.
- Display enthusiasm and dedication to learning how to be more effective on the job and share knowledge with others.
- Work effectively with co-workers, internal and external customers and others by sharing ideas in a constructive and positive manner; listen to and objectively consider ideas and suggestions from others; keep commitments; keep others informed of work progress, timetables, and issues; address problems and issues constructively to find mutually acceptable and practical business solutions; address others by name, title, or other respectful identifier, and; respect the diversity of our work force in actions, words, and deeds.
- Comply with the policies and procedures stated in the Injury and Illness Prevention Program by always working in a safe manner and immediately reporting any injury, safety hazard, or program violation.
- Ensure conduct is consistent with all Compliance Program Policies and procedures when engaging in any activity on behalf of the company. Immediately report any concerns or violations.
- Other duties as assigned, including Ad Hoc Reports.
Education, Knowledge, Skills and Experience
Required Education:
- High school diploma or equivalent.
Required Knowledge:
- Advanced knowledge in Microsoft Office Suite with expertise in Excel, including V Lookup and Pivot Tables
Required Experience:
- Intermediate to Expert level Excel required
Preferred Experience:
- Experience within a wholesale/distributor company preferred. Prior experience in a company that distributed medical products is preferred. Experience in Finance, Marketing, or Materials Management is desirable.
- Experience with SAP is a plus.
- Experience within the healthcare or pharmaceutical industry is a major plus.
Required Skills:
- Strong interpersonal skills; Excellent verbal and written communication skills, including the ability to communicate with all levels of management
- Excellent analytical skills; Understanding of the company’s business
- Detail-oriented; Solid analytical, quantitative and organizational skills
- Ability to prioritize work; Self-starter, Team player; Function with a high degree of independence
- Advanced knowledge in Microsoft Office Suite with expertise in Excel, including V Lookup and Pivot Tables
- Strong understanding of integrated ERP system - SAP
Physical requirements
Vision, hearing, speech, movements requiring the use of wrists, hands and/or fingers. Must have the ability to view a computer screen for long periods and the ability to sit for extended periods. Must have the ability to work the hours and days required to complete the essential functions of the position, as scheduled. The employee occasionally lifts up to 20 lbs. and occasionally kneels and bends. Working condition include normal office setting.
Mental Demands
Learning, thinking, concentration and the ability to work under pressure, particularly during busy times. Must be able to pay close attention to detail and be able to work as a member of a team to ensure excellent customer service. Must have the ability to interact effectively with co-workers and customers, and exercise self-control and diplomacy in customer and employee relations’ situations. Must have the ability to exercise discretion as well as appropriate judgments when necessary. Must be proactive in finding solutions.
Direct Reports
None
EEO/AAP Statement
FFF Enterprises/ NuFactor is an equal opportunity employer to all and prohibits discrimination and harassment based on the following characteristics: race, color, caste, religion, religious creed (including religious dress and grooming practices), national origin, ancestry, citizenship, physical or mental disability, medical condition (including cancer and genetic conditions), genetic information, marital status, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), gender, gender identity, gender expression, age (40 years and over), sexual orientation, veteran or military status, medical leave or other types of protected leave (requesting or approved for leave under the Family and Medical Leave Act or any state protected leaves), domestic violence victim status, political affiliation, reproductive health decision-making, and any other characteristic protected by state or federal anti-discrimination law covering employment. These categories are defined according to Government Code section 12920. The Company prohibits unlawful discrimination based on the perception that anyone has any of those characteristics or is associated with a person who has or is perceived as having any of those characteristics.