Senior Data Analyst

Role: Senior Data Analyst

Location: Bangalore, Hyderabad, Pune

We are looking for a Data Analyst with strong ERP and Order-to-Cash (O2C) domain experience to analyze business and operational data, identify trends and process gaps, and provide actionable insights to improve O2C performance. The ideal candidate should have hands-on experience working with ERP systems, O2C processes, data analysis, reporting, and business intelligence tools.

Key Responsibilities

• Analyze data across the Order-to-Cash (O2C) lifecycle, including order management, order fulfillment, invoicing, billing, accounts receivable, collections, and cash application.
• Extract, transform, validate, and analyze data from ERP systems and other business applications.
• Develop and maintain dashboards, reports, and KPIs to monitor O2C performance.
• Identify process bottlenecks, data quality issues, anomalies, and opportunities for process improvement.
• Work closely with Finance, Sales, Supply Chain, Operations, and IT teams to understand business requirements and translate them into analytical solutions.
• Analyze key O2C metrics such as Order Cycle Time, DSO, invoice accuracy, billing cycle time, overdue receivables, dispute rate, collection efficiency, and cash application.
• Perform root-cause analysis and provide data-driven recommendations to improve operational efficiency.
• Build and optimize SQL queries for data extraction and analysis.
• Develop automated reporting solutions using Power BI, Tableau, or similar BI tools.
• Perform data reconciliation between ERP and downstream systems to ensure data accuracy and consistency.
• Support ERP enhancements, system implementations, integrations, and process transformation initiatives from a data and analytics perspective.
• Create functional and technical documentation for reports, dashboards, data sources, and analytical processes.
• Collaborate with stakeholders to define KPIs, reporting requirements, and data models.
• Monitor data quality and establish controls to ensure accuracy and completeness of O2C reporting.

Required Skills

• 7+ years of experience as a Data Analyst, Business Data Analyst, or similar role.
• Strong understanding of Order-to-Cash (O2C) processes.
• Hands-on experience working with ERP systems such as SAP, Oracle, Microsoft Dynamics, NetSuite, or similar platforms.
• Strong SQL skills with experience in data extraction, joins, aggregations, CTEs, and query optimization.
• Experience with Power BI, Tableau, or other data visualization tools.
• Strong knowledge of Excel, including Pivot Tables, XLOOKUP/VLOOKUP, Power Query, and data analysis.
• Experience with data cleansing, validation, reconciliation, and transformation.
• Strong analytical and problem-solving skills.
• Ability to translate business requirements into data and reporting solutions.
• Excellent communication and stakeholder-management skills.