Job description Job Title: Data Analyst (VBA Expertise Required) Company: Citykart Retail Pvt. Ltd. Location: Gurugram Experience: Minimum 2 Years Department: Business Planning & Automation Job Highlight: Skills: - Good understanding of VBA / Excel Macros & VB Scripts Work Mode: In-person Role Overview: Citykart Retail is seeking a highly skilled and detail-oriented Data Analyst with strong proficiency in VBA to join our Business Planning & Automation team. This role involves automating data processes, developing customized reporting tools, and building efficient dashboards to drive data-led decision-making and operational efficiency. Key Responsibilities: Develop, maintain, and optimize VBA-based tools, macros, and applications across Excel, Outlook, and other Microsoft Office platforms. Automate recurring reports and streamline business processes through effective data transformation techniques. Create and manage interactive dashboards and custom user forms tailored to various business requirements. Integrate Excel with external data sources, including databases, APIs , and ERP systems , for seamless reporting. Debug, test, and enhance scripts and tools to improve performance and ensure data accuracy. Maintain comprehensive technical documentation and provide end-user support and training as needed. Work closely with cross-functional teams to gather requirements and deliver reliable, scalable solutions. Required Skills & Qualifications: Advanced proficiency in VBA programming and Excel automation . Expertise in Advanced Excel features such as pivot tables, formulas, conditional formatting, charts, and data validation. Proven experience in developing Excel-based dashboards and reports. Strong analytical, debugging, and problem-solving skills. Excellent communication and documentation abilities. Compensation: ₹40,000 – ₹50,000 per month
Job Title: Assistant Manager – Automation (Python) Company: Citykart Stores Pvt. Ltd. Location: Gurugram Experience: Salary Range: ₹7 – ₹10 LPA Employment Type: Full-Time | Work from Office Job Overview: We are seeking a highly skilled and proactive Assistant Manager – Automation (Python) to design, implement, and manage automation solutions that improve efficiency across business processes. The candidate should have hands-on experience with Python and a good understanding of process automation in a business environment. Key Responsibilities: Design and develop automation scripts using Python for various operational and business tasks. Automate data extraction, transformation, and report generation across Excel, Outlook, PDFs, Web Portals, and Databases . Build and maintain ETL pipelines and automate repetitive manual processes. Integrate APIs for data retrieval and system connectivity. Collaborate with stakeholders to understand requirements and deliver effective automation solutions. Maintain documentation of processes, scripts, and technical configurations. Monitor and troubleshoot existing automation tools to ensure smooth execution. Ensure compliance with data privacy, security, and company IT policies. Technical Skills Required: Proficiency in Python , with strong knowledge of: Pandas, NumPy, OpenPyXL, xlrd/xlwt for Excel automation Selenium or BeautifulSoup for Web Scraping Requests or HTTP libraries for API integration PyPDF2 or PDFPlumber for PDF parsing Knowledge of VBA/Macros for Excel-based legacy automations (added advantage). Hands-on with Windows Task Scheduler or Cron Jobs for scheduling scripts. Basic understanding of SQL and database integration. Experience with version control systems like Git is a plus.
Job Title: Retail Planner Location: Gurugram CTC: ₹15–30 LPA Experience Required: 4–8 Years (Preferably from Retail Fashion Stores) About Us CityKart Store Pvt Ltd is one of India’s fastest-growing value retail chains, catering to the fashion and lifestyle needs of Tier 2 and Tier 3 cities. With our rapidly expanding footprint, we are on the lookout for dynamic professionals who are passionate about numbers, trends, and retail strategy. Role Overview We are seeking a strategic and detail-oriented Retail Planner to manage merchandise planning, optimize inventory, and drive profitability. The ideal candidate should have experience in retail fashion planning, a strong analytical mindset, and the ability to work cross-functionally. Key Responsibilities Develop and manage Seasonal OTB and Option Plans. Track KPIs: Sales, Sell-through %, Stock Turns, Inward & Outward movements. Provide weekly/monthly performance reports to senior leadership. Monitor and manage markdown strategy to optimize sell-through and margins. Suggest markdowns based on product performance and ageing. Prepare and maintain Product/Category-level P&L statements. Align merchandise planning with financial targets in coordination with Finance. Maintain optimal inventory levels across categories and store locations. Analyze trends and forecast demand to support merchandise buying. Collaborate with Buying, Marketing, VM, and Finance for execution alignment. Recommend actions to improve Gross Margin and reduce inventory risk. Utilize historical data and market trends for accurate planning and allocation Candidate Requirements Bachelor’s/Master’s degree in Business, Retail, or related field. 4–8 years of relevant experience in Retail Planning , preferably in the Fashion/Retail sector . Strong knowledge of retail math , inventory management , and sales forecasting . Proficiency in Excel/MIS tools and analytical reporting. Excellent communication and interpersonal skills. Strong problem-solving ability and a keen eye for detail. What We Offer Opportunity to work with a fast-growing retail brand. Dynamic work environment with exposure to cross-functional teams. Competitive salary and performance-based growth. 📩 To Apply: Send your updated CV to naval@citykartstores.com with the subject line “Application for Retail Planner – Gurugram”.
As a Category Head for Menswear, Ladieswear, and Kidswear at our company in Gurugram, you will have the exciting opportunity to lead the end-to-end category management process. Your responsibilities will include assortment planning, buying, pricing, and merchandising to drive the success of these categories. Key Responsibilities: - Analyze sales, margins, and consumer behavior to develop effective category strategies and enhance performance. - Stay updated on emerging trends, market opportunities, and consumer needs to drive growth and innovation within the categories. - Build and maintain a strong vendor network and sourcing strategy that aligns with our value retail positioning. - Collaborate with various teams such as PD, design, supply chain, marketing, and retail operations to ensure smooth execution of category plans. - Monitor key performance indicators (KPIs) for the categories and implement strategies to achieve growth and profitability targets. Qualification Required: - Proven track record in category management within a value retail format. - Possess strong analytical, strategic planning, and negotiation skills. - Educational background in B.Tech (Textiles/Apparel) or NIFT is preferred. Join us and be part of a dynamic team where your expertise in category management will play a crucial role in driving the success of our Menswear, Ladieswear, and Kidswear categories.,