Order to Cash Data Integration and Reporting

Noida, Uttar Pradesh
Permanent
Full-time

3 days ago

Job Description:ARL- 6.2Solution Line- Aon Business ServicesIndustry Type: IT Services/Finance and Reporting/AnalyticsPosition type- Full TimeWork Location- Noida, Uttar PradeshWorking style- In Office / HybridCab Facility- YesShift Time -2:00 PM To 11:00 PM ISTPeople Manager role: NoReports To: Workday PSA Solutions LeadAON IS IN THE BUSINESS OF BETTER DECISIONSAt 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 ResponsibilitiesWorkday 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 COLLEAGUESIn 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

Aon

Apply Now