Sign up to access all features of our service
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Analyst - Excel - Vba

Talent Destination

Job Summary The MIS / ERP Data Analyst will manage, validate, analyze, and automate data flows across retail fashion operations. The role supports Sales, Merchandising, Production, and Store Operations through accurate MIS reporting, ERP data management, and process automation.

Key Responsibilities

  • Validate, clean, and standardize high-volume data from ERP, POS, Google Sheets , and store logs to ensure accuracy and consistency across retail operations.
  • Analyze business performance metrics, including category-wise sales, Stock performance, sell-through, stock ageing, replenishment cycles, material usage, and production timelines.
  • Create dynamic MIS dashboards and reports using Advanced Excel (XLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, PivotTables, Power Pivot, Query).
  • Build automated Excel processes using Macros, VBA, and Power Query for data transformation, Stock-level consolidation, and recurring MIS generation.
  • Prepare Sales, Marketing, Merchandising, Inventory, and Product MIS reports aligned with fashion retail KPIs.
  • Develop and maintain Google Workspace systems (Sheets, Forms, Docs) for store data inputs, production tracking, GRN logs, vendor updates, and product development workflows.
  • Use Google Apps Script to automate activities such as data imports, email alerts, scheduled reporting, and validation checks.
  • Coordinate with Stores, Merchandising, SCM, Production, Finance, and Marketing teams to collect information, resolve discrepancies, and ensure data integrity.
  • Support ERP, including SKU creation, BOM updates, purchase orders, inventory reconciliation, and production tracking.
  • Maintain structured data repositories, documentation, and standardized reporting templates.

Required Skills
  • Strong proficiency in Advanced Excel (power formulas, Power Query, Macros/VBA).
  • Expertise in Google Sheets, App Script automation, and Workspace tools.
  • Working knowledge of ERP systems for retail fashion (inventory, merchandising, production, procurement).
  • Attention to detail, data accuracy, and problem-solving capability.
  • Strong communication and cross-functional coordination skills.

