Performance Data Scientist

Job Details:

The role holder will play a vital role in translating the vast quantities of data held within our automotive businesses and translating this into visualizations and usable formats that drive decision making, action and over time predictability and automation in what we do. The role will pioneer our data future and work with a cutting edge team of likeminded individuals to set the direction of our business intelligence for years to come.

This role reports to the GM Operational Performance within the Operational Performance team. This team sits within the wider Business Operations function of Al Futtaim Automotive.
Rationalize the existing landscape of XLS reports, dashboards and ad hoc analysis to transform the business into a culture (and capability) of data quality, consistency and automation
Put in place control measures for data manipulation, ensuring the right level of customization potential and usability from data visualization without negatively impacting data quality standards and consistency.
Build dashboards and data visualization packages/reports in line with business requirements
Create, test and deploy Power BI scripts
Execute deep analysis and modelling of datasets to uncover new intelligence, utilizing AI and ML where suitable to improve the effectiveness of our operations
Build a data visualization portfolio that allows the business to run truly bottom up, predictive forecasting, taking historic data, market trends and 3rd party feeds to inform future planning and ordering

Establish set framework for data visualization across operations, ensuring all data visualization requests and activity is validated, backlogged and monitored for duplication and inconsistencies
Work with business stakeholders to clearly define business requirements before building any dashboards/visualization, ensuring clear, documented requirements are captured, prioritized into a delivery backlog and assessed against the value potential and duplication risk with existing/planned wider dashboards
Create a central PowerBI dataset and visualized dashboards to control, monitor and act upon critical KPIs across automotive operations, working hand in hand with the Managing Directors and GM Operational Performance & Planning to ensure the right metrics for scorecards across the business
Establish calculation mechanisms for league tabling and dealer to dealer performance comparisons across key operational metrics
Lead the implementation of best practices in relation to data visualization
Maintain the security posture for systems and applications in accordance with IT standards, Data Architect directives and industry standards
Own, design and communicate across business owner, developer, architect and database teams (including vendor mgmt. as required)
Deliver rapid prototypes to bring data visualization to life early and enable the refinement of requirements quickly and efficiently with the business
QA all APIs, connection feeds and underlying data pipeline feeds by routinely analysing and questioning our data (always on data cleansing). Depending on the data pipeline) intelligence visualization
Establish alert systems (by role and dashboard) to trigger action under the guidance of the Performance Growth Manager’s business requirements for branch/dealer level performance zones.
Develop and deploy API connections (in conjunction with our IT function and Data Architects) to integrate data visualization tools with action tracking tools in order to enable our business to move away from a reliance on XLS and PPT and move towards a culture and capability of running our meetings, activities and decision making directly off live (or near live

Skills:
Knowledge of SQL queries, Server Reporting Services (SSRS) and Server Integration Services (SSIS) desired
Knowledge in data visualization packages and libraries (Python, R, Javascript etc)
Minimum 5 years’ experience in Power BI
Power BI dashboard experience
Tableau experience (to support the management of a migration to Power BI)

About Team:
You will be working in a fast-paced and diverse environment, reporting directly to the GM – Operational Performance & Planning. This newly established function is responsible for creating and maintaining the highest operational standards across our business to create greater profitability for our business. Our remit is wide. Across the team, we work with central executive leadership and every Managing Director of our portfolio of automotive brands to deliver programmers and initiatives that have a direct impact on the experiences of our customers and our staff.
The culture within the team is dynamic and entrepreneurial. Across all of our team members we actively foster inquisitiveness, ideas and challenges to the status quo. We know that the operations of ‘traditional automotive’ is shifting and we want new joiners to make their mark and play a big role in how we achieve success in the coming years as part of a multi-billion AED global business. With this in mind, you do not need to have worked in automotive all of your career. We are much more focused on your talents, capabilities and motivation to roll up your sleeves and get things done.
If you think you are up for the challenge, can make a mark and see your ideas through to fruition, then you would be a perfect fit for the team and for our organization.

Education:
A business or technical university degree is preferred ideally in the subjects of Maths, Computer Science or statistics.
Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
Experienced in Power Query/M/DAX
Working knowledge of data visualization packages and libraries (Python, R, Javascript etc)
Impeccable data documentation skills (parameters, models, algorithms)
Knowledge to build multi-dimensional data models (in line with set data standards)
Experienced in working within Azure Cloud
Minimum Experience and Knowledge:
Minimum 5 years PowerBI experience in developing sophisticated data visualization
Experienced in Tableau dashboard creation and migration
Familiarity with other BI technologies (Qlik Sense etc) desirable