Data Analytics and Reporting Analyst

Position: Data Analytics and Reporting Analyst

Role Overview

The ideal candidate will combine deep knowledge of finance operations (specifically Payables and SAP FICO) with technical proficiency in Power Platform (Power Apps, Power Automate), SQL, Azure, SharePoint, Excel Macros, MS Access database management and Python. This role will be instrumental in driving automation, analytics, and insights to improve financial reporting, compliance, and operational efficiency.

Key Responsibilities

• Providing Strategic, Analytic & Reporting support to Global Service Centers and Payables across regions.
• MIS reporting for Accounts Payable processes including vendor payments, ageing analysis, GR/IR and payment forecast reports and compliance metrics.
• Develop and deploy automated dashboards and reports using Power BI and SQL for internal stakeholders and auditors to bring some clarity to complex AP data.
• Automate finance workflows using Power Automate and Excel VBA/Macros think reconciliation, reminders, and reporting. Explore opportunities to automate the manual processes.
• Leverage SAP FICO for reporting, audit trails, and transaction analysis. Identify, analyze, and interpret trends or patterns in complex data sets. Transform data using Python and SQL for reporting.
• Manage data pipelines through Azure Data Services, integrating inputs from SAP, Excel, and cloud databases.
• Use Python for automation: bulk file processing, vendor statement reconciliation, and email/report workflows automation.
• Competent in Analysis & Judgment, Customer Relationship Management, BI tools & Microsoft Suite. Should have sufficient Procure to Pay knowledge. Partner with Procurement, Supply Chain, IT, and Treasury teams to ensure data consistency and reporting alignment.
• Manage, coach and develop team members
• Explore and implement continuous improvement with an owners mind-set.
• Accountable for managing the Supplier Payments database for entire organization and provide Strategic, Analytic & Reporting support to Global Service Centers and P2P across regions.

Key Requirements

Education & Experience

• Bachelors or Masters degree in Finance, Accounting, or a related field.
• 3-5 years of Power Platform experience (excluding Power BI)
• At least 1year hands-on Copilot Studio or conversational AI experience
• Can create the agents and has some expertise in prompt engineering
• Delivered at least 2 or more production automations or agents
• Strong knowledge of Power Automate, SharePoint, Dataverse, Connectors, APIs and security
• Ability to work directly with operations teams in Payables
• Evidence of testing, governance, deployment and run and maintenance support

Soft Skills

• Strong analytical mindset and attention to detail.
• Effective communication and ability to collaborate with cross-functional teams.
• Proactive problem-solver with a process improvement orientation.
• Ability to manage deadlines and prioritize in a fast-paced environment

Preferred Certifications (Optional but a plus)

• Microsoft Certified: Power Platform Fundamentals or Data Analyst Associate
• SAP FICO Certification
• Azure Data Fundamentals