Sales & Commercial Operations Analyst

The Ricky Joy Company; Colombia; Remote; COP 35,545,000 - 42,575,000; Full time

Benefits offered by this job

Birthday off

Permanent contract

100% remote

Equipment provided

Health insurance

Funeral allowance

Connectivity allowance

Wellness program

Ricky Joy Academy

Partnership discounts

Career advancement

Job summary

The Ricky Joy Company is seeking a Sales & Commercial Operations Analyst in Colombia with 2+ years in sales analytics. This 100% remote role supports the Sales team, ERP/CRM data integrity, and cross-functional coordination from Colombia, reporting to the National Sales Manager.

Responsibilities include preparing sales reports, dashboards, and KPI tracking; managing orders and customer data; and coordinating travel and events for the team. Requires advanced Excel and English proficiency.

Qualifications

• Bachelor's degree in Business Administration, Marketing, Industrial Engineering, Economics, Finance, International Business, or a related field.
• Minimum of 2 years of experience in sales analysis, commercial operations, sales administration, or a related analytical role.
• Experience preparing sales reports, analyzing commercial data, and tracking KPIs.
• Experience coordinating administrative activities, expenses, travel arrangements, or commercial events is desirable.

Responsibilities

• Analyze sales performance and prepare commercial reports.
• Develop dashboards and KPI reports to support decision-making.
• Coordinate orders, customer data, and ERP/CRM records.
• Support travel, expenses, and event logistics for the sales team.
• Collaborate with cross-functional teams to improve reporting and processes.

Skills

Advanced Excel

Strong English

Analytical thinking

Education

Bachelor's degree in Business/Marketing/Engineering/Economics/Finance/IB

Tools

NetSuite ERP

HubSpot CRM

Salesforce CRM

Zoho CRM

Power BI

Job description

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