Data Analyst

Description

Job Identification

• Job Title:             Data Analyst
• Department:        Accounting
• Reports to            Assistant Controller – E-Commerce
• Location:             Alexandria, VA
• Grade:                 17
• FLSA Status:      Exempt

Statement of Purpose

Collects and analyzes E-Commerce accounts payable and purchase order exception data, identifying recurring problems and process and resolving exception data to ensure the full cycle of E-Commerce orders is complete within Oracle.

Business Communications

• Employees in Other Divisions                                         Frequently
• Supervisory Personnel/Management                               Frequently
• NIB Associated and SourceAmerica Agencies                Frequently
• E-Commerce Vendors                                                      Frequently

Education

Bachelor’s degree from a regionally accredited university or college or equivalent work experience preferred.  An equivalent combination of education and experience may also be acceptable. SQL Certification is preferred.

Training and Specialized Knowledge

• Excellent Excel skills
• Excellent organizational and communication skills
• Proficiency with MS Word and other accounting software
• Proficiency with SQL
• Familiarity with Oracle Database Architecture

Core Competencies

• Accountability
• Communication Skills
• Ethics/Integrity
• Customer Care
• Job Knowledge/Technical Skills
• Process Improvement

Experience

• Experience with EDI processes in a high-volume environment.
• Two to Three years of E-Commerce experience
• Two to Three years plus of Oracle EBS experience
• Extensive SQL experience

Travel Required

Minimal

Specific Duties and Responsibilities

• Supports internal and external stakeholders via analysis of the EBS database.
• Manage communications with external stakeholders when significant and consistent problems arise concerning submitted EDI documents and facilitate resolutions.
• Design and develop SQL querying tools to meet existing and evolving reporting needs.
• Develop tools and processes to enable more effective completion of standard work obligations for E-Commerce employees
• Work with the E-Commerce operations, IT, and customer care staff to resolve AP and PO issues
• Collect and monitor data for AP holds and exceptions regularly.  Provide a summary of AP hold and exception status by vendor and type to management and IT.
• Research and resolve EDI 810 invoice exceptions
• Monitor EDI-based issues' impact on E-Commerce Accounting delays or interruptions.  Research EDI or vendor-based factors contributing to such delays, such as incomplete invoices, Direct EDI errors, and incomplete or missing shipping notices.  Work with IT for any E-Commerce EDI initiatives as needed.
• Assist E-Commerce Accounts Payable and Accounts Receivable staff by providing additional support when necessary. 
• Develop new analysis for E-Commerce accounting and AP as required and provide ad hoc troubleshooting as needed.

This job description does not imply that these are the only duties to be performed.  The incumbent in this position will perform such other tasks as may be required for the effective operation of the Division/Department upon receipt by his/her supervisor.

NIB IS AN EQUAL OPPORTUNITY/AFFIRMATIVE ACTION EMPLOYER

NIB is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected Veteran status.

Qualifications

Salary : $60,500 - $75,600