DPS - FIN - Financial Data Analyst - 0653

DPS - FIN - Financial Data Analyst - 0653 (00049701) 

Organization

: TEXAS DEPARTMENT OF PUBLIC SAFETY 

Primary Location

: Texas-Austin 

Work Locations

: AUSTIN HQ (MAIN) 5805 N LAMAR BLVD PO BOX 4087 AUSTIN TX 78773 Austin 78752 

  

Job

: Computer and Mathematical 

Employee Status

: Regular 

Schedule

: Full-time Standard Hours Per Week: 40.00 

Travel

: Yes, 5 % of the Time State Job Code: 0653  Salary Admin Plan: B Grade: 24  

Salary (Pay Basis)

: 6,615.00 - 7,717.00 (Monthly) 

Number of Openings

: 1 

Overtime Status

: Exempt 

Job Posting

: Apr 30, 2025, 7:40:32 PM 

Closing Date

: May 16, 2025, 4:59:00 AM 

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

The following Military Occupational Specialty codes are generally applicable to this position. https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_PlanningResearchandStatistics.pdf

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

ESSENTIAL DUTIES/RESPONSIBILITIES:

1.  Analyzes financial data using standard statistical tools, methods, and techniques. Examples include but are not limited to expenditures, encumbrances, pre-encumbrances, revenues, or other information as requested.

2.   Provide user assistance to all agency personnel by analyzing issues, testing financial business processes changes, triaging all user requests all modules in the agency’s financial applications. This includes testing all functionality, change notices, maintenance upgrades, outages, and communicating as needed.  Escalate agency-wide CAPPS Financials issues to CPA through ASP ticketing system, monitor ASP tickets, etc. May provide level 1 support and/or manage CAPPS security roles and user preferences as directed.

3.   Analyze and resolve CAPPS Financials or other agency financial application issues to ensure appropriate workflows and functionality are operational.

4.  Coordinate the planning, design, development, implementation, support, and maintenance of financial information technology security measures to safeguard departmental information.

5.  Coordinate and/or participate in the development and execution of financial enterprise level strategies and technical direction, including establishing processes and procedures for executing and maintaining financial technology road maps.

6.  Complete query development/deployment as well as identification of errors and production related issues to CAPPS Financials or other agency financial applications as directed.  Run, create, and update queries through CAPPS Query Manager to gather appropriate financial data for routine and or ad-hoc purposes.  Prepare concise, comprehensive financial reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions. (ETVs, document corrections, uploader files etc.)

7.  Assist in the support all external interfaces to the agency’s financial applications to ensure stability. Maintain current CAPPS, Tableau, Salesforce, and other financial environments for all existing business processes and continue required testing for systemwide upgrades and deployments. Maintain legacy application support if required or requested.

8.  Provide training of agency staff prior to the implementation of all agency financial applications and or business processes. May provide technical and/or other expertise related to computer systems and offer advice or guidance during the implementation of financial process related to the agency financial systems. Includes development of job aides and other training documentation.

9.  Develop, analyze, and revise systems design procedures, program lines of code, test procedures, and quality standards related to the agency financial systems.

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

11.  Attend meetings as directed and perform other duties as assigned.

 

Qualifications

 

GENERAL QUALIFICATIONS and REQUIREMENTS:  

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 generally preferred. Education may be substituted for proven financial system experience as noted below year for year.

Experience – Minimum of (3) years’ experience performing progressively responsible work in financial systems or closely related activities (advanced query writing or advanced database skills); including two (2) years in CAPPS/ HHSAS/ PeopleSoft Functional and/or Technical Support is required. 

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.  Thirty (30) semester hours will be considered equivalent to one (1) year of experience.

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

Regulatory knowledge – Knowledge of TXDPS, State, Federal, and Departmental regulations, legislation, guidelines, policies and procedures. 

Analytical Reasoning/Attention to Detail – 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.

Financial Knowledge - Analyzing facts, data, and narrative reports. Plan, organize and analyze financial information related to the CAPPS Financials/HR Systems or other applications.  Analyze problems, identify causative factors and elements in financial system problems, apply actions to effectively resolve, prevent recurrence of problematic conditions, and present alternative solutions that may be effective for problem resolution.

Research and Comprehension – Skill in coordinating and solving problems; in developing reports or revising reports; in scheduling, testing, installing, and implementing programs; and in troubleshooting computer systems.

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, Prioritization and Presentation 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.  Must be able to construct and deliver clear, concise, and professional presentations to a variety of audiences and/or individuals.

Technology – Considerable knowledge of the capabilities and limitations of ERP and/or automated systems (CAPPS) or Business Intelligence reporting systems such as Tableau, Salesforce, Business Objects, or similar systems as a means of processing, recording, and reporting financial transactions. Demonstrated proficiency with Microsoft Office Suite (Word, Excel, PowerPoint, Outlook). 

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.

Travel and/or Schedule – Availability for after-hour and weekend work is required.  This position may have the ability to telecommute based on the needs of the division/agency. Travel up to five percent(5%).

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/Indoors;
• Ambulatory skills, e.g. stand, walk, sit;
• Hand-eye Coordination and arm/ hand/finger dexterity;
• Ability to speak, hear, smell, and exercise visual acuity;
• Ability to transfer weights of fifteen (15) pounds anticipated for this position;
• Driving requirements: Low-frequency ten (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.