Analyzes business processes and identifies automation opportunities using Python, Microsoft Power Platform, VBA, and scripting tools. Builds Power BI dashboards, reports, and visualizations; cleans and validates data; integrates business systems through APIs; and develops Power Apps solutions. The role collaborates with stakeholders, documents workflows, maintains automation solutions, uses GitHub for version control, and explores AI technologies to improve productivity and operational efficiency.
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.
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.
Qualifications
- 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
Similar Jobs at Ford Motor Company
Automotive
Supports SAP MM procurement and inventory processes, including master data maintenance, requisition-to-purchase-order workflows, goods receipts, invoice verification, stock movements, reporting, issue resolution, testing, documentation, and user training. Collaborates with business users and IT teams to improve operational efficiency, ensure data accuracy and policy compliance, and participate in SAP enhancements and continuous improvement initiatives.
Top Skills:
SAPSap Mm
Automotive
Develop and support Java/J2EE applications using GCP, Spring Boot, microservices, REST APIs, and related technologies. Responsibilities include application development, functional testing, production support, system maintenance, requirements analysis, security and IT process compliance, and collaboration with business and technical stakeholders. The role also supports Agile software development lifecycle activities and may work with CI/CD, code quality, and security tools.
Top Skills:
CheckmarxCi/CdGCPGradleJ2EeJavaJdbcJunitMicroservicesOpenshiftPostgresPostmanRest ApisSonarqubeSpring BootSpring MvcSpring SecurityWeb Services
Automotive
Manage and update European online product information, pricing, promotions, images, and showroom inventory data. Coordinate catalog enablement, preview approvals, production publishing, and post-deployment verification with market contacts, IT teams, and operational stakeholders. Ensure pricing accuracy, customer savings validation, timely deliverables, audit support, and service-level compliance. Handle ad hoc requests and contribute to process improvements through automation tools.
Top Skills:
ElasticNukleus
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
