Senior Data Analyst

Relanto; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Relanto is seeking a Senior Data Analyst to leverage ERP and Order-to-Cash domain experience to analyze business data, identify trends, and provide actionable insights to improve O2C performance. The role focuses on data extraction, visualization, and reporting.

You will work with Finance, Sales, Supply Chain, Operations, and IT to translate requirements into analytical solutions, build dashboards in Power BI or Tableau, and ensure data quality across ERP and downstream systems.

Qualifications

• 7+ years of experience in data analysis or BI roles.
• Strong ERP/O2C domain experience.
• Experience with SAP/Oracle/MS Dynamics/NetSuite.
• Develop dashboards and reports to monitor O2C performance.

Responsibilities

• Analyze data across the O2C lifecycle including order management, invoicing, and AR.
• Develop and maintain dashboards and KPIs to monitor O2C performance.
• Perform data extraction, transformation, and validation from ERP systems.
• Collaborate with Finance, Sales, IT to translate requirements into analytics.
• Ensure data quality and establish reporting controls across ERP and downstream systems.

Skills

O2C domain expertise

SQL

Power BI/Tableau

Data analysis

Excel advanced

Stakeholder management

Communication

Tools

SAP

Oracle

MS Dynamics

NetSuite

Power BI

Tableau

Job description

Full-Time

Role: Senior Data Analyst

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.