Sales & Commercial Operations Analyst

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

Benefits offered by this job

Birthday off

Permanent contract

100% remote work

Equipment provided

Essential health insurance

Funeral allowance

Connectivity allowance

Ricky Joy Academy

Job summary

The Ricky Joy Company is hiring a Sales & Commercial Operations Analyst for a 100% remote role based in Colombia. The analyst will analyze sales performance, prepare commercial reports, monitor KPIs, and coordinate ERP/CRM activities to support the Sales team.

The ideal candidate will have advanced Excel skills, strong English communication, and experience with ERP/CRM platforms to drive data-driven decisions and process improvements.

Qualifications

• Bachelors degree in a related field and at least 2 years in sales analysis or commercial operations.
• Experience preparing sales reports, KPIs, and dashboards.
• Experience with ERP/CRM platforms and cross-functional coordination.

Responsibilities

• Prepare daily, weekly, and monthly sales reports using ERP systems and Excel.
• Develop sales dashboards and KPI reports to aid commercial decisions.
• Monitor orders, customer data, pricing, and distributor information in ERP/CRM.
• Coordinate with Sales, Marketing, Finance, Operations and Customer Service.

Skills

Advanced Excel

Analytical skills

English communication

Cross-functional collaboration

Education

Bachelor's degree in Business Administration or related field

Tools

NetSuite

CRM (HubSpot, Salesforce, Zoho)

Power BI

Microsoft Office

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