Data analytics and automation

we are building a masterdata excel
This will contain
all product data
margin and financials
Forecasting per channel
freight
stock realtime and projection
sales realtime and projection

This to create a full liquidity and forecast online sheet
We have 9 brands with over 800 items so it will be a lot data entry and we will try to create as much automation as possible.
But also to have it flexible to add new items when needed.

What you need
-Good computer with 2 screens
-Amazing excel skills and knowhow of automations
-Worked building liquidity schedules before
-Worked with supply chain/data entry before

We would like a logical thinker who can solve with us this task.
We set out the goal to finish this project within 1month.
After this we would like to offer a part time job maintaining and helping with data entry.
Also strategising on what data could be utilized better or what calculations could be made better.

We are an online seller from the netherlands and if you would like to join our team

Questions:

What is master data, and why is it important for a business?

How do you ensure data accuracy and consistency across multiple systems?

Can you describe your experience working with liquidity calculations?

What tools or software have you used to manage master data and perform financial calculations?

How comfortable are you with advanced Excel functions (e.g., VLOOKUP, INDEX-MATCH, Pivot Tables, Macros)?

Can you describe a time when you used Excel to solve a complex data or financial problem?

How would you approach creating a cash flow forecast in Excel?

How would you handle conflicting data from different departments?

If you notice a discrepancy in a financial report, how would you investigate and resolve it?

Imagine you’re asked to prepare a liquidity report for the next quarter, but key inputs are delayed. What would you do?

How do you ensure data integrity when working with large datasets?
Describe a time when you identified and corrected a critical error in a report.

Explain the difference between cash flow and profit.

How would you prioritize payments during a liquidity crunch?

Can you explain how a liquidity calculation affects business decision-making?
How are you doing today

How would you communicate complex financial data to a non-financial audience?

Can you describe a situation where you worked with multiple teams to resolve a data issue?

Which master data management tools are you experienced with (e.g., SAP, Oracle, Salesforce)?

What financial modeling tools or software have you used besides Excel?

How do you automate repetitive data or financial tasks?

Please answer all these questions dully to be taken to the interview process where we will show you our current cashflow sheet and the setup of the new one and we will ask how would you calculate:
Liquidity ratio
Projected cash flow for the next 3 months