TDA - Finance - CAPPS Analyst (Financial Business Analyst/ Accounting and Business System Analyst) (57577)

CAPPS ANALYST

(Financial Business Analyst/ Accounting and Business System Analyst)

HOW TO APPLY

Apply online via CAPPS. Applicants applying in WIT must complete the supplemental questions to be considered for the position. To complete the supplemental questions, go to CAPPS Recruit.

WHO ARE WE

The Texas Department of Agriculture Financial Services Division supports TDA programs by performing financial duties in the areas of accounting, budget, purchasing, contracting, accounts payable and payroll. The Accounting Section manages the agency general ledger, prepares the Annual Financial Report, administers cash management, and develops agency financial reports. TDA receives and distributes grant funds, and Accounting provides additional oversight to grant program disbursements and reporting.

WHAT YOU’LL DO

The CAPPS Analyst will perform highly complex (senior-level) business analysis and complex accounting work in support of the Financial Services Division. You will be involved in monitoring and maintaining accounting systems, procedures and controls; developing business processes; providing technical assistance to division staff; preparing reports and responding to inquiries. Work under limited supervision with considerable latitude for the use of initiative and independent judgment.

PRIMARY RESPONSIBILITIES

As the subject matter expert (SME) for the Centralized Accounting and Payroll/Personnel (CAPPS) Financial system you will provide technical assistance to division staff, develop training curricula, and perform training sessions covering their assigned system modules.

Coordinate financial functional data needs with CPA and TDA technology staff. Serve as first level help support for agency users of the CAPPS and submit help tickets in ASP to the Office of the Comptroller of Public Accounts' (CPA) to resolve issues; validate results to ensure functionality of changes have met the goal of the request.

Create and develop CAPPS ad hoc queries in query manager and reports using Business Objects. Use CAPPS data to assist with writing Financial reports.

Review, analyze, and submit CAPPS security change request and coordinate with agency CAPPS security coordinator to ensure access is in compliances with security controls.

Coordinate the month end and year end CAPPS accounting close.

Prepare and perform complex monthly reconciliations between various CAPPS modules such as Accounts Payable, General Ledger/Commitment Control, Purchasing/Procurement, and Asset Management.

Monitor daily interface activities to ensure the accuracy and completeness of the data interfaced from Centralized Accounting and Payroll/Personnel System (CAPPS) modules to the Uniform Statewide Accounting System (USAS).

Perform daily HX and IN CAPPS reconciliations to ensure appropriate liquidation entries are created after data from HX file and IN records are matched.

Review and analyze the CAPPS "Recycle" table daily for documents which failed to be loaded through EDI voucher load; reconcile discrepancies.

Attend and participate in CAPPS user group and governance meetings and report updates and changes to the Financial Services Division.

QUALIFICATIONS/REQUIREMENTS FOR THE POSITION

Bachelors degree (One year work experience related to the essential duties may substitute for one year of college).

Three (3) years experience with system processing/support or systems analysis work in any one or combination of the following Peoplesoft FSCM Modules; Accounts Payable, General Ledger/Commitment Control, Purchasing/Procurement, and/or Asset Management.

One (1) year experience with State of Texas accounting system Centralized Accounting and Payroll/Personnel (CAPPS), PeopleSoft FSCM version 9.2 or higher, BI Publisher, or related.

PREFERRED QUALIFICATIONS

Bachelor’s degree in Business, Public Administration, Communications, Computer Science, Computer information Systems, or Management Information Systems.

Experience analyzing data and creating queries.

Certified Public Accountant (CPA) license in good standing.

KNOWLEDGE, SKILLS & ABILITIES

Knowledge of generally accepted accounting principles and state laws pertaining to public funds, governmental finance and automated accounting systems; software development life cycle and systems development life cycle concepts; business and management principles involved in strategic planning, resource allocation, leadership technique, production methods, and coordination of people and resources; and of project management principles and practices.

Skill in providing customer service excellence to both internal and external customers; operating a personal computer with applicable software; math aptitude and critical thinking; business analysis methodologies; analyzing and evaluating complex information technology applications, policies, and issues; and in developing creative and workable solutions to complex problems and issues.

Ability to perform and interpret numerical analyses; analyze, evaluate and summarize accounting records for accuracy and conformance to procedures, rules and regulations; analyze and interpret technical information, including regulations, policies, and automation system documentation/specifications; translate user/business needs into a technical style; communicate technical instructions to system users; analyze, evaluate, and integrate business rules into system requirements; exercise sound judgment in making critical decisions; and to communicate effectively.

PHYSICAL REQUIREMENTS & WORKING CONDITIONS

Normal office work environment and may have exposure to dust and environmental allergens consistent with normal business activities and human contact. Mostly sedentary in nature but may involve walking; standing; pulling and pushing; kneeling, stooping and bending; performing tasks requiring fine motor skills and coordination; and safely lifting and carrying items weighing up to 30 pounds. Must be able work extended periods at a computer, and may require working extended hours and some evenings and weekends, (up to 5%) as needed.

TELEWORK & WORK HOURS

The agency does not offer telework. TDA employees are required to be physically present for work.

The agency’s core business hours are from 8:00 a.m. to 5:00 p.m., Monday through Friday. TDA also provides limited customer service between 6:00-8:00 a.m. and 5:00-6:00 p.m.

H-1B Visa Sponsorship

We are unable to sponsor or take over sponsorship of an employment Visa.

BENEFITS

The State of Texas offers a variety of benefits for you and your family that are comprehensive and, on average, make up about one-third of total compensation. Benefits include:

• A valid government-issued driver’s license, which is recognized by the Texas Department of Public Safety and in good standing, and an acceptable driving record are required. TDA will verify this information with the Texas Department of Public Safety. Applicants with a driver’s license not issued by the State of Texas should obtain and be prepared to provide a copy of their current driving record on or before their first day.

Equal Employment Opportunity (EEO): TDA is an equal employment opportunity (EEO) employer and does not discriminate on the basis of race, color, religion, sex, national origin, disability, age, genetic information, military status, or protected activity. TDA provides accommodations for persons with disabilities in accordance with the American with Disabilities Act. If you need help with the employment process or require other accommodations, please contact the Human Resources office for assistance at (512) 463-7423.

TDA participates in E-Verify and will provide the Social Security Administration and, if necessary, the Department of Homeland Security, with information from each new employee's Form I-9 to confirm work authorization.

Military and Former Foster Child Employment Preference: TDA complies with the provisions of the veterans and former foster child employment preference acts. Please contact our Human Resources-Veterans Liaison at (512) 463-7454 for assistance.