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
- 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...SuggestedFull time
- ...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
- ...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,...SuggestedWorldwide
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...SuggestedFreelanceRemote jobFlexible hoursRs 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....- 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
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....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 timeHybrid workWeekday workRs 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...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 timeWeekday work- 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...
- ...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 timeHybrid work
- ...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...
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...TraineeshipImmediate startRs 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...- 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.-...
- ...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
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- ...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
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...- 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
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- ...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 employmentFlexible hours
- 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
- Interested Candidates can be apply Last Date-30/12/2022
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- 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 workHybrid work
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...- ...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...
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Analyst - Excel - Vba. Be the first to apply!

