Analyst - Supply Chain Analytics, Automation & AI

Ford; Chennai District; On-site; INR 2,500,000 - 4,200,000; Full time

Job summary

Ford is seeking an experienced Analyst in Supply Chain Analytics to transform procurement and operations data into actionable insights. You will build interactive dashboards with Power BI, Looker, and Dash (Python), and automate workflows using Power Automate and Power Query.

You will also develop AI agents using ATK/Vertex AI and Python scripting to support global buyers and operations. The role requires collaboration across global teams and a passion for data-driven problem solving.

Qualifications

• Bachelor's degree in Engineering, Computer Science, Data Analytics, or AI.
• 1+ years hands-on experience with Power BI, Looker, or Dash (Python).
• Strong SQL and Google BigQuery experience.
• Python scripting for data science and AI agent customization.
• Generative AI exposure using ATK/Vertex AI.

Responsibilities

• Data Analytics BI: analyze procurement data to identify cost-saving opportunities.
• Dashboard development using Power BI, Looker, and Dash (Python).
• Report consolidation from multiple sources for daily summaries and executive decks.
• Write efficient SQL queries to extract and transform large datasets in Google BigQuery.

Skills

Data Visualization

SQL

Python

Generative AI

Power BI

Looker

Dash (Python)

Power Apps

Power Automate

Power Query

Excel

Education

Bachelor's degree in Engineering, Computer Science, Data Analytics, AI

Tools

Power Apps

Power Automate

Power Query

Dash (Python)

Looker

Google BigQuery

Vertex AI

ATK

Job description

As an Analyst in the Supply Chain Analytics CoE, you will bridge the gap between supply chain operations and cutting-edge digital technology. You will be responsible for transforming raw procurement and operational data into actionable insights, automating repetitive workflows, and building intelligent AI agents to support commodity buyers and global operations. This role is ideal for a tech-savvy professional with 13 years of experience who is passionate about data visualization, low-code automation, and the practical application of generative AI in a global supply chain environment.

1. Data Analytics Business Intelligence

• Insight Generation: Analyse procurement data, including tool costs, part costs, and supplier performance metrics, to identify cost-saving and efficiency opportunities.
• Dashboard Development: Design, build, and maintain highly interactive, user-friendly dashboards using Power BI, Google Looker, and Dash (Python).
• Reporting: Consolidate data from multiple sources to prepare daily operational summaries (e.g., "Night Letters") and executive-level PowerPoint presentations.
• Database Querying: Write efficient SQL Google queries to extract and transform large datasets within Google BigQuery (GCP).

2. Workflow Automation App Development

• Process Automation: Identify bottlenecks in supply chain workflows and design end-to-end automated solutions using Power Automate and Power Query.
• Custom Applications: Build lightweight, user-friendly internal applications using Power Apps to streamline data collection and buyer workflows.
• Legacy Modernization: Convert manual processes and legacy Excel macros into robust, cloud-based automated pipelines.

3. AI Agent Development Innovation

• AI Agent Creation: Build, test, and deploy conversational and task-oriented AI agents using the Google Agent Development Toolkit (ATK / Vertex AI Agent Builder) to assist buyers with query resolution and data retrieval.
• Python Scripting: Write clean Python code to support data science initiatives, API integrations, and AI agent customization.
• Continuous Improvement: Stay updated on emerging AI/ML trends and proactively propose innovative digital solutions to the supply chain team.

4. Stakeholder Collaboration Operations

• Buyer Supplier Liaison: Collaborate daily with global commodity buyers and operations teams to understand their pain points and deliver swift, data-driven solutions.
• Cross-Functional Networking: Build strong relationships across global teams, facilitating meetings and maintaining team versatility/skills matrices.

Education

• Bachelors degree in Engineering, Computer Science, Data Analytics, Artificial Intelligence.

Technical Requirements

• Data Visualization: 1+ years of hands-on experience with Power BI, Google Looker, or Dash (Python).
• M365 Suite: Proficiency in Power Apps, Power Automate, and Power Query. Advanced knowledge of MS Excel (formulas, pivot tables, basic VBA/Macros).
• Cloud Querying: Solid understanding of SQL and experience querying databases in Google BigQuery (GCP).
• Programming AI: Hands-on exposure to Python and a strong interest/foundational experience in Generative AI, specifically using the Google Agent Development Toolkit (ATK) or similar LLM orchestration tools.

Professional Soft Skills

• Problem-Solving: Strong analytical and troubleshooting skills; ability to make data-backed decisions.
• Communication: Excellent written and verbal English communication skills, with the ability to present complex technical concepts to non-technical stakeholders.
• Collaboration: A proactive team player comfortable working in a multicultural, global environment.
• Time Management: Highly organized with the ability to manage multiple tasks and respond swiftly to urgent business needs.

Flexible to work in shifts.