Order to Cash Analyst

Consilio LLC; Gurugram District; On-site; INR 550,000 - 850,000; Full time

Job summary

Consilio is seeking an O2C Analytics Analyst to build and maintain Power BI dashboards, analyze billing and collections data, and improve transparency into aging, collections performance, and revenue realization. The role requires strong Excel and Power BI skills and a solid understanding of O2C data flows.

You will work with NetSuite, Salesforce, and internal tools, translating business requirements into effective dashboards and data models for stakeholders across Finance and Operations.

Qualifications

• Strong Power BI expertise (data modeling, DAX, dashboards).
• Advanced Excel skills (pivot, lookup, data manipulation).
• Solid understanding of financial data and O2C processes (AR, billing, collections).

Responsibilities

• Develop and maintain Power BI dashboards for O2C performance (AR aging, collections, billing accuracy, DSO drivers).
• Translate business requirements into data models and visualizations.
• Validate and reconcile data across NetSuite, Salesforce, and internal tools.
• Support leadership with recurring and ad hoc reporting needs.
• Collaborate with Finance, Operations, and Systems teams to improve data availability and quality.

Skills

Power BI

Advanced Excel

O2C processes

SQL / Python

Tools

NetSuite

Salesforce

Job description

Overview

About the company

Consilio stands as the global leader in eDiscovery, document review, flexible legal talent, and legal advisory & transformation consulting services. With its Consilio Complete suite of capabilities, the company empowers multinational law firms and corporations using innovative software, cost-effective managed services, and deep legal and regulatory industryexpertise.

Position Overview

We are seeking a detail-oriented Order-to-Cash (O2C) Analytics Analyst to support reporting, insights, and process visibility across the O2C lifecycle. This role will focus on building and maintaining Power BI dashboards, analyzing billing and collections data, and improving transparency into key financial metrics such as aging, collections performance, and revenue realization. The ideal candidate combines strong Excel and Power BI capabilities with a solid understanding of financial processes and data flows within O2C systems.

Responsibilities

Reporting & Dashboard Development:

• o Develop and maintain Power BI dashboards tracking O2C performance (AR aging, collections, billing accuracy, DSO drivers)
• o Translate business requirements into effective data models and visualizations
• o Ensure dashboards are accurate, scalable, and used by stakeholders for decision-making

Data Analysis & Insight Generation:

• o Analyze O2C data to identify trends, anomalies, and improvement opportunities
• o Provide actionable insights on billing, collections, and revenue leakage
• o Support leadership with recurring and ad hoc reporting needs

Data Integrity & Reconciliation

• o Validate and reconcile data across systems (NetSuite, Salesforce, internal tools)
• o Investigate and resolve discrepancies impacting reporting accuracy
• o Maintain data definitions and metric consistency (single source of truth)

Process Improvement Support

• o Identify inefficiencies in billing and collections workflows using data
• o Support implementation of reporting and automation enhancements
• o Collaborate with finance and technical teams to improve data availability and quality

Cross-Functional Collaboration

• o Work closely with Finance, Operations, and Systems teams to align reporting requirements
• o Support stakeholders with data requests and performance analysis
• o Communicate insights clearly to both technical and non-technical audiences

Qualifications

Required Skills and Qualifications:

· Core Technical Skills:

• o Strong Power BI expertise (data modeling, DAX, dashboard design)
• o Advanced Excel skills (pivot tables, VLOOKUP, data manipulation)
• o Strong understanding of financial data and O2C processes (AR, billing, collections)

Preferred (Not Primary) Technical Skills:

• o Exposure to SQL or Python for data extraction/processing
• o Experience with data visualization or reporting tools beyond Power BI

· Experience:

• o 1-3 years in a finance, operations, or data analysis role.
• o Experience building dashboards used by business stakeholders
• o Hands-on experience working with data from ERP/CRM systems (NetSuite, Salesforce preferred)
• o Experience working with imperfect or inconsistent data across multiple sources

· Soft Skills:

• o Strong analytical and problem-solving abilities.
• o Excellent written and verbal communication skills.
• o Ability to manage multiple tasks and deadlines efficiently.

Shift timings:

• · This opportunity requires working US shift time of 9:00am - 5:00pm ET.

Consilio’s True North Values

Client Experience | Listen for the "why". Clearly define success. Be accountable. Go the extra distance to create moments that matter.

Collaboration | Treat everyone with respect. Welcome diverse views. Partner across geographies, generations, and teams. Rally around final decisions.

Innovation | Always be curious (ABC). Challenge the status quo. Experiment and fail forward. Build for the future.

Grit | Focus on what matters. Work with passion and persistence. Think like an owner. Deliver results you're proud of.