Order To Cash Data Integration And Reporting

ARL- 6.2

Solution Line- Aon Business Services

Industry Type: IT Services/Finance and Reporting/Analytics

Position type- Full Time

Work Location- Noida, Uttar Pradesh

Working style- In Office / Hybrid

Cab Facility- Yes

Shift Time -2:00 PM To 11:00 PM IST

People Manager role: No

Reports To: Workday PSA Solutions Lead

AON IS IN THE BUSINESS OF BETTER DECISIONS

At Aon, we shape decisions for the better to protect and enrich the lives of people around the world.

As an organization, we are committed as one firm to our purpose, united through trust as one inclusive, diverse team, and we are passionate about helping our colleagues and clients succeed.

Required Skills -

• 4 – 8 years of Workday Configuration and Integration experience, with a focus on Order to Cash / Finance Operations
• Strong understanding of Workday Financials, Business process Framework, calculated fields, and reporting tools (EIB, Studio, REST/SOAP, XML/XSLT, Power Automate, Python)
• Hands on experience in Reporting Analysis, or financial modules
• Exposure to integrations will be an added advantage
• Excellent analytics, documentation, and communication skills
  
  

Preferred -

• Experience in global/multi-country financial setup and reporting integrations
• Workday Pro Certifications – Finance or related modules
  
  

Key Responsibilities

Workday Data Extraction (RaaS) – OTC Focus

• Design, configure, and maintain Workday RaaS reports focused on OTC processes (e.g., customers, contracts, revenue, invoices, payments, adjustments, aging, write offs).
• Partner with Finance, Business, Billing, and Collections teams to understand Order To Cash data structures and reporting needs.
• Monitor and troubleshoot RaaS reports and integrations feeding OTC analytics.
  
  

Data Engineering & Transformation (Databricks)

• Ingest Workday RaaS outputs into Databricks.
• Build and maintain reusable ETL pipelines in Databricks using Python and SQL to transform raw OTC data into ready models.
• Join and reconcile Workday data with other relevant sources to create enriched reporting.
• Implement data quality checks, reconciliation logic, and exception reporting.
• Optimize pipelines and queries for performance, cost, and reliability.
  
  

Analytics & Reporting (Tableau & Excel) – OTC KPIs

• Design, build, and maintain Tableau dashboards and workbooks that provide clear, actionable insights for stakeholders.
• Develop Excel reports and models needed for detailed analysis, scenario modeling, or operational users.
• Provide standardized and ad hoc reporting to support OTC and real time reporting
• Apply visualization best practices to ensure reports are intuitive and support quick decision-making.
  
  

Automation & Push Email Reporting

• Configure and manage Tableau Server subscriptions and other automated distribution methods for recurring OTC reports.
• Develop scripts and workflows (Python/SQL/Databricks jobs) to automatically refresh datasets and distribute reports via email to defined OTC stakeholder groups.
• Monitor scheduled jobs and report deliveries, quickly resolving failures and data issues and communicating impacts to stakeholders.
• Partner with leadership to define appropriate cadences, audiences, and alert thresholds for automated reporting.
  
  

Stakeholder Collaboration & Governance

• Work closely with OTC process owners, Finance, and Business Operations to capture requirements and translate them into robust data models and reports.
• Serve as a subject matter expert on Workday OTC data and the downstream reporting environment.
• Document OTC data flows, data definitions, business rules, and dashboard logic; maintain a clear OTC reporting catalog.
• Help drive consistent definitions for OTC KPIs and promote data and reporting standards across regions and business units.
  
  

How We Support Our Colleagues

In addition to our comprehensive benefits package, we are proud to be an equal opportunity workforce. At Aon, we believe a diverse workforce is an innovative workforce. Our agile, inclusive environment allows colleagues to manage their well-being and work/life balance while empowering them to be their authentic self.

Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging them to take time to focus on themselves. We offer a variety of workstyle options through our Smart Working model, but we also recognize that flexibility goes beyond just the place of work... and we are all for it!

Our continuous learning culture inspires and equips colleagues to learn, share and grow, helping them achieve their fullest potential. As a result, Aon colleagues are more connected, more relevant and more valued.

2575956

---