REVENUE DATA ANALYST
Business Area: Finance
Job Summary:
Responsible for revenue data integrity which includes, RAR evaluation error and fallout error validation. Conducts research and analysis to identify the cause of RAR errors. Collaborates with IT, Budapest Revenue Accounting Team, MPS Operations Team to resolve the issues and errors identified. Provides RAR error status on a monthly basis. Performs User Acceptance Testing (UAT) for any system or process changes which affects the RAR system. Investigates system related revenue queries from Finance Planning and Revenue Accounting Team.
The role is responsible for creating and maintaining work instructions/desk procedures. May need to perform RAR fulfillment true up, FIRA period validation, RAI accrual validation and Balance Sheet reconciliation.
Key Roles and Responsibilities:
-
RAR errors validation and resolution (evaluation error and fallout)
- RAR errors validation (evaluation error and fallout):
- • Runs evaluation error and fallout report in SAP.
- • Performs validation of the errors captured in the evaluation program or fallout error not limited to, checking of Operational document data, CRM data, Accounting File, RAR allocation and RA contracts.
- • Coordinates with other teams like Budapest Accounting team, MPS Operations (Business Operations Manager, Customer Contract Management, Asset Management Specialist) and/or IT for any clarification/verification of errors.
- RAR errors resolution (evaluation error and fallout):
- • Works with IT technical resources to ensure efficient and effective resolution of system errors.
- • Works with other teams like Budapest Accounting team, MPS Operations (Business Operations Manager, Customer Contract Management, Asset Management Specialist) to resolve errors in RAR by loading prices or correcting process or data source.
- • Raises incident tickets to IT AMS for errors that need further investigation and/or root cause analysis.
- • Coordinates with IT for them to update the RAR error validation document.
- • Coordinates with Revenue Accounting for potential manual adjustment if system correction is not feasible during a specified time.
- RAR errors status update:
- • Provides error status update every month during status call with the Global Sub-process Lead.
-
UAT for RAR system changes
- Performs UAT for any configuration, enhancement that affects RAR.
- Provides timely feedback of results of any testing performed related to RAR system configuration or enhancement.
-
System related revenue queries from finance/revenue accounting:
- Investigates RAR system issues coming from finance or revenue accounting queries.
- Performs similar steps in validation and resolution of evaluation and fallout errors.
-
RAR Fulfillment True up
- Runs fulfillment report.
- Performs fulfillment report validation
- Runs fulfillment true up
-
FIRA period validation
- Performs validation/checks before FIRA period closing which includes manual execution of FIRA programs A, B and C.
- Inform GL Admin to close FIRA period once all validation is good.
-
RAI accrual validation
- Performs validation of unprocessed/unposted RAI to be accrued by Revenue Accounting on a monthly basis.
-
Balance Sheet Reconciliation
- Ensure compliance to Corporate Accounting Instructions 119 requirements.
- Timely submission. Critical recons should be submitted every WD4 & WD12.
- Resolution of the aged, reconciling and unreconciled items. Identify research and investigate each of the items.
- Adequacy of supporting documents. Ensure that all items have latest reference schedules, emails and computation.
-
Documentation
- Creates and maintains desk procedures of assigned tasks.
Competencies, Skills, Knowledge and Abilities:
- Proficient in SAP application.
- Knowledge and experience in RAR tool and CRM tool are preferred, but not required.
- Intermediate knowledge in MS Excel, MS PowerPoint applications.
- Appropriate level of supply chain / finance business / services knowledge to effectively understand processes.
- Able to communicate technical information to non-technical audience.
- Good analytical (root cause analysis) and problem solving skills
- Proactive and displays sense of urgency and ownership.
- Able to work in a cross-functional team with diverse background.
- Ability to effectively multi-task and prioritize items in order to complete tasks efficiently and within expected timelines.
- Good project management skills.
- Effective training and work session facilitation capabilities.
- Effective English language skills, verbal and written communications.
Education, Experience and Certifications Basic Requirements:
- Must be a graduate of BS in Accountancy or BSBA major in Accounting, preferably Certified Public Accountant but not required.
- At least 3 years of Finance / Supply Chain / Services operations, within or outside of Lexmark.
You may send your application to recruitment@lexmark.com.