Order to Cash Analyst
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 industry expertise.
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
Excellence - We strive to make every client our advocate
Passion - We DO because we CARE.
Collaboration - We win together through teamwork and communication.
Agility - We flex, adapt and embrace change.
People - We value, respect and invest in our teammates.
Vision - We create clarity of purpose and a clear path forward