Description
We are seeking a Retail Reporting - Deputy Manager to work with large databases and develop presentations and insights for senior leadership reviews.
Responsibilities
Data Engineering & Transformation
- Extract and manage large-scale structured and unstructured datasets from Ford's Enterprise Data Platform (EDP), SharePoint, legacy systems, and various relational databases.
- 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
- Design and develop dynamic, user-friendly digital reporting solutions and dashboards using Power BI, Qlik Sense, and MS Excel.
- 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.
- Create, replicate, and modify complex MS Excel-based templates utilizing advanced formulas and functions.
- Develop and maintain automated workflows using MS Power Automate to send scheduled reports, alerts, and notifications via Email and MS Teams.
Qualifications
- Proven experience in Data Analytics, Business Intelligence, or a similar data-centric role.
- Strong proficiency in data visualization tools (Power BI, Qlik Sense) and ETL/Data preparation tools (Alteryx, Power Query).
- Deep understanding of MS Excel (complex formulas, functions, templates) and PowerPoint (crafting professional management decks).
- Impeccable attention to detail with a strong commitment to data accuracy and maintaining corporate branding/formatting standards in all deliverables.
- Hands-on experience with MS Power Automate for workflow and notification automation.
- Experience managing SharePoint sites, shared drives, and user access controls.
- 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)
- Familiarity with Automotive Industry terminologies and KPIs, including Industry Segmentation, Volume, Market Share, Segment Share, and Competitor Analysis.
- Knowledge of Google Cloud Platform (GCP) and hands-on experience using BigQuery SQL.
- Foundational knowledge of Artificial Intelligence (AI) and Machine Learning (ML) concepts and their potential applications in data analytics and reporting.