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 3 days ago
Similar jobs that could be interesting for youBased on the Data Analyst - Excel - Vba in Kolkatta vacancy
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....SuggestedKolkattaa month 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
Kolkatta12 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...SuggestedFull time
- ...from you! Genomics Specialist Responsibilities Duties Design, execute and analyze complex genomic experiments. Interpret genomic data and provide insights into disease mechanisms. Develop and implement bioinformatics pipelines for genomic data analysis....Suggested
Shine com
Kolkatta1 day 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,...SuggestedWorldwide
hoichoi
Kolkatta11 days ago - ...solutions that create a real-world impact in ride-hailing, multimodal transportation, and public utilities. What You'll Do As a Data Analyst, you'll play a critical role in ensuring operational excellence and enabling business-critical decisions through data. Your...
namma yatri
Kolkatta12 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
Kolkattaa month agoRs 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...FreelanceRemote jobFlexible hoursSoul Ai
Kolkattaa month ago- ...exceptional experience for yourself, and a better working world for all. Job Description: Aladdin BA- Data and Interface Job purpose: The Data Analyst – Technical Business Analyst that understands Aladdin including the data model to work on Aladdin data.(Security...Work at office
EY
Kolkatta3 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 timeHybrid work
Manhattan Tech Ventures
Kolkatta3 days ago Rs 2 - 5 lakhs p.a.
...As a Client Data Specialist within our KYC/AML team, you will be responsible for understanding and implementing KYC standards, guidelines... ...and achieve success in a team environment Role: Data Analyst Industry Type: Financial Services Department: Data Science...Permanent employmentFull timeWork at officeLocal areaJp morgan
Kolkatta20 days agoRs 2 - 5 lakhs p.a.
...As a Client Data Specialist within our KYC quality reviewer team, you will be reviewing the records completed by the production team to... ...meet deadlines against a high volume work schedule Role: Data Analyst Industry Type: Financial Services Department: Data...Permanent employmentFull timeLocal areaJp morgan
Kolkatta20 days agoRs 18.5 - 20 lakhs p.a.
...Job Title : Data Governance Skills : Data Governance , Data Quality, Data Integration, Metadata Management Location : Kolkata/Bengaluru/Mumbai/Pune/Delhi Experience : 16 - 19 yrs Roles & Responsibilities : • Become a trusted advisor to CDO / CIO / VP of IT and help...LTM
Kolkatta24 days ago- ...ConsultantMust-have skills : GenAI, RAG, Agentic AI, Python, SQL, AI/ML, Visualization (Power BI or Tableau)Good to have skills : R, Spark, data bricks, Ability to leverage design thinking, business process optimization, and stakeholder management skills.Job Summary :This role...
Rs 4 - 8 lakhs p.a.
...commitment of our people. It requires a consistent and committed practice, something we call the Juniper Way. What You'll Do ~ The Data Analyst for Customer Experience Programs is responsible for evangelizing KCS (Knowledge Centered Service) methodology and maintaining the...Juniper Networks
Kolkatta5 days ago- 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...
- 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
Rs 4 - 7 lakhs p.a.
...Behaviors and Education Requirements A university degree in Computer Science, Data Analysis or similar education and work experience Minimum of 4 years experience in a similar role or as a data analyst Experience on analysing mobile applications data. Experienced in...Prudential Group
Kolkatta17 days ago- ...skills - Effective stakeholder communication - Attention to detail and data accuracy - Ability to work in a fast-paced client environment Role Overview : We are looking for a skilled Business & Data Analyst with experience in the Banking & Financial Services (BFS) domain. The...
- ...Job Summary The Analyst is responsible for auditing and analyzing client invoice data to identify vendor overbilling and underbilling. The role involves applying audit methodologies, reviewing contracts and tariffs, and leveraging multiple data sources and tools to validate...
Rs 4.5 - 7 lakhs p.a.
...business-process knowledge associated with one or more of the following SAP functional modules: FI, CO, MM, SD, PM, PP, PS ~ Proficient in Data Migration tool Syniti ADMM with minimum 4years experience and two end to end implementation ~ Extensive data quality and data...Full timeCloudxtreme Technologies Private Limited
Kolkatta24 days agoRs 5 - 9.5 lakhs p.a.
...enhancements Perform ABAP/ABAP OO development for archiving solutions Ensure compliance with country-specific legal requirements and SAP data technology standards Support migration of SAP originals and unstructured data (e.g., GOS, DMS, SOFFCONTI) Stay updated with...Hybrid workGlobal Business Ser 4u
Kolkattaa month agoRs 9 - 18.5 lakhs p.a.
• Analyze database growth and implement SAP ILM Data Archiving solutions. • Provide installation, configuration, and technical/functional support for SAP ILM and associated components. • Coordinate with internal teams, external providers, and functional product teams for project...Hybrid workGlobal Business Ser 4u
Kolkattaa month ago- ...Online Data Analyst - Bengali (IN) Job Description : Are you a detail-oriented individual with a passion for research and a good understanding of national and local geography This freelance opportunity allows you to work at your own pace and from the comfort of your...Long term contractContract workPart timeFreelanceLocal areaWorldwide
telus digital
Barrackpore2 days ago Rs 2 - 5 lakhs p.a.
...responsibility would be to play the role of a quantitative Financial Analyst Your other responsibilities would include supporting general... ...This role also includes preparing and presenting financial data for review to management for making the right decisions Creating...Flexible hoursUps Supply Chain Solutions
Kolkatta17 days agoRs 3 - 6 lakhs p.a.
...experienced candidate to join our team in Mumbai. Market Risk ADTV Data teams mission is to help ensure valid Average Daily Traded Volume... ...like CFA/FRM are an added advantage. Role: Data Analyst Industry Type: Financial Services Department: Data Science...Permanent employmentFull timeJp morgan
Kolkatta20 days ago- Role description LTM is hiring immediate joiners for Azure Devops with 4-8 years of experience for all majot LTM locations (Pune/Chennai/Bangalore/Hyderabad/Kolkata) Skills required: Azure DevOps developer Hands on experience - 4-8 years in Azure, Devops ... ...Immediate startShift work
LTM
Kolkatta10 days ago - ...andFacebook. We are inviting applications for the role of Business Analyst Marketing Analyst Responsibilities Marcom Support Market... ...behaviour buying habits preferences and demographics. Data Analysis: Gather analyze and interpret complex data sets using various...Full timeRemote job
Rs 5 - 10 lakhs p.a.
...We are seeking a skilled PySpark Data Engineer to join our team and drive the development of robust data processing and transformation... ...configurations. Data Analysis and Transformation: Collaborate with data analysts, data scientists, and data architects to understand data...PHOTON
Kolkattaa month agoRs 1 - 5 lakhs p.a.
...Line of Service Advisory Industry/Sector Not Applicable Specialism Data, Analytics & AI Management Level Specialist Job Description & Summary At PwC, our people in data and analytics engineering focus on leveraging advanced technologies...PricewaterhouseCoopers Professional Services LLP
Kolkatta24 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Analyst - Excel - Vba. Be the first to apply!
