• Full Time
  • Chennai

Website Ford

Automation and Data Analyst — Ford Motor Company

Company: Ford Motor Company
Team: Digital Transformation Team
Role Title: Automation and Data Analyst
Location: Chennai, Tamil Nadu, India
Work Mode: Full-Time
Experience Level: 3 to 5 Years of professional experience in data analytics, business process automation,and Microsoft Power Platform development
Educational Requirement: Bachelor’s degree in Computer Science, Information Technology, Information Systems, Data Analytics, Engineering, or a related field
Core Tool Stack: Python, Microsoft Power Platform (Power Automate, Power BI, Power Apps), Advanced Excel (VBA, Power Query, Pivot Tables), SQL, SharePoint Online, GitHub
Cloud, Web & AI Stack: Microsoft Azure Fundamentals, REST APIs & JSON, HTML/CSS/JavaScript,Generative AI Tools (Microsoft Copilot, GitHub Copilot, ChatGPT), Prompt Engineering

About Ford Motor Company & The Digital Transformation Team

Ford Motor Company is a global automotive and mobility leader continuously modernizing its enterprise operations through smart technology and data intelligence. Operating out of Chennai, Ford’s Digital Transformation team focuses on eliminating manual bottlenecks, re-engineering internal business workflows,and embedding data-driven decision-making across global business units using Python scripting, low-code Microsoft Power Platform tools, and Generative AI automation.

Role Overview

Ford Motor Company is recruiting a proactive, multi-skilled Automation and Data Analyst to join its Digital Transformation organization in Chennai.
This hybrid role sits at the intersection of business process automation, data analytics, and low-code application development. You will analyze operational workflows to identify automation opportunities, build automated scripts in Python and VBA, develop enterprise workflows and internal apps using Power Automate and Power Apps, engineer executive dashboards in Power BI, integrate REST APIs, and leverage modern AI tools to accelerate productivity across Windows and macOS environments.

Key Responsibilities

Business Process Automation & Low-Code Development

  • Workflow Automation: Analyze existing business processes to identify manual inefficiencies and build end-to-end automation solutions using Python, Microsoft Power Automate, VBA, and scripting tools.
  • Internal Application Engineering: Design, develop, and maintain custom internal business applications using Microsoft Power Apps and SharePoint Online.
  • System & API Integration: Connect disparate enterprise systems using REST APIs and JSON data payloads, maintaining clean version control via GitHub.

Data Analytics & Business Intelligence

  • Data Preparation & Validation: Collect, clean, transform, and validate structured datasets across Excel,CSV, JSON, and relational databases using SQL and Power Query.
  • BI Dashboarding: Build, optimize, and maintain interactive Power BI reports and executive dashboards to track operational efficiency and guide leadership decisions.

AI Adoption & Governance Documentation

  • AI Productivity Integration: Explore and embed Generative AI services (Microsoft Copilot, GitHub Copilot, ChatGPT) and prompt engineering techniques into daily automation and reporting workflows.
  • Stakeholder Alignment & SOPs: Partner with cross-functional business stakeholders to capture requirements and maintain comprehensive technical documentation and standard operating procedures (SOPs).

Candidate Qualifications & Requirements

Required Technical Skills & Experience

  • Experience: 3 to 5 years of hands-on experience combining data analytics, scripting automation, and Microsoft enterprise tools.
  • Education: Bachelor’s degree in Computer Science, Information Technology, Information Systems, Data Analytics, Engineering, or a related discipline.
  • Programming & Web Foundations:
    • Strong foundation in Python programming and task automation scripting.
    • Practical proficiency in VBA (Visual Basic for Applications), REST APIs, JSON, and foundational HTML, CSS, and JavaScript.
  • Microsoft Power Platform & M365: Hands-on expertise across Power BI, Power Automate, Power Apps, SharePoint Online, and advanced Microsoft Excel (Pivot Tables, Power Query, complex formulas).
  • Data, Cloud & Dev Tools: Solid SQL fundamentals, familiarity with Microsoft Azure and cloud concepts,and proficiency with GitHub (branching, commits, pull requests), VS Code, and Jupyter / Google Colabacross both Windows and macOS environments.
  • AI & Emerging Tech: Practical familiarity with AI/ML concepts, prompt engineering, and AI-assisted development tools.

Preferred Qualifications

  • Knowledge of Power BI DAX and Power Query (M Language) alongside Power Platform administration.
  • Familiarity with Azure Functions, Azure Logic Apps, Robotic Process Automation (RPA), and foundational CI/CD or DevOps workflows.

Role Summary

Attribute Details
Job Title Automation and Data Analyst
Company Ford Motor Company
Team Digital Transformation Team
Location Chennai, Tamil Nadu, India
Experience 3–5 Years
Primary Skill Stack Python, Power Automate, Power BI, Power Apps, Advanced Excel (VBA, Power Query), SQL
Cloud, Dev & AI Stack Microsoft Azure, REST APIs / JSON, GitHub, Microsoft Copilot, GitHub Copilot, Prompt Engineering
Core Impact Enterprise Process Automation, Low-Code App Delivery, Automated BI Reporting, AI Workflow Modernization
Upload your CV/resume or any other relevant file. Max. file size: 256 MB.
Maximum file size: 256 MB.