Retail Reporting - Deputy Manager

Data Engineering & Transformation

• Data Extraction: Extract and manage large-scale structured and unstructured datasets from Ford’s Enterprise Data Platform (EDP), SharePoint, legacy systems, and various relational databases.

• ETL & Data Modeling: Clean, transform, and standardize raw data to create robust, scalable data models using Power Query, Alteryx, advanced MS Excel, and other ETL tools.

Reporting, Visualization & Presentations

• Dashboard Development: Design and develop dynamic, user-friendly digital reporting solutions and dashboards using Power BI, Qlik Sense, and MS Excel.

• Management Presentations: Prepare high-quality slide decks and executive presentations for leadership, demonstrating meticulous attention to detail, strict adherence to corporate formatting guidelines, and absolute data accuracy.

• Excel Mastery: Create, replicate, and modify complex MS Excel-based templates utilizing advanced formulas and functions.

• Workflow Automation: Develop and maintain automated workflows using MS Power Automate to send scheduled reports, alerts, and notifications via Email and MS Teams.

Experience: Proven experience in Data Analytics, Business Intelligence, or a similar data-centric role.

• Technical Tools: Strong proficiency in data visualization tools (Power BI, Qlik Sense) and ETL/Data preparation tools (Alteryx, Power Query).

• Advanced Excel & PowerPoint: Deep understanding of MS Excel (complex formulas, functions, templates) and PowerPoint (crafting professional management decks).

• Attention to Detail: Impeccable attention to detail with a strong commitment to data accuracy and maintaining corporate branding/formatting standards in all deliverables.

• Automation: Hands-on experience with MS Power Automate for workflow and notification automation.

• Platform Administration: Experience managing SharePoint sites, shared drives, and user access controls.

• Soft Skills: Strong analytical problem-solving skills, and the ability to collaborate effectively with end-users to gather requirements and present complex data clearly to leadership.

Preferred Qualifications (Added Advantage):

• Industry Knowledge: Familiarity with Automotive Industry terminologies and KPIs, including Industry Segmentation, Volume, Market Share, Segment Share, and Competitor Analysis.

• Cloud & SQL: Knowledge of Google Cloud Platform (GCP) and hands-on experience using BigQuery SQL.

• AI & Machine Learning: Foundational knowledge of Artificial Intelligence (AI) and Machine Learning (ML) concepts and their potential applications in data analytics and reporting.