RetSci logo

Business Consultant Intern- PFE 2027

Hiring from
Tunisia
Work type
Hybrid
Posted

623,600 remote jobs, straight from company career pages

100% free · New jobs every minute

Show job description

About RetSci:

We are passionate about making science easy and accessible to retailers, helping them get more value from people, data, and systems.

We bring together expertise in retail, science, and scalable technologies to automate and enhance the quality of decision-making through software and consulting services.

Our retail knowledge and experience help us apply a wide range of statistical and quantitative analysis in practical and valuable ways. And our technical skills ensure we can navigate the largest and most complex data environments with the most relevant and up-to-date tools.

Join us, be passionate about your work, learn and have fun! www.retsci.com


Our Locations:

  • Atlanta, GA, US
  • Tunis, Tunisia
  • Sfax, Tunisia
  • Paris, France
  • Porto, Portugal

This role is available in both our Tunis and Sfax offices.


Please submit your resume in English.


Topic 1 : Order Proposal Traceback Tool for RELEX Replenishment



About the project

During UAT and hypercare, consultants often spend significant time answering questions such as: “Why did RELEX propose this quantity?” or investigating mismatches caused by data issues or unexpected parameter settings.

Today, this analysis is largely done manually, case by case, making it time-consuming and difficult to explain consistently to clients.

As part of this internship, you will build a reusable tool that reconstructs a RELEX order proposal from its key inputs — including forecast, safety stock, stock position, incoming deliveries, order schedule, lead time, MOQ, pack rounding, shelf life, presentation stock and promotions.

The tool will compare the recomputed proposal with the quantity produced by RELEX and identify where the calculations differ and why.

You will work directly with the RELEX engine, configurations and exports, while using Python to analyse and reproduce the calculation logic.

Objectives

  • Reduce the time consultants spend investigating replenishment issues.
  • Provide consistent and transparent explanations to clients.
  • Document the RELEX order calculation process.
  • Create reusable training material for new consultants.

Key deliverables

  • Documented RELEX order calculation flow, reviewed by a senior consultant.
  • Python-based recomputation tool, with an Excel version of the core logic.
  • Mismatch report comparing RELEX results with the recomputed proposal.
  • Identification of the first diverging step and classification of the root cause.
  • Validation of the tool using data from a second project.
  • Consultant-friendly packaged version requiring no coding to run.
  • Documentation, configuration file and sample run.
  • "Engine behaviours" log documenting non-obvious RELEX behaviours discovered during the project.
  • Final demo and presentation of results and recommendations.

Optional AI component

As a stretch goal, you may develop a plain-language explanation layer using Claude Project or Claude Code to explain the tool's results based on the documented calculation flow.

Required skills

  • Python, particularly pandas.
  • Basic supply chain concepts such as forecasting, safety stock, lead time and order quantities.
  • Strong analytical mindset and attention to detail.
  • Clear written and spoken English.
  • Good presentation skills.

Nice to have

  • Knowledge of retail or supply chain processes.
  • Familiarity with replenishment, promotions or shelf-life concepts.
  • Curiosity about using AI tools in day-to-day work.


Topic 2: Automated Data Validation and Quality Framework for Retail Integrations



About the project

Retail implementation projects depend heavily on client data such as product hierarchies, locations, sales history and inventory. Today, validating this data is often a manual and time-consuming process, with issues sometimes being discovered late in the implementation.

In this internship, you will build a reusable data validation and quality framework using Python and SQL.

The tool will profile incoming client data, validate it against predefined interface specifications, identify common data quality issues and generate a clear quality report that consultants can share directly with client IT teams.

Objectives

  • Reduce the manual effort required for data validation during implementations.
  • Detect data quality issues earlier in the project lifecycle.
  • Standardise the way consultants validate and communicate data issues.
  • Make data requirements clearer for clients from the beginning of an implementation.

Key deliverables

  • Catalogue of validation rules covering product, location, sales and inventory data.
  • Configurable Python/SQL validation engine where rules and thresholds can be modified without changing the code.
  • Data profiling covering completeness, uniqueness, validity, consistency, timeliness, date gaps and outliers.
  • Readable quality report with a summary scorecard and detailed problematic records.
  • Testing using public and synthetic datasets containing known issues.
  • Analysis of detection precision and recall.
  • Consultant-friendly documentation and user guide.
  • Final demo and presentation of results and recommendations.

Required skills

  • Python, particularly pandas.
  • SQL.
  • Data analysis and data profiling.
  • Strong attention to detail.
  • Clear written and spoken English.
  • Good presentation skills.

Nice to have

  • PL/SQL.
  • Knowledge of retail data concepts such as product hierarchies, locations, sales and inventory.
  • Familiarity with data quality tools such as Great Expectations or Pandera.
  • Experience with dashboards or reporting tools such as Power BI or Streamlit.
  • Databricks or PySpark.
  • Git/GitHub.
  • Experience using AI coding assistants such as Claude Code.


Topic 3: AI-Powered Support Assistant for Oracle Retail Planning Solutions


About the project

Oracle Retail Planning solutions can be complex, and clients often need support understanding how to perform tasks, interpret results or troubleshoot issues.

In this internship, you will design and build a Retrieval-Augmented Generation (RAG) AI assistant that helps users understand and work with Oracle Retail Planning solutions built on RPAS.

The project will initially focus on Assortment Planning, with an architecture designed to extend later to Merchandise Financial Planning (MFP), Item Planning (IP) and other RPAS-based solutions.

The assistant should be able to:

  • Guide users through common tasks in the solution.
  • Explain concepts such as workbooks, measures, rules and scores.
  • Read and explain the client's own RPAS configuration files.
  • Suggest possible causes and next steps for common issues.
  • Provide answers based on trusted sources and cite those sources.
  • Escalate to a human consultant when it is not confident in its answer.

The target is to correctly answer at least 70% of a benchmark of real user questions, with supporting sources.

Key responsibilities

Working closely with RetSci's Oracle Retail consultants, you will:

  • Learn the fundamentals of Oracle Retail Planning and RPAS.
  • Collect and organise knowledge from user guides, training material, FAQs, solved support cases and solution configurations.
  • Build a benchmark of real user questions and expected answers.
  • Design the RAG architecture covering indexing, retrieval, answer generation and escalation.
  • Develop a module capable of reading RPAS configuration files (XML) and explaining measures, rules and workbooks.
  • Build a simple chat interface.
  • Evaluate the assistant against the benchmark and iteratively improve its accuracy.
  • Ensure that data confidentiality requirements are respected.
  • Document the solution and present the results to the team.

Required skills

  • Python.
  • Data analysis.
  • Familiarity with AI tools, particularly Claude.
  • Clear written and spoken English.
  • Good presentation skills.

Nice to have

  • Knowledge of Oracle Retail or RPAS.
  • Experience with RAG or LLM-based applications.
  • XML knowledge.
  • Interest in AI and enterprise software.
  • Familiarity with knowledge bases, document retrieval or chatbot development.

Similar jobs

Apply for this job100% free