To the team of the Fulfillment Efficiency and Labor Productivity department, we are looking for a business analyst who will help the management teams of regional divisions in preparing and exporting reports on the performance of facilities (warehouses, sorting centers, logistics platform) across various segments (operations, financial indicators, losses, workload, and other facility KPI indicators).
You will work directly with the management of facilities and regional units.
Your responsibilities will include:
Reporting Automation
- Collecting daily/weekly warehouse logistics metrics (KPIs, productivity, errors).
- Consolidating data from WMS, logista Excel.
- Data visualization (providing presentations/reports).
- Developing and maintaining regular data exports for business units.
- Migrating and optimizing queries between databases (Vertica).
- Accelerating the performance of data marts and complex queries.
Business Analytics and Ad-hoc Analysis
- Identifying data anomalies.
- Calculating key performance metrics.
- Developing logic for calculating motivational coefficients and simulating payments.
Predictive Modeling (Capacity Planning)
- Building models for forecasting warehouse load.
- Selecting hyperparameters, evaluating the quality of the optimal model.
- Calculating resource needs for long-term periods.
Data Infrastructure
- Setting up reference books and mappings (operation-process).
- Optimizing data sources for correct report operation.
- Supporting the analyst's working environment (access, environment, tools).
Development and Knowledge Transfer
- Transferring developed solutions to the production environment (automation).
- Documenting the logic of calculations and reports for adjacent teams.
We expect:
- Completed higher education.
- At least 1-2 years of experience in a similar analyst/business analyst position in FMCG, retail, e-commerce, or logistics companies.
- Advanced Excel skills, developed SQL skills for writing queries and extracting necessary indicators from databases to form reports, Python (automation, ML models), BI tools (Grafana, Power Query) for data visualization.
- Understanding of operational performance indicators for warehouses and logistics.
- High work speed: ability to quickly switch between analytics and routine tasks.
- Stress resistance: readiness to work in the dynamic environment of warehouse logistics, willingness to jump into tasks.
- Proactiveness: ability not just to find errors in data, but also to propose solutions.
