Rachel Koenig

Data Analyst - Marketing @FASHIONPHILE

Monthly reporting on commerce, web data, users and inventory for executives to get a clear snapshot of current business health and inform decision-making such as marketing and procurement budgets - Analyzing summary statistics of customer segmentation model and identifying cohorts such as high-value, entry-level and loyalist to reveal shopper and seller behavior and presenting findings to stakeholders in order to strategize user acquisition and retention plans and develop personalized shopping/selling experiences- Preparing and enhancing datasets and queries in a reproducible manner with thorough notes, documentation and Github to be used by the team and repurposed for various business analyses - Developing complex SQL scripts to extract data from a transactional database to analyze discounted returns & cancels and presenting findings to executives to inform decision making around discount schedule and return policy modifications- Building dashboards in AWS Quicksight for stakeholders to easily view post-promotion KPIs and analyze sales’ performance, to efficiently pull and filter lists of products for merchandising collections and lists of users for digital marketing audiences for ad targeting - Migrating to and launching new CDP, Segment - setting up all marketing destinations, creating audiences based on user behavior and lifetime value for email and ad personalization - Supporting marketing and merchandising teams with ad hoc analysis needs and identifying trends that they use in conjunction with the PR team to gain brand awareness with quotes in fashion publications - Partnering with data engineer to improve data architecture and gain the ability to join and query data across multiple platforms