Position: Sales & Commercial Operations Analyst
Location: Colombia, 100% Remote
Department: Sales
Reports to: National Sales Manager
Contract Type: Indefinite-term contract, direct with the company
Schedule: Monday to Thursday 7am – 4:30pm, Friday 7am – 4pm (Schedule adapted to our headquarters in Cumming, GA)
Salary: $ 3,500,000 COP
Job Summary:
The Sales & Commercial Operations Analyst is responsible for analyzing sales performance, preparing commercial reports, monitoring key performance indicators (KPIs), managing customer and distributor information, and coordinating administrative and operational processes that support the Sales team.
This role combines data analysis, business intelligence, order management, customer follow-up, expense control, and commercial coordination to improve operational efficiency and support data-driven decision-making.
The ideal candidate is analytical, proactive, highly organized, and detail-oriented, with advanced Excel skills, strong English communication skills, and experience working with ERP and CRM platforms. The candidate must be comfortable working with sales data, coordinating cross-functional activities, and identifying opportunities for process improvement.
Responsibilities:
Sales Analysis & Business Intelligence
Prepare daily, weekly, and monthly sales reports using ERP systems, Excel, and other reporting tools.
Analyze sales performance by customer, territory, distributor, product line, and sales representative.
Develop and maintain sales dashboards, KPI reports, and performance-tracking tools to support commercial decision-making.
Monitor sales trends, forecasts, inventory movement, order performance, and commercial results.
Identify discrepancies, risks, opportunities, and areas for improvement through data analysis.
Support sales forecasting, budgeting, and commercial planning activities.
Track progress against sales targets and provide accurate, timely information to the Sales team.
Implement corrective actions and recommend process improvements based on analytical findings.
Order & Customer Management
Record and monitor customer orders in the ERP system according to established procedures and commercial requirements.
Maintain accurate and updated customer, distributor, pricing, and sales information in CRM and ERP platforms.
Track customer requests, commercial commitments, order status, and pending follow-up activities.
Coordinate with Sales, Marketing, Operations, Finance, and Customer Service to ensure proper communication and timely execution of commercial activities.
Process and follow up on sales-related complaints, claims, and suggestions, coordinating with the appropriate departments to support resolution.
Monitor customer satisfaction and help ensure that commercial requests are addressed in a timely manner.
Support the preparation of business reviews, customer meetings, and commercial presentations.
Commercial Operations & Coordination
Provide administrative and analytical support to the National Sales Manager in daily commercial operations and sales-related activities.
Prepare sales reports, KPI dashboards, presentations, and performance summaries to support commercial decision-making.
Coordinate commercial meetings, prepare relevant documentation, and follow up on action items, commitments, and deadlines.
Monitor sales targets, customer requests, order status, and pending commercial activities.
Coordinate communication between the National Sales Manager, sales representatives, distributors, customers, and internal departments.
Support the organization of business reviews, customer visits, trade shows, and commercial events.
Coordinate travel arrangements for the Sales team, including flights, accommodations, transportation, and vehicle rentals.
Track commercial expenses, follow up on supplier invoices, and submit expense reports to the Finance department.
Maintain accurate and organized commercial records, customer information, reports, and supporting documentation.
Identify opportunities to improve sales reporting, administrative workflows, and commercial processes.
Travel, Events & Expense Management
Coordinate travel arrangements for the Sales team, including flights, accommodations, transportation, and vehicle rentals.
Support the organization and logistical preparation of trade shows, events, customer visits, and commercial meetings in the United States.
Record and monitor travel and commercial expenses, ensuring proper documentation and accurate expense tracking.
Follow up on supplier invoices and coordinate with the Finance department to ensure timely processing.
Prepare and submit expense reports to Finance in accordance with company procedures.
Maintain organized records of travel arrangements, expenses, invoices, and supporting documentation.
Reporting & Cross-Functional Collaboration
Provide accurate and timely commercial information to the National Sales Manager and relevant stakeholders.
Ensure consistency and accuracy across sales reports, CRM records, ERP transactions, and supporting documentation.
Identify opportunities to improve reporting processes, data quality, and operational workflows.
Collaborate with internal teams to support commercial objectives and business priorities.
Handle confidential commercial and customer information with discretion and professionalism.
Requirements:
Education & Experience
Bachelor's degree in Business Administration, Marketing, Industrial Engineering, Economics, Finance, International Business, or a related field.
Minimum of 2 year of experience in sales analysis, commercial operations, sales administration, or a related analytical role.
Demonstrated experience preparing sales reports, analyzing commercial data, and tracking KPIs.
Experience with order management, customer databases, commercial documentation, or sales operations.
Experience coordinating administrative activities, expenses, travel arrangements, or commercial events is desirable.
Technical Skills
Advanced Excel skills are mandatory, including data analysis, reporting, and management of large datasets.
Proficiency in Microsoft Office applications.
Experience using ERP systems; NetSuite is preferred.
Experience using CRM platforms such as HubSpot, Salesforce, Zoho, or similar systems.
Knowledge of sales KPIs, commercial reporting, forecasting, and performance tracking.
Experience with Power BI or other data visualization tools is a plus.
Familiarity with inventory tracking, order management, and distributor or retailer operations is desirable.
Languages
Intermediate to advanced English proficiency, with strong written and verbal communication skills. A B2+ level or higher is preferred.
Core Competencies
Strong analytical and problem-solving skills.
Excellent organizational skills and attention to detail.
Ability to manage multiple tasks, priorities, and deadlines.
Clear, professional, and effective communication.
Proactive approach to identifying issues and implementing improvements.
Strong teamwork and cross-functional collaboration skills.
High level of accuracy, accountability, and confidentiality.
Adaptability and willingness to learn new systems and processes.
Compensation and Benefits:
Birthday off
Permanent contract
100% remote work
We provide the equipment
Essential health insurance
Funeral allowance
Connectivity allowance
Access to the Support Team: our internal wellness program
Ricky Joy Academy: internal professional development
Discount package with corporate partnerships (gym, online courses, hotels, etc.)
Opportunities for advancement within the company
Bachelor's degree in business, marketing, industrial engineering, economics, finance, or related field; 2+ years sales analysis or commercial operations experience; advanced Excel; ERP and CRM experience; intermediate to advanced English (B2+ preferred).
Key Responsibilities
- analyzing sales performance
- preparing commercial reports
- coordinating commercial operations
Skills & Tools
Microsoft Excel, Microsoft Office, NetSuite, HubSpot, Salesforce, Zoho, Power BI
Job Details
- Category: Business Operations
- Seniority: Entry Level
- Commitment: Full Time, Contract
- Workplace: Remote — Colombia
- Languages: English
Benefits
- Generous paid time off
About Ricky Joy Company
A family-owned business creating innovative snacks and beverages, distributing to over 10,000 stores. — Industry: Retail and Wholesale