UAE National- Data yst - Al-Futtaim

Job Requisition ID: 163578

Established in the 1930s as a trading business AlFuttaim Group today is one of the most diversified and progressive privately held regional businesses headquartered in Dubai United Arab Emirates. Structured into five operating divisions; automotive financial services real estate retail and healthcare; employing more than 35000 employees across more than 20 countries in the Middle East Asia and Africa AlFuttaim Group partners with over 200 of the worlds most admired and innovative brands. AlFuttaim Groups entrepreneurship and relentless customer focus enables the organization to continue to grow and expand; responding to the changing needs of our customers within the societies in which we operate.

By upholding our values of respect excellence collaboration and integrity; AlFuttaim Group continues to enrich the lives and aspirations of our customers each and every day

Overview of the role:

This role is for a Data Analyst that is responsible for developing a standardized suite of business reports in the functional area of Collections across the entire Automotive organisation (UAE and Overseas).

In this role the incumbent would manage and continually develop the reports on Credit Risk and Collections target achievements and would assist in validating the incentives to be paid to the collectors. This would entail obtaining data from multiple geographies reviewing the data obtained identify and rectify inaccuracies preparing reports in Excel Power BI and PowerPoint Creation of dashboards in Power BI Reports Visualization and Advanced Analytics models.

• Delivery of the daily weekly and monthly collection reports/ dashboard that drills down to individual entity level
• Weekly Run Rate comparisons to business leaders
• Develop monthly target achievement dashboard
• To organize monthly workshops with business to review reports and implement suggested improvements.
• Customer demographics and profiling
• Customer Segmentation
• Trend analysis
• Preparation of monthly reports and presentation for management
• SWOT and GAP analysis
• Collection or Settlement Campaign Evaluation
• Root cause analysis and Insights.
• Continually develop Credit Risk and Collection Insights
• Work with Brands / Businesses on the adoption and usage of the platform
• Liaise with business and IT for follow ups
• Initiate and facilitate change request workshops
• Update SOPs to reflect system and process changes
• Manage system clean up initiatives
• Develop Standard Operating Procedures

• Report on data integrity including analysis of issues and opportunities
• Audit actions investigated and a documented plan developed to rectify

Required Skills to be successfu:

Preferred Experience in Microsoft Power Automate and other Microsoft tools like Lists To Do SharePoint

Graduate In Computer science or information technology.

Behavioural Competencies: Good Communication skills Team Player Enthusiastic Hard Working and Adaptable

What equips you for the role:

Minimum Qualifications and Knowledge: Advanced Excel Skills including knowledge of Pivot tables Power Pivot and Power Query Complex Formulae (Xlookup XIRR NPV FILTER) and ability to develop advanced Excel Macros.
Advance knowledge of Microsoft Power BI

About AlFuttaim Automotive
A major division of the UAEbased AlFuttaim Group of companies AlFuttaim Automotive is an industry leader with presence in 10 countries across the Middle East Asia and Africa.
Our core business activities at AlFuttaim Automotive include distribution manufacturing leasing and aftersales and we are firmly established as the regional representative of some of the worlds most iconic automotive brands: Toyota Lexus Honda Jeep Chrysler Dodge Volvo and RAM.
We are driven by a customercentric approach constantly pushing the boundaries on innovation quality standards and valueadded service across our vast universe of customers right from motoring enthusiasts to fleet operators to contractors. Our mission is to become the leader in custommade mobility solutions by delivering nothing less than worldclass omnichannel experiences.
We channel our local expertise and global trust to deliver one of the most comprehensive portfolios of mobility products and solutions from passenger cars to SUVs electric vehicles to highperformance motorbikes commercial vehicles to industrial & construction equipment.
What keeps the company moving forward is a 9000member strong team with inspiring possibilities for growth throughout the career path. This is AlFuttaim Automotive and we empower talent to move forward.