Sales & Commercial Operations Analyst

Ricky Joy Company; Colombia; Remote; COP 35.545.000 - 42.575.000; Vollzeit

Benefits dieser Stelle

Birthday off

Equipment provided

Connectivity allowance

Support Team wellness program

Zusammenfassung

Ricky Joy Company is seeking a Sales & Commercial Operations Analyst in Colombia, fully remote. You will analyze sales data, prepare commercial reports, and monitor KPIs to support the Sales team.

The role requires advanced Excel, ERP/CRM experience, and strong English communication. Responsibilities include generating reports, dashboards, coordinating with departments, managing orders, and assisting with budgeting and forecasting.

Qualifikationen

• Bachelor's degree or related field is required.
• Minimum 2 years of experience in sales analysis or commercial operations.
• Advanced Excel skills are mandatory.
• Strong English communication skills are required.

Aufgaben

• Prepare daily, weekly, and monthly sales reports using ERP and Excel.
• Analyze sales performance by customer, territory, distributor, and product line.
• Develop and maintain sales dashboards and KPI reports.
• Coordinate cross-functional activities to support commercial decisions.
• Record and monitor customer orders in ERP and CRM systems.
• Monitor sales targets and provide timely updates to the Sales team.
• Support travel arrangements and commercial events as needed.

Kenntnisse

Advanced Excel

English proficiency

Data analysis

Cross-functional collaboration

Ausbildung

Bachelor's degree in Business Administration, Marketing, Industrial Engineering, Economics, Finance, International Business, or related field

Tools

NetSuite

HubSpot

Salesforce

Zoho

Jobbeschreibung

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

We provide the equipment

Connectivity allowance

Access to the Support Team: our internal wellness program

Discount package with corporate partnerships (gym, online courses, hotels, etc.)

Opportunities for advancement within the company