Executive - Data Analyst

Company DescriptionElevatoz 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 Responsibilities1. 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 sources2. 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 data3. 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 discrepancies4. 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 compliance5. 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 errors6. Process Improvement & Documentation Identify opportunities to improve data workflows Maintain records of data processing steps Train team members on Excel automation and best practicesRequired Skills & QualificationsAdvanced 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 organizationTo Apply:Please send your updated resume to helma.mathew@elevatozloyalty.com with the subject line: “Application for Executive - Data Analyst".