| Location | India, TN |
Individual will be responsible for working with large databases and develop presentations and insights for senior leadership reviews
We are seeking a highly skilled and analytical Business Intelligence & Data Analyst to manage end-to-end data workflows, from extraction and transformation to visualization and executive reporting. In this role, you will leverage data from Ford's Enterprise Data Platform, Google Cloud Platform (GCP), and various legacy systems to build robust data models, interactive dashboards, and high-quality management presentations
Note - Please apply with external profile.
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.
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.