AI Summary
Turn field and distributor data into actionable business decisions by analyzing sell-in/sell-out metrics, distribution coverage, and AI model outputs. Write optimized SQL on PostgreSQL, build dashboards, and automate analyses with Python to support product and business teams. Requires 2+ years of data analysis experience with SQL, Python, and BI tools in the FMCG domain.
Key Highlights
SQL optimization on PostgreSQL for large-scale data extraction and transformation
Dashboard creation and maintenance for internal teams and customers
Collaboration with AI/ML team on feature engineering for forecasting and route optimization
Key Responsibilities
Write and optimize SQL on PostgreSQL to extract and transform large volumes of field and sales data
Analyze sell-out, distribution coverage, out-of-stock, MSL compliance, and share-of-shelf metrics by channel
Build and maintain dashboards and self-service reports for internal teams and customers
Monitor data quality from mobile apps and computer-vision pipeline; define anomaly and gap checks
Prepare and feature-engineer datasets for demand forecasting and route optimization with the AI/ML team
Turn business questions into concrete analyses and clear recommendations for non-technical audiences
Automate recurring analyses and reports with Python (pandas) instead of manual work
Define metrics and benchmarks for new product features
Technical Skills Required
Benefits & Perks
100% remote - work from anywhere
Flexible working hours
Budget for learning and conferences
Paid leave above the minimum
Direct access to the founder and real impact
Nice to Have
FMCG/retail domain experience
Time-series/demand forecasting
Git and working in a shared codebase
Market data (Nielsen/GfK) and matching sell-in vs sell-out
dbt or other data transformation tools
Basic understanding of ML workflows
Job Description
Tech stack
SQLPythonPostgreSQLpandasPower BIData VizFMCG AnalyticsEnglish
About The Role
Turn the field and distributor data of our customers into real business decisions. You work with sell-in/sell-out, distribution coverage, retail-execution metrics and the output of our AI models (shelf computer vision, demand forecasting, route optimization). The role sits between product, the AI/ML team and the real needs of the FMCG business.
What you will do
- Write and optimize SQL on PostgreSQL to extract and transform large volumes of field and sales data (orders, visits, stock, promotions)
- Analyze sell-out, distribution coverage (numeric/weighted), out-of-stock, MSL compliance and share-of-shelf by channel (GT, MT, HoReCa)
- Build and maintain dashboards and self-service reports for internal teams and customers
- Monitor data quality from the mobile apps and the computer-vision pipeline; define anomaly and gap checks
- Prepare and feature-engineer datasets for demand forecasting and route optimization with the AI/ML team
- Turn business questions into concrete analyses and clear recommendations for a non-technical audience
- Automate recurring analyses and reports with Python (pandas) instead of manual work
- Define metrics and benchmarks for new product features
- 2+ years as a Data Analyst / BI Analyst, ideally with sales, retail or FMCG data
- Strong SQL - joins, window functions, CTEs, query optimization (PostgreSQL a plus)
- Practical Python for analysis - pandas, numpy, Jupyter
- Experience with BI/visualization (Power BI, Metabase, Looker or similar) and building dashboards from scratch
- Understanding of basic statistical concepts - distributions, correlations, seasonality
- Clear communication of findings in Bulgarian and English to technical and non-technical stakeholders
- Analytical, curious mindset - you get to the why behind the data
Interested in remote work opportunities in Data Science? Discover Data Science Remote Jobs featuring exclusive positions from top companies that offer flexible work arrangements.
FMCG/retail domain - secondary sales, distributor management, trade promotionsTime-series / demand forecasting (exponential smoothing, ARIMA, ensemble)Git and working in a shared codebase (versioned SQL/Python, code review)Market data (Nielsen/GfK) and matching sell-in vs sell-outdbt or other data transformation toolsBasic understanding of ML workflows
Your first 90 days
1
First 30 days
Learn the data model and write your first production SQL/Python analyses.
2
By 60 days
Ship your first dashboard into real use by a team or customer.
3
Browse our curated collection of remote jobs across all categories and industries, featuring positions from top companies worldwide.
Independently run an analysis that influences a product decision.
What we offer
- 100% remote - work from anywhere
- Flexible working hours
- Budget for learning and conferences
- A modern stack, no legacy ballast
- Paid leave above the minimum
- Direct access to the founder and real impact
An AI-native product with real computer vision, forecasting and LLMs - not "AI" on paper.
100% remote with real ownership - your decisions shape the product.
A small team means you see the impact of your work directly at customers.
An EU-built product for the global FMCG market, with real domain experience behind it.
About Optimasoft
Optimasoft builds the AI-native platform for European FMCG - data, routes, shelf and AI in one. A small, founder-led team, 100% remote, with real domain experience behind the product.
Similar Jobs
Explore other opportunities that match your interests
Visa Sponsorship
Relocation
Remote
Job Type
Full-time
Experience Level
Mid-Senior level
vinculum growth oy
Singapore
Visa Sponsorship
Relocation
Remote
Job Type
Contract
Experience Level
Mid-Senior level
Insight Global
United State
Visa Sponsorship
Relocation
Remote
Job Type
Contract
Experience Level
Mid-Senior level
silversearch, inc.
United State