APPLICATIONS SHOULD BE FILED ONLINE THROUGH CAPPS RECRUIT AT:
https://capps.taleo.net/careersection/ex/jobdetail.ftl?job=00026973

APPLICATIONS SUBMITTED THROUGH WORK IN TEXAS:
Applicants may submit applications through Work In Texas (WIT), however applicants must complete the supplemental questions in CAPPS Recruit to be considered for the position. In order to complete the supplemental questions, please register and/or login to CAPPS Recruit and access your profile. Go to CAPPS Recruit to Sign In (Link: https://capps.taleo.net/careersection/ex/jobsearch.ftl?lang=en)

Your job application must be complete and thorough including responding to all the supplemental questions. Your application must contain complete job histories, which includes job titles, dates of employment, name of employer 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.

NOTES TO THE APPLICANT:

TMD State Employees support the Texas Military Forces by delivering critical services that enable the agency to meet its strategic goals.

Military membership is not required for this position.

ABOUT US:

Our Agency: The Texas Military Department (TMD) is commanded by The Adjutant General of Texas, the state's senior military official appointed by the governor, and is comprised of the Texas Military Department (State & Federal Civilian Employees), the Texas Army National Guard (TXARNG), the Texas Air National Guard (TXANG) and the Texas State Guard (TXSG).

Our Vision: America’s premier state military organization comprised of professional mission-ready forces, fully engaged with our communities, and relevant through the 21st century.

Our Mission: Provide the Governor and the President with ready forces in support of state and federal authorities at home and abroad.

BRIEF POSITION SUMMARY

Performs highly complex (senior-level) computer systems analysis work. Work involves planning and analyzing user requirements, procedures, and problems to automate processing or to improve existing systems and Business Intelligence (BI) reports, providing CAPPS Financials production support for all modules of CAPPS that TMD utilizes, collaborating with divisions within the Comptroller’s office to resolve identified system issues, and assisting with administration of integrated database systems. Reports to the CAPPS and Business Intelligence Manager and works under limited supervision, with considerable latitude for the use of initiative and independent judgment.

WORK HOURS: Monday – Friday, 8 hours a day, 40 hours a week

ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES

• Coordinates with users to identify system and/or report requirements, develops functional design specifications to meet requirements, assists with system and/or reports testing, and solves complex operational problems.
• Provides system expertise, functional support, and help desk coverage by responding to inquiries submitted through the phone and/or agency CAPPS Support e-mail address.
• Provides highly advanced consultation and analysis of the CAPPS production system.
• Designs, modifies, and implements new or revised systems to serve new purposes or improve workflow.
• Prepares flow charts and diagrams to define the goals of the system.
• Provides system expertise and functional support throughout the application development and application change processes.
• Assists with User Acceptance Testing (UAT) of CAPPS upgrades and provides UAT support for designated agency personnel.
• Responds to written inquiries promptly and professionally.
• Escalates Service Requests when determined necessary.
• Assists with development, testing, scheduling, and execution of backup and restore processes to protect organizational data.
• Assists with establishment and implementation of database security controls and user access levels.
• Assists with monitoring of database performance and implementation of efficiency improvements (including indexing and query tuning).
• Assists with development of standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment.
• Able to work independently and perform all assigned tasks in a timely manner
• Attends relevant training to maintain the essential functions of the position.
• Attends work regularly and observes approved work hours in accordance with agency state employee policies & procedures handbook
• May be required to perform duty in support of national emergencies, disasters, and other missions, to include holidays and weekends
• Performs related work as assigned.

MINIMIUM QUALIFICATIONS

EDUCATION:

• Graduation from an accredited four-year college or university is required.

PREFERRED EDUCATION:

• Graduation from an accredited four-year college or university with major course work in computer science, computer information systems, management information systems, or a related field is preferred.

SUBSTITUTION:

• Master’s degree may be substituted for 2 years of experience.

EXPERIENCE:

• Three years’ experience in systems analysis and/or design work is required. (See substitution)
• Experience using Microsoft Office (such as Outlook, Word, or Excel) is required.

PREFERRED EXPERIENCE:

• Two years’ experience working with CAPPS Financials and/or Pepolesoft modules, version 8.8 or higher is preferred.
• Experience with process or systems analysis work on any one or combination of the following: General Ledger/Commitment Control, Purchasing/eProcurement, Accounts Payable, Billing/Accounts Receivable, Inventory, Asset Management, Project Costing, Customer Contracts, Grant Accounting, Planning, Budgeting, Human Resources, Time and Labor, Position Management, Payroll, Performance Management, Learning Management, or Employee/Manager Self-Service is preferred.
• Experience working with Enterprise Resource Planning (ERP) on any one or combination of the following modules: Accounts Payable, Commitment Control, eProcurement, General Ledger, Purchasing, Planning and Budgeting, Accounts Receivable, Cash Receipts, Asset Management, Grant Accounting, or Payroll is preferred.
• Experience and high-level proficiency with Excel creating complex formulas and spreadsheets is preferred.
• Experience with Texas state government processes, policies, and procedures is preferred.
• Experience with the Uniform Statewide Accounting System (USAS), the Automated Budget and Evaluation System of Texas (ABEST), and/or the State Property Accounting System (SPA) is preferred.
• Experience in applications system design, development, implementation, testing, and maintenance is preferred.
• Three or more years’ experience creating Queries using SQL or PeopleSoft Query Manager is preferred.
• Experience with relational database concepts, structures, management practices, and current database technologies is preferred.
• Experience with database design concepts to include relational database (OLTP) and data warehouses (OLAP) is preferred.
• Experience with Microsoft Data Platform to include AQL Server, related tools, and the T-SQL query language is preferred.
• Experience with Microsoft Power BI is preferred.

REGISTRATION, CERTIFICATION OR LICENSURE:

• Valid driver’s license is required. *If not currently a Texas resident, must obtain a Texas Driver's License within 30 days after entering Texas as a new resident. A satisfactory driving record is required for operating state or personal vehicles to conduct agency business.

OTHER REQUIREMENTS:

• Selected candidate must pass federal security background investigation. The process includes a National Agency Check and Inquiry (NACI) and fingerprinting. New employees must complete and sign the Office of Personnel Management (OPM) Form SF85. Completed forms are submitted to the OPM for the background investigations.
• The Immigration Reform and Control Act of 1986 requires all new employees to present proof of eligibility to work in the United States within three (3) days of being hired. The Texas Military Department participates in E-Verify and will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee's Form I-9 to confirm work authorization.
• Upon hire with the State of Texas, males between the ages of 18 through 25 must provide proof of registration or exemption with the Selective Service. For further information, visit the Selective Service website at https://www.sss.gov/RegVer/wfVerification.aspx.

KNOWLEDGE, SKILLS AND ABILITIES

Knowledge of:

• software development life cycle methodology;
• software change control processes;
• limitations and capabilities of computer systems;
• applicable programming languages;
• structured query language; and
• military structure and organization.

Skill in:

• coordinating and solving problems;
• scheduling, testing, installing, and implementing programs;
• troubleshooting computer systems;
• performing business or systems analysis using a defined methodology;
• using effective written and verbal communication to convey information in a clear and concise manner;
• identifying and resolving problems by using strong analytical techniques and innovative approaches and taking initiative to prevent and solve problems; and
• operating computers using Microsoft Office Suite (Outlook, Word, Excel, and Access).

Ability to:

• analyze problems and recommend and present alternative solutions;
• develop and interpret policies, procedures and regulations;
• analyze systems and procedures;
• prepare complex and concise reports within required timeline;
• communicate effectively and work in a team environment;
• establish effective working relationship with supervisor and co-workers;
• supervise the work of others;
• maintain confidentiality and protect the privacy of state employees, taxpayers, and other members of the public; and
• work in a military organization.

PHYSICAL/WORKING CONDITIONS

Work is typically performed in a sedentary office setting, spending more than 70% of the time sitting at a desk operating a computer and telephone. May lift, carry, move, and/or set up equipment and materials that weigh up to 25 pounds. Requires approximately 5% travel.

VETERANS EMPLOYMENT PREFERENCE

If you qualify for a Veteran Employment Preference, it is mandatory that you provide the required documentation at the time of applying. Documentation must be provided before a Veteran Employment Preference can be granted.

Currently Serving U.S. Military Member - Statement of Service Memo;

Veteran – DD Form 214 (or Equivalent) or;

Surviving Spouse of a Veteran who has not remarried - Marriage Certificate and DD Form 1300 or;

Orphan of a Veteran who was killed during active duty – Birth Certificate and DD Form 1300

Disabled Veteran - VA Civil Service Preference Letter

VETERANS:

Use your military skills to qualify for this position or other jobs. Go to www.texasskillstowork.com to translate your military work experience and training courses into civilian job terms, qualifications, and skill sets.

Veterans, Reservist or Guardsmen with an MOS or additional duties that fall in the following fields or other related fields pertaining to the minimum experience requirements may meet the minimum qualifications for this position and are highly encouraged to apply:

United States Army: 25B Information Technology Specialist

United States Navy: IT Information Systems Technician

United States Coast Guard: IT Information Systems Technician

United States Marine Corps: 0171 Manpower Information Systems (MIS) Analyst

United States Air Force: 3D0X4 Computer Systems Programming

Additional Military Crosswalk information can be accessed at:

Military Crosswalk for Occupational Category - Information Technology (texas.gov)

Contact TMD’s Veteran's Liaison, Paul Love if you have questions at (512)782-3836 or staffingHR@military.texas.gov

The Texas Military Department does not discriminate of the basis of race, color, national origin, sex, religion, age, genetic information, or status as an individual with a disability or protected veteran status in employment or in the provision of services.