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.