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
Skills Required
- Bachelor's degree in Computer Science, Information Technology, Information Systems, Data Analytics, Engineering, or a related field
- 3 to 5 years of experience with the listed technical skills
- Strong analytical and problem-solving skills
- Strong foundation in Python programming
- Experience with VBA, scripting, and task automation
- Knowledge of HTML, CSS, and basic JavaScript
- Knowledge of REST APIs and JSON data handling
- Experience with Microsoft Excel, including advanced formulas, Pivot Tables, and Power Query
- Experience with Microsoft Power BI, Power Apps, and Power Automate
- SQL fundamentals and data cleaning, transformation, validation, visualization, and reporting
- Experience working with Excel, CSV, JSON, and other business data formats
- Understanding of Microsoft Azure and cloud computing concepts
- Experience using GitHub repositories, branching, commits, and pull requests
- Basic understanding of artificial intelligence and machine learning concepts
- Experience using AI productivity tools such as Microsoft Copilot, ChatGPT, or GitHub Copilot
- 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
- Basic knowledge of CI/CD and DevOps concepts
- Good communication and collaboration abilities
- Willingness to learn new technologies and automation tools
Ford Motor Company Compensation & Benefits Highlights
-
Healthcare Strength — Eligible employees can access medical, dental, and prescription coverage starting on the first day, with some zero-cost plan options and free mental health support. Benefits materials highlight comprehensive healthcare as a core pillar.
-
Retirement Support — Employees can enroll in a 401(k)-style plan from day one, and some salaried plans include a company match of $0.90 per dollar on the first 5% contributed. Official summaries also describe financial-planning support.
-
Parental & Family Support — The package includes paid parental leave, fertility, surrogacy, and adoption benefits, plus a ramp-up program for new parents returning to work. Flexible family-care days and other time-off options support caregiving needs.
Ford Motor Company Insights
What We Do
Ford is a global company with shared ideals and a deep sense of family. From our earliest days as a pioneer of modern transportation, we have sought to make the world a better place – one that benefits lives, communities and the planet. We are here to provide the means for every person to move and pursue their dreams, serving as a bridge between personal freedom and the future of mobility. In that pursuit, our 186,000 employees around the world help to set the pace of innovation every day.
Ford Motor Company Offices
OnSite Workspace