Preferred language: C & C++

Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Data Analyst - Excel - Vba in Kolkatta vacancy
  • Description :Job Title : Senior Regulatory Reporting Data AnalystLocation : KolkataDepartment : Data - Enterprise Data lakeExperience :...  ...Description : We are looking for an experienced Regulatory Reporting Data Analyst to join our Data Lake team. The ideal candidate will have a... 
    Suggested

    Peoplemint Consultants LLP

    Kolkatta
    6 days ago
  • Job Description: Job Title: Data Analyst Job Description: We are looking for a skilled Data Analyst to collect, analyze, and interpret large datasets to help drive business decisions. The ideal candidate will have strong analytical skills, attention to detail, and experience... 
    Suggested
    Full time

    Recex

    Kolkatta
    more than 2 months ago
  •  ...About Us: Soul AI is a cutting-edge AI data and quality operations company founded by IIT Bombay and IIM Ahmedabad alumni. With team...  ...businesses and society. About the Role: We are looking for a Data Analyst to evaluate and refine data-oriented outputs generated by AI... 
    Suggested

    soul ai

    Kolkatta
    6 days ago
  •  ...actually happening — not just report on it. You'll work across product, content, growth, and marketing to turn raw subscriber and behavioural data into decisions. The platform generates rich signals: what people watch, when they leave, what brings them back, what content converts,... 
    Suggested
    Worldwide

    hoichoi

    Kolkatta
    4 days ago
  • Rs 1 - 4 lakhs p.a.

     ...team from IITs, NITs, and BITS. We specialize in delivering high-quality human-curated data, AI-first scaled operations services, and more. We are seeking skilled Data Analysts with a minimum of 1 year of experience to join us as freelancers and contribute to impactful... 
    Suggested
    Freelance
    Remote job
    Flexible hours

    Soul Ai

    Kolkatta
    20 days ago
  • Rs 6 - 8 lakhs p.a.

     ...About the Role We are seeking a detail-oriented and analytical Data Analyst to join our team. The ideal candidate will have a passion for working with data, strong problem-solving skills, and the ability to translate complex information into actionable business insights.... 
    Kolkatta
    25 days ago
  • Description :Key Responsibilities :- As an AWS Data Engineer, your key responsibilities will include the design, development, and maintenance...  ...primarily on Spark/PySpark coding.- Collaboration with data analysts to fulfill data requirements for analytics purposes is expected.-... 
    Immediate start

    Prompt Smart Solutions

    Kolkatta
    8 days ago
  • Rs 0.5 - 1 lakhs p.a.

     ...Expert in all aspects of data management and analysis with a strong ability to convert data into meaningful insights. This role requires...  ...quality, and compliance requirements. Guide and mentor junior analysts to ensure best practices in data handling and reporting.... 

    Times World Information Technology

    Kolkatta
    a month ago
  • Rs 20 - 40 lakhs p.a.

     ...JobType: full-time We are seeking a highly experienced Senior Data Modeler to lead the design and architecture of enterprise-grade...  ...functional teams including Data Engineers, Product Owners, and Business Analysts to translate business needs into structured data solutions... 
    Full time
    Hybrid work
    Weekday work

    Weekday AI

    Kolkatta
    1 day ago
  • Rs 4 - 8 lakhs p.a.

     ...Job Description Skill required:  ~ Data Management - Talend Designation:  ~ Data Eng, Mgmt & Governance Sr Analyst Qualifications: Any Graduation Years of Experience:2 years Language - Ability:English(International) - Expert job summary: As a Data... 

    Accenture India

    Kolkatta
    4 days ago
  • Rs 15 - 25 lakhs p.a.

     ...JobType: full-time We are seeking a skilled and motivated Data Engineer with a strong foundation in data engineering and exposure...  ...ML model development. You will work closely with data scientists, analysts, and engineering teams to ensure high-quality, reliable, and efficient... 
    Full time
    Weekday work

    Weekday AI

    Kolkatta
    19 days ago
  • Description : We are looking for a highly skilled Data Scientist with strong expertise in Machine Learning and Generative AI to build data-driven solutions and intelligent systems.Key Responsibilities : - Develop ML models (Regression, Random Forest, etc.)- Work on large datasets... 

    1HResource Solutions

    Kolkatta
    3 days ago
  •  ...platform, and a range of bespoke client projects. Our team specializes in AdTech, AI/ML, and large-scale data systems.  This is a unique opportunity for a Data Analyst to work on deep-tech challenges, analyzing vast datasets from our AdTech and media platforms to uncover... 
    Full time
    Hybrid work

    Manhattan Tech Ventures

    Kolkatta
    6 days ago
  •  ...Ericsson is hiring for the role of Data Scientist! Responsibilities of the Candidate:  MCP-based applications and tools integrated with enterprise systems Building GenAI Agents RAG pipelines over network, service, customer & operational data Scalable Python services... 
    Kolkatta
    1 day ago
  • Rs 10000 - Rs 12000 per month

    Data Analytics Trainee Start Date Starts  Immediately...  ...meaningful insights. You will work closely with our experienced data analysts to support decision-making processes and drive business growth through... 
    Traineeship
    Immediate start

    Comienzo Vision Private Limited

    Kolkatta
    20 days ago
  • Rs 4 - 7 lakhs p.a.

     ...Snowflake. Experience working with NetSuite and Workday ERP systems. Strong analytical skills and ability to interpret complex business data. Hands-on experience with BI tools such as PBI. Understanding of ETL processes and data integration. Ability to work with... 

    Iospl Technology Services

    Kolkatta
    a month ago
  • Competencies :- Any IT graduateJob Description :Required Skill Set : - Proficiency in Python programming.- Experience with Pandas for data manipulation and analysis.- Knowledge of Polars for efficient data processing.- Strong problem-solving skills and attention to detail.-... 

    Prompt Smart Solutions

    Kolkatta
    9 days ago
  •  ...Banking Domain experience- Salesforce Sales cloud- CRM Assessment project experience would be an added advantage- Salesforce Business Analyst with 8 to 10 years of experience in the Banking domain and Salesforce Sales Cloud to drive business and functional analysis... 
    Immediate start

    People Prime Worldwide Pvt. Ltd.

    Kolkatta
    4 days ago
  • Rs 3.5 - 3.84 lakhs p.a.

     ...Actively hiring HR Analyst Start Date Starts  Immediately...  ...in driving the company's HR strategies through your expertise in data analysis, report generation, and database management system (DBMS... 
    Immediate start

    Torrins Anthem Private Limited

    Kolkatta
    24 days ago
  •  ...flexibility, testability, and standardization. - Experience in writing advanced queries and transformations with T-SQL. - Expertise in building data visualizations with a strong understanding of the chart types which is used to highlight patterns in the data for unstructured and... 
    Work at office

    TechnoRight

    Kolkatta
    3 days ago
  • Rs 2.5 - 8 lakhs p.a.

     ...testing, integration testing, and regression testing. Collaborate with cross-functional teams to address and resolve defects. 3. Data Analysis: Analyze and interpret data to derive actionable insights. Ensure data accuracy, consistency, and security in SAP Public... 

    Fort Technologies

    Kolkatta
    a month ago
  • Job description :We have a job opening for a Healthcare Reporting Analyst with good working knowledge of MS SQL Server, Oracle, Discern...  ...primarily on transforming complex clinical, financial, and operational data into actionable reports and dashboards to improve patient... 
    Full time

    Fundfina

    Kolkatta
    25 days ago
  • Rs 2 lakh p.a.

     ...Actively hiring Data Entry Executive Start Date Starts  Immediately CTC (ANNUAL) ₹ 2,00,000 ₹ 2,00,000 /year Experience... 
    Immediate start

    Codezin Technology Solutions

    Kolkatta
    17 days ago
  •  ...them for better outcomes. We are currently seeking an experienced professional to join our team in the role of  Assistant Director, Data and Analytics   In this role, you will: Act as an SME/consultant on a functional area, conceptualize analytical solution for the... 
    Permanent employment
    Flexible hours

    HSBC Global Services Limited

    Kolkatta
    1 day ago
  • Job Description: Job Title: Admin (Data Entry + Data Analyst) Experience: 3-4 years Qualification: ~B.Com / BCA / B.Sc (IT/Statistics) ~Data Analytics Certification (preferred) Gender: Male/Female Job Responsibilities: ~Perform data entry tasks with accuracy and efficiency... 
    Full time

    Recex

    Kolkatta
    more than 2 months ago
  • Interested Candidates can be apply Last Date-30/12/2022

    Us Health & Family Welfare Department West Bengal (हेल्थ एंड...

    Kolkatta
    24 days ago
  • Rs 4.5 - 5 lakhs p.a.

     ...Actively hiring Quality Analyst Executive Start Date Starts  Immediately...  ...and addressing any quality-related concerns. 5. Analyzing data and performance metrics to track the effectiveness of quality assurance... 
    Immediate start

    USDC Projects India Private Limited

    Kolkatta
    16 days ago
  • Hiring : Senior Staff Engineer (Business Analyst SAP & Field Services)Experience : 7.5 10 YearsLocation : Mumbai, Bangalore, Hyderabad, Kolkata, Chennai, Pune, Jaipur, Noida, Gurgaon/Gurugram (Hybrid work mode)Employment Type : [Contract -6 months (can be extended based on... 
    Contract work
    Hybrid work

    CrossRoad Solution

    Kolkatta
    22 days ago
  • Rs 2 - 5 lakhs p.a.

     ...Seeking for a strong data analyst who can perform independent. Good to have Prior experience in banking domain is plus and understanding the finance various data transactions. Should be strong in the below: Python Pyspark SQL Airflow Trino Hive Offshore... 

    PHOTON

    Kolkatta
    18 days ago
  •  ...Supply Chain Data AnalystJob Offer Are you a data-driven supply chain professional looking to make a significant impact? Do you thrive...  ...collaborating with cross-functional teams? If so, this Supply Chain Data Analyst role is perfect for you! Experience 3 years Skills... 

    Randstad

    Kolkatta
    25 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Analyst - Excel - Vba. Be the first to apply!