Data Analyst

Role Title: Data Analyst

Role Expectations

 Build and automate robust data pipelines using Python and pandas Manage, analyse, and visualize data leveraging AWS services (S3, Redshift, Lambda, etc.) Create dashboards and insightful visualizations using tools like AWS QuickSight and othervisualization tools Develop and maintain internal tools and dashboards using Python frameworks (preferably Django or Dash) Write advanced SQL queries and create reports, alongside utilizing advanced Excelfunctionalities Design and deliver actionable business insights through analytics and visualization tools Collaborate with business, marketing, and tech teams to support data-driven decision - making Operate and automate tasks efficiently in Linux environments

Role Deliverables

 End-to-end automation of data pipelines for business processes Creation of dashboards and insightful visualizations to support decision-making Creation and maintenance of interactive dashboards and reporting solutions Timely delivery of data analysis to solve key business challenges Automated data workflows and tools that enhance team efficiency Development and deployment of scalable analytics solutions in a high-growth D2C environment Documentation and knowledge-sharing of automation best practices within the team

Reporting Relationships

• Reporting To: BI Manager
  

Role Specifications

 Strong hands-on skills in Python (especially for automation; pandas required) Advanced SQL expertise (Redshift or major RDBMS) and proficiency in Excel Experience with AWS cloud services for data workflows Proficiency in creating dashboards and data visualizations using tools such as AWSQuickSight, Power BI, Tableau, etc. Comfort working in Linux environments (bash, cron jobs, scripting, etc.) Familiarity with Django or willingness to learn quickly Experience building data visualizations and using tools such as AWS QuickSight, Power BI,or Tableau Demonstrated ability to build full data pipelines from scratch, including deployment Excellent logic, problem-solving, and communication skills Previous experience in e-commerce, D2C, or retail analytics is a plus

Educational Qualifications

• Graduate or Master’s degree in Statistics, Mathematics, Computer Science, Engineering or a
  

related field

• Post Graduation Diploma in Data Science or equivalent in Python preferred
• AWS Certified Cloud Practitioner is preferred
  

Experience Required

 2–5 years of hands-on experience in data analytics, automation, or a similar role Prior experience working in high-growth, fast-paced environments such as e-commerce,D2C, or retail analytics preferred. Tool Expected: AWS, Linux, Python including Pandas, MySQL, AWS Redshift, Django, Process automation and any BI tool.

About SUGAR Cosmetics (www.sugarcosmetics.com)

SUGAR Cosmetics, a cult favorite amongst Gen Z and millennials, is one of the fastest-growingpremium beauty brands in India. With its clutter-breaking persona, signature low-poly packaging and chart-topping products, SUGAR is the makeup of choice for bold, independent women who refuse to be stereotyped into roles. Crafted in state-of-the-art facilities across Germany, Italy, India, USA and Korea, the brand ships its bestselling products in Lips, Eyes, Face, Nails & Skin categories across the world. With a cruelty-free range that is high on style and higher on performance, the brand is obsessed with crafting products that are a perfect match for every Indian skin tone across seasons and around the calendar. Backed by the trust of marquee investors and the love of millions of makeup enthusiasts, SUGAR Cosmetics is rapidly scaling its physical presence with 50,000+ retail touchpoints across 550+ cities and a mission of reaching the doorstep of every makeup user in the country.Skills: power bi,dash,analytics,data,tableau,pandas,excel,sql,aws quicksight,django,linux,python,aws