Data Reporting Analyst

Job Description

Job Summary:

Facilitate the development, implementation and continuous improvement of ACI's methodologies, processes and procedures. Work across organizational boundaries to ensure process consistency and adoption. Monitor implemented processes for adoption and compliance. Evaluate existing processes. Organizes leads and facilitates cross-functional project teams. Develop metrics that provide data for process measurement, identifying indicators for future improvement opportunities.

Job Responsibilities:

• Oversee and manage customer data used for billing and other Finance Teams
  • Maintain solid knowledge of customer contracts and billing to understand how a customer "should" be set up in the Customer Data Hub (CDH)
  • Analyze significant changes to customer data (mergers/acquisitions) and make updates accordingly.
  • Understand how customer data is being used through the organization and support various efforts to align or cleanup data via the "Master Interchange Project and/or "Ignite."
  • Setup "Bill To" and "Ship To" details correctly for customers, as this is critically important to ensure invoices are delivered and customer is taxed appropriately.
  • Continue cleanup efforts to inactivate unused sites and accounts
• Run various reports throughout the month to ensure a smooth month-end close:
  • Report showing pre-contracts with 10 or less billable hours and not used withing 60 days
  • Status report to ensure contracts are not in draft, pending approval, pending amendment, etc.
  • Pre-run create accounting process to identify any issues early that might create problems for close
  • Run Unprocessed Error Transactions report and resolve the issue or open tickets to the correct department to resolve
  • Assist with Contract Admin close through PRF setup and customer updates that come in near month-end• Perform other duties as assigned
• Update and maintain reference documents housed outside of our Customer Data Hub (Channel Partner Report and LATAM Local Deliver Report)
• Pull a monthly tax exemption report from OBIEE, analyze tax exemption expirations and work with BSO to notify customers that tax will start applying to invoices.
• Update case management and monthly billing metrics for both AOD and On-Prem
• Support leadership in revising the event billing reports and corresponding processes
• Provide ad-hoc reports from CDH to business partners as requested
• Understand and adhere to all corporate policies to include but not limited to the ACI Code of Business Conduct and Ethics.
• Understands and complies with Risk Management program requirements including identification of risks, key controls, and control testing as applicable to their responsibilities.

Knowledge, Skills and Experience required for the job:• Bachelor's degree in Computer Science, Business Administration, Finance or equivalent experience.• 3+ years related experience required; including operational and software application knowledge.• Intermediate Excel, Power Point, Word, Graphics for development of process and communication materials.• Excellent presentation, oral and written communication, and listening skills.

#LI-AM1