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 BI, 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/Macrosthink 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. * 6–10 years of relevant experience in Finance MIS or AP analytics roles. * Strong working knowledge of SAP FICO – especially AP-related T-codes and tables. * Knowledge of ERP system, statistics and experience using statistical packages for analyzing large datasets (Excel, SPSS, SAS etc) is preferable. Technical Skills: * Strong Knowledge on reporting packages [Business objects] * Advanced Excel with hands-on experience in VBA/macros. * Proficiency in Power BI, Power Automate, and Power Apps. * Strong SQL scripting and experience in working with relational databases. * Exposure to Microsoft Azure (Data Factory, Synapse, or Logic Apps) is highly desirable. * Experience in data modeling, cleansing, and performance tuning for large datasets. * Python for data analysis and automation (e.g., pandas, matplotlib, openpyxl) 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 *