FBS ICM Data Consultant

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

FBS - Farmer Business Services is part of Farmers operations with the purpose of building a global approach to identifying, recruiting, hiring, and retaining top talent. By combining international reach with US expertise, we build diverse and high-performing teams that are equipped to thrive in today's competitive marketplace.

We believe that the foundation of every successful business lies in having the right people with the right skills. That is where we come in—helping Farmers build a winning team that delivers consistent and sustainable results.

Since we don't have a local legal entity, we've partnered with Capgemini, which acts as the Employer of Record. Capgemini is responsible for managing local payroll and benefits.

What to expect on your journey with us:

• A solid and innovative company with a strong market presence
• A dynamic, diverse, and multicultural work environment
• Leaders with deep market knowledge and strategic vision
• Continuous learning and development

We are seeking a skilled and detail-oriented ICM Data Consultant to own the administration, configuration, and daily operations of our Varicent Incentive Compensation Management platform. In this role, you will bridge the gap between sales strategy and technical execution, ensuring that sales commissions, bonuses, and performance metrics are calculated accurately, audit-ready, and delivered on time.

The ideal candidate possesses a strong analytical mindset, deep technical knowledge of Varicent logic, and the communication skills necessary to collaborate with Sales Leadership, Finance, and IT.

Responsibilities

• Ensures Commission Calculation and Reporting applications are operating efficiently.
• Plans Production data loads and verifies completion timeliness and accuracy.
• Handles Production incidents by leading impact and resolution analysis with various teams.
• Supports root cause documentation and implements lessons learned.
• Liaises with business stakeholders to understand requirements / pain points and comes up with solution recommendations.
• Supports application deployment activities and troubleshoots any environmental issues.
• Recommends enhancements to existing proc esses to increase efficiency.
• Build, test, and maintain calculation logic, formulas, workflows, and plan components within the Varicent ICM platform
• Translate complex, yearly sales incentive compensation plans into functional technical requirements and implement them within the system
• Design, develop, and maintain customized dashboards and reports for sales reps, managers, and executive leadership
• Conduct regular system audits to ensure data integrity, plan compliance, and alignment with internal financial controls (e.g., SOX compliance)

Requirements

• Minimum 7+ years of experience in IT application development, operations support, or a similar role.
• Experience with Mainframe programs
• Experience working with any type of ICM (Varicent or SSIS)
• Experience independently managing multiple concurrent assignments.
• Detail oriented, quick learner, self-starter.
• Strong oral and written communication skills.
• Ability to articulate technical issues, root cause, and remediation plans in layman's terms
• Experience working with SSIS and/or SSRS
• Eager to learn

Nice to Have

• Experience working with Varicent

Benefits

This position comes with a competitive compensation and benefits package.

• A competitive salary and performance-based bonuses
• Comprehensive benefits package
• Flexible work arrangements (remote and/or office-based)
• You will also enjoy a dynamic and inclusive work culture within a globally renowned group
• Private Health Insurance
• Paid Time Off
• Training & Development opportunities in partnership with renowned companies