VIE _ Business Analyst

Job Description

Integrated in the Financial Planning Analysis team to secure deep sales performance analysis, the main missions a s a Business Analyst will be : Assist business teams to analyze data using in data analytics and prepare dashboards using dashboarding tools. Design and automation of Power BI dashboards for performance monitoring and reporting (monthly activity reports, daily KPI monitoring, etc.). Development of a control and margin tracking tool, as well as a system for verifying the compliance of issued credits, via Power BI and ETL queries (SAP BO). Creation of a multi data collection and reporting tool for Auto LPG daily activity follow-up, with daily alerts and promotion evaluation. Creation of inventory tracking tool to facilitate end of the month decision taking and quarterly WCR monitoring. Prepare periodic forecasts to estimate the month end position on above parameters. Enable tools to conduct variance analysis, prepare analysis on balance sheet, cash flow, monthly working capital, Head count, ROU, Capex reports, Service stations, Monthly RES1 for management consumption. Prepare analytical dashboards for key business indicators such as turnover/volumes/Gross Margins, by product segment, production variable costs with its breaks up and analysis, fixed costs and net operating income by business segments. Enable input and tracking into a dashboard by other functions to have one entire picture of the affiliates KPIs with business and support functions. Prepare excel or other tools to provide business heads with tools to steer the business depending on results expected. Compile annual metrics for submission to MS APME eg. Market size, Head count, Inflation rates etc. and the above such that it is automated and presenting reports as required for piloting business and reporting to APME. Enable automation for Annual Budgets, Long Term Plans and Annual Financing plan workings and summaries and its analysis. Enable through tools to issue projected PL for quarterly and annual advance tax workings by Tax department. Enable reports that can be converted into graphs for PPower Points for senior management reporting. Eligibility to the visa for a VIE in India : Candidates must present a master / Engineering diploma obtained LESS THAN 1 YEAR AGO.