What are the responsibilities and job description for the Excel VLOOKUP, Pivot Tables and Data Expert (Sales/Finance/Logistics) - Korean Bilingual position at Makonis?
Position Summary
The Contractor will provide operational and analytical support for commercial contracts, pricing execution, and logistics operations under the guidance of the Sr. Director, Pricing and Contracting. This role focuses on enhancing team operational efficiency through accurate data processing and meticulous execution of tactical tasks.
Key Roles and Responsibilities
- Contract & Pricing Support
Maintain and update the Commercial Pricing Master File to ensure all approved prices are accurately reflected in internal systems.
Support the drafting and administrative review of commercial contracts, including organizing supporting exhibits and pricing addendums.
- GTN (Gross-to-Net) support
Consolidate monthly/quarterly raw data for rebates and chargebacks from multiple stakeholders for financial accuracy.
Conduct primary data validation using Excel functions to flag outliers or calculation errors before final settlement.
- Operational Reporting & Data Management
Aggregate sales and pricing data to generate standardized weekly/monthly performance reports for management review.
Manage and improve Excel-based tracking tools to streamline data consolidation and enhance reporting accuracy.
- Tactical Execution & Departmental Coordination
Follow up on specific action items from internal meetings and ensure all administrative deliverables are completed on schedule.
Liaise with relevant departments (Finance, Sales, Supply Chain, etc.) to gather necessary data for urgent pricing or logistics inquiries.
Work Experience
- 1–3 years of experience in Pharma/Biotech or related fields (Sales Support, Finance, Logistics).
- Experience in data-heavy administrative tasks and contract support.
Qualifications
- Advanced Excel Skills (Required): Proficiency in VLOOKUP, Pivot Tables, and data organization.
- Meticulousness: Strong attention to detail in data entry and document review.
- Communication: Ability to clearly understand requests and coordinate effectively with relevant departments.
- Bilingual, Korean preferred.
Education
Bachelor’s Degree required in business or related field; advanced degrees, MBA, MS in business or related field is a plus.
Core Competencies
- Analytical Rigor: Ability to process and validate large datasets with high accuracy using advanced Excel skills.
- Operational Excellence: Strong attention to detail in managing contract documentation and meeting strict deadlines.
- Collaborative Mindset: Effective communication skills to coordinate seamlessly with Finance, Sales, and Logistics teams.
- Adaptability: A flexible approach to supporting diverse tactical tasks within a fast-paced commercial environment.