Automation & Data Analyst

Ford; Chennai District; On-site; INR 800,000 - 1,100,000; Full time

Job summary

Ford seeks an Automation & Data Analyst to join its Digital Transformation team in India. You will apply Python and Microsoft Power Platform to automate tasks, streamline processes, and enable data-driven decisions. You will build Power BI dashboards, automate reporting, and integrate data across systems.

You will collaborate with stakeholders, maintain documentation, and explore AI tools to boost productivity while learning modern automation technologies.

Qualifications

• Bachelor's degree in Computer Science, IT, Information Systems, Data Analytics, Engineering, or related field.
• Strong analytical and problem-solving skills.
• Good communication and collaboration abilities.
• Willingness to learn new technologies and automation tools.
• 3 to 5 yrs of Experience on the below Technical Skills

Responsibilities

• Analyze business processes and identify automation opportunities.
• Develop and maintain automation solutions using Python and Microsoft Power Platform.
• Create dashboards, reports, and data visualizations to support business decision-making.
• Automate repetitive tasks using Python, Power Automate, VBA, and scripting tools.
• Build and optimize Power BI reports and dashboards.
• Collect, clean, transform, and validate data from multiple sources.
• Collaborate with business stakeholders to understand requirements and deliver automation solutions.
• Develop and maintain Power Apps applications for internal business processes.
• Maintain documentation for automation solutions, workflows, and standard operating procedures.
• Work with APIs and integrate data between different business systems.
• Use GitHub for version control and collaboration.
• Work with both Windows and macOS environments as required.
• Explore and adopt AI technologies to improve productivity and automate business processes.

Skills

Python

VBA

HTML/CSS/JS

REST APIs

SQL

Power Platform

Power BI

Power Apps

Power Automate

SharePoint Online

Azure fundamentals

GitHub

VS Code

Colab/Jupyter

AI tools

Prompt engineering

RPA

CI/CD concepts

Documentation

Education

Bachelor's degree in Computer Science/IT/IS/Data Analytics/Engineering

Tools

Excel

Power BI

Power Apps

Power Automate

SharePoint Online

Microsoft 365

GitHub

VS Code

Google Colab/Jupyter

Job description

We are looking for an Automation & Data Analyst to join our Digital Transformation team. The ideal candidate should have a strong analytical mindset and a passion for using technology to automate repetitive tasks, improve operational efficiency, and support data-driven decision-making.

This role combines programming, data analytics, business process automation, and Microsoft technologies. The candidate does not need to be an expert software developer but should be comfortable learning and applying modern tools to solve business problems.

The successful candidate will leverage Python, Microsoft Power Platform, and modern automation technologies to streamline business processes, eliminate manual work, improve reporting, and support digital transformation initiatives across the organization. The role requires a balance of technical expertise, analytical thinking, and a continuous learning mindset.

• Analyze business processes and identify automation opportunities.
• Develop and maintain automation solutions using Python and Microsoft Power Platform.
• Create dashboards, reports, and data visualizations to support business decision-making.
• Automate repetitive tasks using Python, Power Automate, VBA, and scripting tools.
• Build and optimize Power BI reports and dashboards.
• Collect, clean, transform, and validate data from multiple sources.
• Collaborate with business stakeholders to understand requirements and deliver automation solutions.
• Develop and maintain Power Apps applications for internal business processes.
• Maintain documentation for automation solutions, workflows, and standard operating procedures.
• Work with APIs and integrate data between different business systems.
• Use GitHub for version control and collaboration.
• Work with both Windows and macOS environments as required.
• Explore and adopt AI technologies to improve productivity and automate business processes.

• Bachelor's degree in Computer Science, Information Technology, Information Systems, Data Analytics, Engineering, or a related field.
• Strong analytical and problem-solving skills.
• Good communication and collaboration abilities.
• Willingness to learn new technologies and automation tools.
• 3 to 5yrs of Experience on the below Technical Skills

Technical Skills

Programming & Automation

• Strong foundation in Python programming
• VBA (Visual Basic for Applications)
• HTML, CSS, and basic JavaScript concepts
• Scripting and task automation
• REST API basics and JSON data handling

Microsoft Technologies

• Microsoft Excel (advanced formulas, Pivot Tables, Power Query)
• Microsoft Power BI
• Microsoft Power Apps
• Microsoft Power Automate
• SharePoint Online
• Microsoft 365 applications

Data & Databases

• SQL fundamentals
• Data cleaning, transformation, and validation
• Data visualization and reporting
• Experience working with Excel, CSV, JSON, and other business data formats

Cloud & Development Tools

• Microsoft Azure fundamentals
• Cloud computing concepts
• GitHub (repositories, branching, commits, pull requests)
• Visual Studio Code
• Google Colab or Jupyter Notebook

AI & Emerging Technologies

• Basic understanding of Artificial Intelligence and Machine Learning concepts
• Experience using AI tools (such as Microsoft Copilot, ChatGPT, or GitHub Copilot) to improve productivity
• Prompt engineering fundamentals
• Understanding of automation using AI services

Preferred Skills

• Experience with Power Platform administration
• Knowledge of Power BI DAX and Power Query (M Language)
• Familiarity with Azure Functions or Logic Apps
• Experience integrating APIs and third-party services
• Understanding of Robotic Process Automation (RPA)
• Experience building automation workflows for business processes
• Basic knowledge of CI/CD and DevOps concepts

Personal Attributes

• Curious and eager to learn emerging technologies
• Strong attention to detail
• Self-motivated and proactive
• Excellent problem-solving skills
• Ability to prioritize multiple tasks
• Team player with a continuous improvement mindset
• Good documentation and organizational skills