51741: Columbus, OH – IT – DAS – Business Analyst 2/BA2

Job Classification:   Business Analyst 2 – Analyst

Supplier List:   Open Market
Contract Length:   3-6 months with possible extension
Interview Process: Candidates must be available for onsite interviews- local candidates preferred
Will close to submissions on: Wednesday 2/21 @ 10AM

This is a re-post of 51193- The team is looking for candidates with previous experience in a Vendor management/engagement manager role. They will serve as a liaison between the selected vendor for this project and members of the DOH staff (non IT) to assist with status reporting, communications, and to raise any red flags over the project.

Note: A PO may take up to 3 weeks to procure- please set this expectation with candidates during the submission/interview process.

If there are further questions, contact Andy - andyh@knowledgeservices.com
Manager Notes:

.  3-6 month assignment for BA2 to perform various duties in fast paced government business office: This is more of an assigned task role and will be very “heads down”. This role is being created to assist with the ongoing work to help create free time for other deliverables for current State Employees.
• Perform research and analysis on data usage, create trend reports using Excel, resolve data issues with service areas
• Customer outreach on Accounts Receivable to obtain payments, provide invoice copies, update customer contact information, etc.
• Assist in compiling and\or reviewing large billing files for accuracy, testing procedures, and prepare ad hoc reports
Requirement Description:
Service Usage data:
• Researches & analyzes service utilization and billing information to resolve errors and modify usage and billing as appropriate; verifies to the Ohio Administrative Knowledge System (OAKS) and Service Usage Management System (SUMS).
• 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.
• 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; maintains customer account information & accounting data in the billing systems.
Data Research & Reporting:
• Synthesizes data from multiple financial sources to create reports/presentations for internal/external stakeholders;
• Performs research and data gathering to support unit staff, other ad hoc reporting related to Business Office projects

Required Soft Skills:

• Strong communication/ leadership skills.
• Ability to collaborate with supporting resources across business and/or functional lines.
• Have excellent oral and written skills/possess strong meeting and work session facilitation skills.
• Have the ability to work independently and as part of a team, the ability to manage time and resources to meet assigned deadlines.
• Have excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills.
• Must be knowledgeable in the English language/speak clearly and understandably use the English language.
• Must meet productivity standards, complete work in timely manner and strive to increase productivity
• Help create and maintain good project culture
Mandatory Requirements/Time:

• 5 plus years of experience creating trend reports and 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).
• 5 Plus years of experience researching & analyzing service utilization and billing information to resolve errors and modify usage and billing
• 5 Plus years of experience reviewing Memorandums of Understanding (MOUs) & contracts to ensure proper service & invoicing compliance
• 5 Plus years of experience trouble shooting discrepancies/complaints using multiple financial systems
• 5 Plus years of experience synthesizing data from multiple financial sources to create reports/presentations for internal/external stakeholders

Desired Skills/Time:

• 4 year college degree or equivalent technical study
• Previous experience with State Agencies, boards, commissions or local governmental entities

Comments are closed.