Job
Description
About PINQ Polka At PINQ Polka, A Shark Tank featured brand we are redefining the intimate hygiene and wellness experience for women across India. Loved by over 3L+ customers and growing rapidly, we are a proudly homegrown D2C brand that believes in making wellness convenient, accessible, and empowering. Role Summary We are looking for a highly analytical and detail-oriented Data Analyst with prior e-commerce and D2C experience , especially in payment reconciliations across marketplaces and direct platforms . You’ll be responsible for turning data into actionable insights, managing dashboards, and supporting strategic decision-making using tools like Power BI and Excel . Key Responsibilities Perform daily, weekly, and monthly payment reconciliations across e-commerce marketplaces (Amazon, Flipkart, etc.) and D2C platforms (Shopify, etc.) Analyze consumer behavior, buying patterns, and product performance across platforms (Shopify, Amazon, etc.) Create and maintain dashboards to track business KPIs (CAC, LTV, conversion rates, repeat rates, etc.) Dive into customer feedback, reviews, and CRM data to extract actionable insights Collaborate with leadership to shape strategy through weekly and monthly MIS Identify discrepancies in payment settlements and coordinate with finance/operations for resolution Develop and maintain automated dashboards on Power BI and/or Google Data Studio Analyze consumer behavior, sales performance, inventory turnover, and campaign ROIs Generate actionable insights to support marketing, category, and product teams Create comprehensive data reports and KPIs tracking for stakeholders Assist in forecasting, budgeting, and business performance models Collaborate closely with Tech, Marketing, Operations, and Finance teams to ensure data accuracy and efficiency Requirements Bachelor’s degree in Statistics, Economics, Computer Science, Finance, or related field 2–4 years of experience in data analytics , preferably with an e-commerce/D2C brand Strong experience in payment reconciliation across marketplaces Advanced skills in Excel (Pivot Tables, VLOOKUP, macros) and Power BI Familiarity with Google Analytics, Meta Insights, and e-commerce backend dashboards (Shopify, Unicommerce, etc.) Solid understanding of data architecture and automation tools (basic SQL knowledge a plus) Ability to manage large datasets and present data in a clear and concise manner Excellent analytical thinking, problem-solving, and communication skills
