Data Analyst

Role Overview

Join OptimaSoft as a Data Analyst focused on leveraging field and distributor data to drive impactful business decisions in the FMCG sector. This position requires working with a variety of sales and distribution metrics such as sell-in/sell-out data, coverage metrics, retail execution results, and outputs from AI models including shelf computer vision, demand forecasting, and route optimization. Collaborating closely with product and AI/ML teams, you will bridge technical solutions and commercial needs.

Key Responsibilities

• Develop and optimize complex SQL queries in PostgreSQL to extract and transform large datasets involving orders, visits, stock levels, and promotions.
• Analyze key FMCG performance indicators like sell-out rates, distribution coverage, out-of-stock conditions, MSL compliance, and share-of-shelf across multiple channels including GT, MT, and HoReCa.
• Create and sustain dashboards and self-service analytical reports for internal teams and clients.
• Monitor data integrity from mobile applications and computer vision pipelines, establishing anomaly detection and gap analysis procedures.
• Collaborate with the AI/ML team to prepare and engineer features for datasets used in forecasting demand and optimizing routes.
• Translate business questions into clear, actionable insights tailored for audiences without technical expertise.
• Automate repetitive data reports and analyses using Python libraries such as pandas to minimize manual work.
• Establish metrics and benchmarks for evaluating new product features.

Candidate Profile

• Minimum of two years’ experience as a Data Analyst or Business Intelligence Analyst, preferably with exposure to sales, retail, or FMCG datasets.
• Proficient with SQL, especially in writing joins, window functions, common table expressions, and optimizing queries; experience with PostgreSQL is advantageous.
• Solid practical skills in Python for data analysis, including pandas, numpy, and Jupyter notebooks.
• Experience in BI and data visualization tools such as Power BI, Metabase, or Looker, with proven experience building dashboards from the ground up.
• Understanding of statistical fundamentals including distributions, correlations, and seasonal patterns.
• Effective communication skills in both Bulgarian and English adapted for technical and non-technical stakeholders.
• A curious and analytical mindset eager to uncover the underlying reasons behind data trends.

Preferred Qualifications

• Background in FMCG/retail domain knowledge like secondary sales, distributor management, or trade promotions.
• Experience in time-series analysis and demand forecasting methods such as exponential smoothing, ARIMA, and ensemble models.
• Familiarity with Git for version control and collaborative coding practices including versioned SQL and Python with code review.
• Knowledge of market data providers like Nielsen or GfK, including the ability to reconcile sell-in versus sell-out data.
• Exposure to dbt or equivalent data transformation technologies and a basic understanding of machine learning pipelines.

Initial 90 Days Expectations

• Within the first month, familiarize yourself with the data model and produce initial SQL and Python analyses ready for production.
• By 60 days, deliver a functional dashboard that is actively used by a team or client.
• By 90 days, independently conduct an analytical study that influences a product-related decision.

What OptimaSoft Offers

• Fully remote work environment allowing you to operate from any location globally.
• Flexible working hours to support work-life balance.
• Budget allocation for professional growth including learning and conference attendance.
• Modern technology stack free from legacy constraints.
• Generous paid leave exceeding statutory minimums.
• Direct interactions with company founders and significant opportunity for impact.

About OptimaSoft

OptimaSoft is a company dedicated to building an AI-native platform for the European FMCG industry. Their product integrates data analytics, routing, shelf management, and AI technology to serve the global FMCG market. The team is small, founder-led, and works 100% remotely, bringing authentic domain expertise and innovation to the market.