ICM Data Consultant (Varicent) – Remote

Capgemini; Colombia; Hybrid; COP 120,000,000 - 180,000,000; Full time

Benefits offered by this job

Private Health Insurance

Paid Time Off

Flexible work arrangements

Job summary

Capgemini, acting as the Employer of Record for Farmers operations, seeks an experienced ICM Data Consultant to administer and optimize the Varicent Incentive Compensation platform. You will ensure accurate commissions, dashboards, and audits while collaborating with Sales Leadership, Finance, and IT to deliver timely results.

The role emphasizes technical rigor, data integrity, and SOX alignment, with remote/office-based flexibility in a global environment.

Qualifications

• 7+ years in IT application development, operations support, or similar roles.
• Experience with mainframe programs.
• Experience with ICM (Varicent or SSIS).
• Ability to manage multiple concurrent assignments.
• Excellent oral and written communication.

Responsibilities

• Ensure Commission Calculation and Reporting apps run efficiently.
• Plan data loads with timeliness and accuracy.
• Lead incident analysis and resolution.
• Document root causes and lessons learned.
• Collaborate with stakeholders to translate requirements into solutions.
• Support deployment activities and troubleshoot environments.
• Suggest enhancements to increase efficiency.
• Build and maintain Varicent calculation logic, formulas, and dashboards.
• Translate yearly sales incentive plans into technical requirements.

Skills

Communication

Detail oriented

Problem solving

Strong documentation

Eager to learn

Tools

Varicent

SSIS

SSRS

Job description

Capgemini, acting as the Employer of Record for Farmers operations, seeks an experienced ICM Data Consultant to administer and optimize the Varicent Incentive Compensation platform. You will ensure accurate commissions, dashboards, and audits while collaborating with Sales Leadership, Finance, and IT to deliver timely results.

The role emphasizes technical rigor, data integrity, and SOX alignment, with remote/office-based flexibility in a global environment.