Executive - Data Analyst

Company Description

Elevatoz Loyalty specializes in creating and managing channel loyalty, customer loyalty, and employee rewards and recognition programs. Our work is grounded in the study of human behavior, powered by state-of-the-art technology, and guided by holistic program design to ensure desired outcomes. We partner with major brands across the country, delivering impactful loyalty and engagement programs through our robust technology platform.

Role: Data Management Specialist

Location: Bengaluru

Experience: 2–3 Years

Type: Full-time (On-site)

Role Overview

We are seeking a Data Management Specialist to support our data processing operations. The ideal candidate will be responsible for cleaning, restructuring, validating, and uploading data into our systems while ensuring accuracy and compliance with program rules.

This role requires advanced Excel skills to manipulate and organize data efficiently. The selected candidate will also be responsible for conducting post-upload testing to confirm data integrity.

Key Responsibilities

1. Data Cleaning & Preparation

• Identify and correct inconsistencies, duplicates, and errors in datasets
• Standardize and format raw data to match system requirements
• Ensure data consistency across different sources

2. Data Reorganization & Formatting

• Transform data structures to align with the platform’s required format
• Create and modify Excel templates/macros for efficient data processing
• Use pivot tables, formulas, and automation techniques to organize data

3. Data Validation & Compliance

• Validate datasets against predefined business rules and logic
• Perform checks to ensure data accuracy, completeness, and integrity
• Collaborate with stakeholders to resolve discrepancies

4. Data Upload & System Integration

• Prepare and upload validated data into the platform
• Address errors during upload and troubleshoot issues
• Document upload procedures and ensure system compliance

5. Post-Upload Testing & Quality Assurance

• Conduct data verification after uploads to confirm accuracy
• Perform sample checks to identify missing or incorrect entries
• Generate reports to highlight anomalies or errors

6. Process Improvement & Documentation

• Identify opportunities to improve data workflows
• Maintain records of data processing steps
• Train team members on Excel automation and best practices

Required Skills & Qualifications

• Advanced proficiency in Microsoft Excel, including:
• Pivot tables, VLOOKUP, HLOOKUP, INDEX-MATCH, nested formulas
• Data cleaning functions like TEXT, CONCATENATE, TRIM, SUBSTITUTE, etc.
• Macros and VBA scripting (preferred, not mandatory)
• Experience handling and processing large datasets
• Strong attention to detail and problem-solving skills
• Ability to follow complex data validation rules
• Understanding of data structures and formatting principles
• Excellent organizational and documentation skills
• Ability to work independently and handle multiple tasks.

Preferred Qualifications

• Bachelor’s degree in Data Science, Information Systems, Business Analytics, or related field
• Experience working with database tools or data management systems (optional)
• Familiarity with Python or SQL for data manipulation (a plus, not mandatory)

Compensation & Benefits

· Competitive salary based on experience

· Performance-based incentives and recognition

· Opportunity to work with a dynamic, collaborative team

· Access to upskilling and learning opportunities

· Career growth path within the organization

To Apply:

Please send your updated resume to helma.mathew@elevatozloyalty.com with the subject line: “Application for Executive - Data Analyst".