Executive - Salary Structuring & Compensation Ops (Navi Mumbai)

Executive - Salary Structuring & Compensation Ops (Navi Mumbai)

21 Nov
|
Birla Management Centre Services
|
Navi Mumbai

21 Nov

Birla Management Centre Services

Navi Mumbai

Job Overview

- Job Title: Team Member - Compport Operations
- Job Band / Designation: Executive
- Business / Unit: Seamex (Global HR Shared Services & HR Technology Center)
- Location: Airoli, Navi Mumbai
- Reporting To: Team Manager

1. Job Purpose

The primary purpose of the job is to execute, scale, and audit the bulk generation of salary structures for large employee populations using advanced Excel data engineering, followed by seamless validation and ingestion into the SaaS-based compensation platform, Compport. The role acts as the critical operational engine for mass compensation modificationssuch as annual appraisal cycles, multi-business restructuring, and corporate grade alignments. It demands an expert-level ability to build fail-safe, formula-driven models that process tens of thousands of complex payroll rows simultaneously and execute flawless, error-free configurations within the Compport ecosystem.

2. Target Experience & Education Profile

- Experience Bracket: Entry to Early-Career (Up to 2 years of intensive, hands-on experience in high-volume payroll data operations, mass compensation structuring, or core backend HR analytics).

- Core Education: Graduate or Post-Graduate degree with an exceptionally strong mathematical or logical foundation (e.g., B.Sc. IT, BCA, B.Com with advanced analytics, or equivalent data-heavy backgrounds).

3. Key Core Competencies & Skill Matrix
Skill Domain

Technical Focus Areas:

SaaS Comp Architecture Functional understanding of rule-based compensation engines; data schema alignment, system file mapping, and console validation.

Bulk Excel ArchitectureStructural design of macro-enabled workbooks, agile array formulas, robust multi-sheet cross-referencing, and handling 50k+ data rows without system crashes.

Formula EngineeringMastery of advanced logical, lookup,



and financial string formulas (INDEX-MATCH, XLOOKUP, nested IF statements, IFS, ROUND, CHOOSE).Statutory Rule AutomationEmbedding complex local compliance thresholds (e.g., Indian Provident Fund statutory caps, ESIC limits, Professional Tax slabs, LWF) directly into spreadsheet logic.

Data Hygiene & CleansingConstructing automated error-trapping cells, validation flags, conditional formatting audits, and mass data-formatting string scripts (TRIM, CLEAN, TEXT).

4. Principal Accountabilities & Supporting Actions
Accountability 1: Mass Salary Structure Design & Excel Modeling

- Supporting Actions:
- Construct global, scalable Excel master sheets to calculate entire Cost-To-Company (CTC) break-ups (Basic, HRA, Allowances, Retirals) for thousands of employees simultaneously.
- Build dynamic salary models where changing a single macro-variable (e.g., an updated minimum wage threshold or basic salary percentage) instantly recalibrates the entire population's downstream components accurately.
- Implement high-performance lookup and array frameworks (XLOOKUP, INDEX-MATCH) to pull data across multi-variant business unit tables without straining system memory.

Accountability 2: Compport Ingestion, Hygiene, & Validation Controls

- Supporting Actions:
- Own the pre-upload data scrubbing, data normalization, and formatting of massive payroll sheets to ensure seamless,



error-free uploads into the Compport SaaS platform.
- Engineer dedicated "Audit & Control" columns in every workbook using conditional rules to flags any structural variances, negative components, rounding leaks, or out-of-bound CTCs instantly before execution.
- Manage mass data transformation pipelines, mapping diverse legacy salary formats into unified, upload-ready standardized configurations required by the Compport data schema.

Accountability 3: Statutory Logic Integration & Platform Sync (PF & Benefit Automation)

- Supporting Actions:
- Program complex, conditional statutory formulas into employee data sheetsmost notably Provident Fund (PF) rules (e.g., automating choices between the standard 15,000 cap, actual basic contribution, or VPF rules via nested MIN/MAX logic).
- Translate variable corporate incentive frameworks, multi-tiered performance bonus structures, and commission matrices into scalable, clean Excel logic blocks before syncing with the cloud compensation environment.
- Generate macro-driven reconciliation summaries that compare old vs. new salary increments across various businesses to provide finance teams with immediate budget impact visibility.

5. Key Internal Relationships

- Reporting Manager (Team Manager): Daily interaction to align on mass data processing timelines, review data validation audits, and sign off on verified master upload files.
- Payroll & HR Tech Interface Teams: Close coordination to ensure that Excel mass upload structures perfectly map with the technical data schemas of the Compport platform and backend ERP loaders.
- Business HR Partners / COEs: Need-based engagement to collect customized salary revision rule books, localized allowances, or exceptional business-unit compensation guidelines.

📌 Executive - Salary Structuring & Compensation Ops (Navi Mumbai)
🏢 Birla Management Centre Services
📍 Navi Mumbai

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: executive - salary structuring & compensation ops (navi mumbai) / navi mumbai

Subscribe to this job alert:

Get the latest job offers by email for: executive - salary structuring & compensation ops (navi mumbai) / navi mumbai