Company:** Periodika Press
Location: Moscow
Experience: 1 to 3 years
«Periodika» is a photo book creation service. We help people preserve family history in a tangible form. Our clients place around 200,000 orders annually, and our assortment includes over 60 SKUs considering formats and page counts.
Over ten years of operation, we have accumulated a large volume of data on orders and customer behavior. Currently, the infrastructure and some reporting are supported by an external analytics agency, but we need an analyst within the team — someone who will regularly work with data and transform it into solutions for product and marketing.
Responsibilities
Product and Assortment Analytics
- Analyze launches of new photo books and other products: determine if a launch created additional demand or redistributed sales among existing products.
- Evaluate the effectiveness of the product matrix: identify weak SKUs, duplicate items, and products that are advisable to remove from the assortment.
- Analyze sales by format, number of pages, price, discount, acquisition channel, and customer type.
- Assist the team in making decisions about launching, modifying, or closing products.
- Develop a methodology for evaluating product launches and experiments.
Marketing Activities Analytics
- Correlate demand dynamics with website traffic, advertising activity, seasonality, and assortment changes.
- Analyze promotions and discount campaigns: calculate their real effect, additional revenue, and impact on profitability.
- Compare results with previous periods and prepare recommendations: repeat the mechanic, modify it, or abandon it.
Work with tools:
- Web and mobile analytics (Google Analytics, Firebase, Yandex.Metrica)
- Work with existing Datalens \ Datastudio dashboards
- Write SQL queries for data extraction and analysis (DB in Clickhouse) for Adhoc analysis
- Collaborate with project analysts from other departments.
Requirements
- At least two years of experience as a product, marketing, or web analyst.
- Proficient in SQL.
- Experience with BI systems; knowledge of DataLens will be an advantage.
- Experience and understanding of web analytics principles.
- Proficient in Excel or Google Sheets.
- Understanding of product and commercial metrics: revenue, average check, repeat purchases, retention, LTV, profitability, conversion.
- Ability to independently translate a business question into an analytical task, choose a calculation method, and deliver work with recommendations.
- Ability to explain findings in simple terms: what happened, why, and what decision should be made.
Will be a plus
- Experience in e-commerce, retail, D2C, or businesses with a wide assortment.
- Experience with CRM analytics and large customer databases.
- Python knowledge at the level of applied data analysis.
- Experience analyzing promotions, discounts, and product cannibalization.
- Familiarity with A/B testing and quasi-experimental evaluation methods.
What we offer
- A brand loved by customers and the professional community.
- An emotional product with significant potential for repeat purchases.
- Freedom to propose, debate, test, and change.
- A team that loves good ideas and is ready to implement them.
- Work in a beautiful office in Moscow on Kuznetsky Most.
- The opportunity to print photo books for free several times a month.
In the next stages, we may ask you to fill out a questionnaire, complete a small test assignment, or invite you to the office for an interview.