Job Description

PLEASE NOTE:

All applications must contain complete job histories, which includes job title, dates of employment, name of employer, supervisor's name and phone number and a description of duties performed. If this information is not submitted, your application may be rejected because it is incomplete. Resumes do not take the place of this required information.

SUBMITTED THROUGH WORK IN TEXAS: Work In Texas (WIT) applicants must complete the supplemental questions to be considered for the posting. In order to complete the supplemental questions please go to CAPPS Recruit to register or login and access your profile. Go to CAPPS Recruit to Sign In https://capps.taleo.net/careersection/ex/jobsearch.ftl?lang=en

GENERAL DESCRIPTION: Performs highly complex (senior-level) consultative services and technical assistance work. Database Administrator for the Centralized Accounting and Payroll / Personnel System (CAPPS) Asset Management Module and member of the level 1 support team for CAPPS Financials. Review, oversee and reconcile property and equipment transactions in the Uniform Statewide Accounting System (USAS), the State Property Accounting System (SPA), CAPPS and Virtual Asset Tracker (VAT). May train, lead, and/or prioritize the work of others. Works under limited supervision, with moderate latitude for the use of initiative and independent judgment.

The following Military Occupational Specialty codes are generally applicable to this position.

Enter Crosswalk here: https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_ProgramManagement.pdf

Applicants must fully complete the summary of experience to determine if minimum qualifications are met.

ESSENTIAL DUTIES / RESPONSIBILITIES:

1. Review, analyze and reconcile Asset Management databases (VAT, CAPPS and SPA) to ensure records accurately reflect Uniform State Accounting System (USAS) balances.

2. Provide level one support for CAPPS users. Assist users with Asset Management issues they are experiencing in all modules. Add and update locations and ship to locations for the agency in CAPPS.

3. Compose and create a wide variety of correspondence and reports that are legislatively mandated or requested regarding missing assets and the value or quantity of inventory.

4. Oversee Asset Management database interfaces. Inform Asset Management staff of irregularities and report issues to Comptroller by entering ASP Service Requests.

5. Monitor Asset Purchase Orders to ensure correct account coding and assign Asset ID's and monitor Payment Vouchers to ensure correct financial information is recorded for assets.

6. Oversee Construction in Progress and Real Property additions and disposals.

7. Assist CAPPS requestors, Budget Analysts and finance employees with account coding and questions relating to the procurement of property.

8. Assist in developing and implementing new policies and procedures to account for assets being received, distributed or disposed of in an aggressive mission driven purchasing environment.

9. Analyze, evaluate, create and train on solutions to minimize errors and maintain accurate information in field locations.

10. Release receipts for assets in CAPPS. Ensure correct asset ID's were used by receiver and assets moved to Asset Management module.

11. Assist Finance with asset management information for the annual financial report.

12. Assist in conducting state or private audits within asset management office.

13. Manage the SharePoint site for Asset Management.

14. Attend work regularly and observe approved work hours in accordance with agency leave and attendance policies.

15. Perform other duties as assigned.



Qualifications:

GENERAL QUALIFICATIONS and REQUIREMENTS:

Education - Associate's degree with Major or coursework emphasis in Computer Science, Management Information Systems, or related field.

Experience - Minimum of four (4) year's experience performing data analysis, or database development and maintenance work. Minimum of

five (5) year's experience in inventory management and property accounting.

Substitution Note: Additional work experience of the type described or other related education may be substituted for one another on a year-for-year

basis.

Licensure and/or Certification - If driving is required, must possess a valid driver license from state of residence.

Regulatory Knowledge - Working knowledge of, or the ability to rapidly assimilate information related to TXDPS, State and Federal regulations,

legislation, guidelines, policies and procedures.

Supervisory/Managerial/Leadership skills - Knowledge of management and supervisory methods and principles, performance and productivity

standards, and fiscal/budget management. Able to develop plans, policies, and procedures for efficient workflow and overall effectiveness, and provide

clear direction to subordinates; promote teamwork and be able to motivate others to accomplish goals.

Interpersonal Skills - Must demonstrate an ability to exercise poise, tact, diplomacy and an ability to establish and maintain positive,

working/professional relationships with internal/external customers. Must demonstrate DPS' core values: Integrity, Excellence, Accountability, and

Teamwork.

Organizational and Prioritization Skills - Must be organized, flexible, and able to effectively prioritize in a multi-demand and constantly changing

environment; able to meet multiple and sometimes conflicting deadlines without sacrificing accuracy, timeliness or professionalism.

Presentation/Communication Skills - Must be able to construct and deliver clear, concise, and professional presentations to a variety of audiences

and/or individuals.

Research and Comprehension - Must demonstrate ability to quickly and efficiently access relevant information, and be able to utilize and/or present

research and conclusions in a clear and concise manner.

Analytical Reasoning/Attention to Detail - Knowledge of auditing practices and inventory control database management; warehouse methods and

procedures. Must demonstrate an ability to examine data/information, discern variations/similarities, and be able identify trends, relationships and causal

factors, as well as grasp issues, draw accurate conclusions, and solve problems.

Technology (computers/hardware/software/operating systems) - Must possess appropriate levels of proficiency with utilized software and systems

(USAS, SPA, FMX, VAT, CAPPS, etc.). Demonstrated proficiency with Microsoft Office Suite (Word, Excel, PowerPoint, and Outlook), and appropriate

levels of proficiency with utilized software and systems and be able to learn new software/systems.

Confidentiality and Protected Information - Must demonstrate an ability to responsibly handle sensitive and confidential information and situations,

and adhere to applicable laws/statutes/policies related to access, maintenance and dissemination of information.

Safety - Must be able to work in safe manner at all times, avoiding shortcuts that have potential adverse results/risks, and must be able to comply with

safety standards and best practices.

Travel and/or Schedule - May be required to drive as needed.

PHYSICAL and/or ENVIRONMENTAL DEMANDS:

The physical and environmental demands described here are representative of those encountered and/or necessary for the employee to successfully

perform the essential functions of this job; reasonable accommodations may be made to enable individuals with disabilities to perform the essential

functions.

• Environment: Office;

• Ambulatory skills, e.g. stand, walk, sit, climb, balance, stoop, kneel, crouch;

• Hand-eye coordination and arm/hand/finger dexterity;

• Ability to speak, hear, and exercise visual acuity;

• Ability to transfer weights of 25 pounds anticipated for this position;

• Driving requirements: Occasional (10%).

State of Texas Benefits and Retirement Information: https://www.ers.texas.gov/

A DPS employee who is selected for a position in the same salary group and state title as their current position will be transferred with no salary change.

A DPS employee who is selected for a position in their current salary group with a new state title may receive an increase of no more than 3.4% over their current salary regardless of posted salary.

Salary is contingent upon qualifications and is subject to salary administration and budgetary restrictions.

DUE TO THE HIGH VOLUME OF APPLICATIONS WE DO NOT ACCEPT TELEPHONE CALLS. ONLY CANDIDATES SELECTED FOR INTERVIEW WILL BE CONTACTED.

State of Texas retirees may be rehired for full-time, non-commissioned positions only under very specific circumstances.

Testing is required for candidates to be considered to go before the oral interview board and will be notified via email provided on the application. Candidates must qualify on the DPS issued Excel.