Jr. Business Analyst
Location:
Westerville , Ohio
Posted:
November 17, 2017
Reference:
03410-9500896269

Service Usage data: • Researches analyzes service utilization and billing information to resolve errors and modify usage and billing as appropriate; • Researches analyzes the Ohio Department of Administration (DAS), Office of Information Technology (OIT) customer service utilization based on multiple service sources compiles it with current data creating billing files, uploads to the billing system upon verification to the Ohio Administrative Knowledge System (OAKS); • Resolves errors based on validation of OIT customer service utilization, creates adjustment files prior to upload to the billing system by Information Technology Services (ITS) Application staff for adjustments, verifies those adjustments properly reflect the intended outcomes in the billing system as entered in OAKS by DAS Finance; • Creates multiple trend reports to analyze, formulate, and verifying the OIT service utilization and billing data requiring creation of complex excel spreadsheets using pivot tables, logical Excel statements, graphs, conditional formatting and other excel functions; creates ad-hoc reports (e.g., reports that support billing office management and service areas). Customer billings: • Compiles and confirms usage data for billing OIT services as a preparer and peer reviews • Reviews Memorandum of Understanding (MOUs) contracts to ensure proper service invoicing compliance with each agreement, creates billing files using multiple financial systems ensure the information is appropriately validated, documented, processed by the DAS Finance Office. • Serve as liaison with OIT Customers (e.g., State Agencies, boards, commissions, local governmental entities) to troubleshoot any financial issues, questions communications; researches customer discrepancies/complaints using multiple financial systems including: OAKS, OIT Service Usage Accounting Manager, Telecommunications Automated Phone Systems (TAPS) as well as contracts MOUs; • Makes collection efforts to ensure all OIT costs are fully recovered; assigns accounting information to new existing customers relays that information to service managers; maintains customer account information accounting data in the billing systems; manages access to the billing system database for customers. Data Research Reporting: • Synthesizes data from multiple financial sources to create reports/presentations for internal/external stakeholders; • Creates multiple trend reports to analyze, formulate, and verifying the OIT service utilization and billing data requiring creation of complex excel spreadsheets using pivot tables, logical Excel statements, graphs, conditional formatting and other excel functions; creates ad-hoc reports (e.g., reports that support billing office management and service areas). • Performs research and data gathering to support unit staff, other ad hoc reporting related to Business Office projects If interested, please contact Seth Meadows at Seth.Meadows@RHT.com or call (614) 602-0510.


A little about us:
Founded in 1948, Robert Half (NYSE: RHI) is the world's first and largest specialized staffing services firm.

Know someone who would be interested in this job? Share it with your network.