Automation & Data Analyst

Lincoln Motor Company; Chennai District; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Lincoln Motor Company is seeking an Automation & Data Analyst to join our Digital Transformation team in Chennai. The role blends programming, data analytics, and automation to streamline processes and enable data-driven decisions.

You will leverage Python, Microsoft Power Platform, and modern automation tools to automate tasks, build dashboards, and integrate data across systems. The ideal candidate has 3–5 years of relevant experience and a strong problem-solving mindset.

Qualifications

• Bachelor's degree in CS/IT/IS/Analytics or related field.
• Strong analytical and problem-solving skills.
• Good communication and collaboration abilities.
• Willingness to learn new technologies and automation tools.
• 3–5 years of experience with listed technical skills.

Responsibilities

• Analyze business processes and identify automation opportunities.
• Develop automation solutions using Python and Microsoft Power Platform.
• Create dashboards and data visualizations to support decisions.
• 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 stakeholders to understand requirements and deliver automation.
• Develop and maintain Power Apps applications for internal processes.
• Maintain documentation for automation solutions and SOPs.
• Work with APIs and integrate data between systems.
• Use GitHub for version control and collaboration.
• Work across Windows and macOS as required.
• Explore AI technologies to improve productivity.
• Familiarity with CI/CD and DevOps concepts.

Skills

Python programming

VBA

HTML/CSS/JavaScript basics

REST API basics

Data analysis

Power BI

Power Apps

Power Automate

SharePoint Online

SQL fundamentals

GitHub

Azure fundamentals

VS Code

Google Colab/Jupyter

AI tools (Copilot, ChatGPT)

CI/CD concepts

Education

Bachelor's degree in Computer Science, Information Technology, Information Systems, Data Analytics, Engineering, or a related field

Tools

GitHub

Visual Studio Code

Google Colab/Jupyter

Power BI

Power Apps

Power Automate

SharePoint Online

Azure (functions or logic apps)

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