Job Summary
We are looking for an AI Solutions Analyst to support the Process Excellence and Intelligence team in building AI agents, automations, and reporting solutions that reduce manual effort across FPA, Sales Compensation, Power BI, Salesforce, and recurring operational processes.
The role will focus on identifying repetitive manual activities, converting them into AI-assisted or fully automated workflows, and building secure, scalable solutions using Microsoft Copilot Studio, Chat GPT, Power Platform, Python, Excel automation, Power BI, Salesforce, and related tools.
Key Responsibilities
- Build AI agents for recurring business processes.
- Automate manual FPA and Sales Compensation tasks using Python, Power Automate, Excel macros, Office Scripts, and APIs.
- Create agents that can answer questions from SharePoint files, Excel trackers, policy documents, process SOPs, and reporting repositories.
- Develop workflows for recurring reports, stakeholder reminders, data validation, approval routing, and exception tracking.
- Integrate agents and automations with Excel, Power BI, SharePoint, Outlook, Teams, Salesforce, and other business systems.
- Build validation scripts for sales compensation calculations, quota attainment checks, payout exception checks, and data reconciliation.
- Support Power BI and Salesforce report enhancement by automating data preparation and issue tracking.
- Design human-in-the-loop approvals for sensitive outputs such as compensation calculations, financial commentary, or stakeholder communications.
- Document processes, automation logic, data lineage, controls, and support procedures.
- Track automation benefits including manual hours saved, error reduction, cycle-time improvement, and adoption.
Required Skills
- 4 to 8 years of relevant professional experience in the respective field.
- Hands-on experience with Microsoft Copilot Studio, Power Automate, Power Apps, or Power Platform.
- Strong Python skills, especially Pandas, openpyxl, Excel file handling, data validation, and automation.
- Strong Excel skills including formulas, Power Query, macros/VBA, and data modelling.
- Experience with APIs, JSON, REST services, and connectors.
- Experience working with Power BI datasets, reports, refreshes, or dataflows.
- Understanding of Salesforce data objects, reports, dashboards, or integrations.
- Strong knowledge of prompt engineering and AI output validation.
- Ability to translate business requirements into automation workflows.
- Good documentation and stakeholder communication skills.
Preferred Skills
- Experience with finance, FPA, sales operations, or sales compensation processes.
- Knowledge of Microsoft Graph API.
- Experience with Dataverse or SQL.
- Familiarity with Azure AI, Azure Functions, Logic Apps, or Azure OpenAI.
- Exposure to RPA or UI automation.
- Understanding of governance, DLP, security roles, and access controls.
- Data Science, Statistics knowledge will be added advantage.