Data Analyst III (Office of Finance)

Department-of-Family-and-Protective-Services; Austin (TX); Remote; USD 54,000 - 87,000; Full time

Job summary

The Data Analyst III position at the Texas Department of Family and Protective Services (Office of Finance) is a full-time role based in Austin with eligibility for telework. The analyst will perform complex data analysis, develop data solutions, and support major financial reports using CAPPS Fin/PeopleSoft and SQL.

Strong programming and data skills are required. Responsibilities include data extraction, quality metrics, and collaboration with finance teams to improve data-driven decisions.

Qualifications

• Graduation from an accredited four-year college or university is preferred.
• Experience with data extraction and reporting for financial systems is required.
• Knowledge of budget and general ledger financial reporting is preferred.

Responsibilities

• Performs data integrity functions within CAPPS Fin and related subsystems.
• Writes and queries data using SQL and Visual Basic for audit requests and open records.
• Prepares financial reports and data sets for major agency reports (MFR, LAR, AFR, SEFA).
• Ensures data quality and security for confidential financial data.

Skills

Data analysis

SQL scripting

Python

R

SAS

Excel

Education

Bachelor's degree

Tools

CAPPS Fin

CAPPS Financials

PeopleSoft

TOAD

SQL

Visual Basic

Job description

Career Opportunities: Data Analyst III (Office of Finance) (22017)

Posting ID22017-Posted10/01/2026-Dept of Family & Protectve Svc-Deputy CFO-Business and Financial Operations-Eligible for Telework-b. $3000 - $4999 per month

The Texas Department of Family and Protective Services (DFPS) works to build on strengths of families and communities to keep children and vulnerable adults safe, so they thrive. We do this through investigations, services, and referrals.

What You Get Beyond Your Paycheck

When you join the State of Texas, your monthly paycheck is just one part of your real income. Our benefits provide extra value that many private employers simply don’t match—often adding hundreds of dollars each month to what you take home or save.

Here’s what you get as a full-time employee:

• 100% paid health insurance for you, and 50% paid for eligible family members—saving you hundreds every month in out-of-pocket medical costs
• Retirement plans with lifetime monthly payments after five years of state service, plus options to save even more with 401(k) and 457 plans
• Paid vacation, holidays, and sick leave so you can recharge and take care of life outside work (that’s time off you’re actually paid for)
• Optional dental, vision, and life insurance —at rates much lower than most private plans
• Flexible spending accounts for added tax savings on health and dependent care
• Employee discounts on things like gym memberships, electronics, and entertainment

Functional Title:Data Analyst III (Office of Finance)
Job Title:Data Analyst III
Agency:Dept of Family & Protectve Svc
Department:Deputy CFO
Posting Number:22017
Closing Date:10/15/2026
Posting Audience:Internal and External
Occupational Category:Business and Financial Operations
Salary Range:$4,801.16-$7,761.50
Pay Frequency: Monthly
Salary Group:TEXAS-B-22
Shift:Day
Additional Shift:None
Telework:Eligible for Telework
Travel:Up to 5%
Regular/Temporary:Regular
Full Time/Part Time:Full time
FLSA Exempt/Non-Exempt:Exempt
Facility Location:
Job Location City:AUSTIN
Job Location Address:4900 N LAMAR BLVD
Other Locations:None
MOS Codes: No military equivalent

Brief Job Description:

The Data Analyst III reports to the Financial Data Team Manager within the Office of Finance. The position performs moderate complex functions involving analysis, quality, research, and reconciliation. Work entails querying and compiling data, developing technical solutions such as creating databases, developing software applications using computer languages, as well as other maintenance related functions such as performing data quality metrics. The position prepares financial reports, identifies data trends, and establishes data quality metrics and measures to support organizational improvements.

Full time remote worker.

Essential Job Functions (EJFs):

Performs data integrity functions in CAPPS Fin, subsystems, and applications involving the maintenance of financial data fields within the chart of accounts, establishing/updating data fields, performing combo edit rule maintenance to establish correct combinations of data fields, performing system tree maintenance to establish and maintain correct data hierarchy within CAPPS Fin and other subsystems and applications. Maintains electronic data interface (EDI) layout to ensure compliance with PeopleSoft and IRS regarding data formatting.

Serves as the security coordinator for the internal and external financial systems. Reviews, analysis, and determines the appropriateness of the roles, identifies conflicts, and recommends changes. Performs user access audits and certifications. Recommends changes and improvements to ensure compliance with Comptroller policies and best practices.
Writes, extracts, queries, and compiles data for the completion of audit requests, open records requests, and ad hoc requests requiring use of computer programming languages such as SQL and Visual Basic. Performs data analysis using statistical tools such as SAS and TOAD and applying industry standard methods and techniques.
Prepares data sets, financial and technical reports to be used for agency’s major reports such as the Monthly Financial Report (MFR), Legislative Annual Report (LAR), base reconciliation, Annual Financial Report (AFR), Schedule of Expenditures of Federal Awards (SEFA) and 1099 reporting by extracting, querying and compiling data out of CAPPS HR, CAPPS Financials, and other databases for presentation, identifying trends, inconsistencies, anomalies, redundancies, and for making decisions and recommendations to make data revisions to present a more accurate picture of the data and aid in management decision-making .
Attends work regularly in accordance with agency leave policy.

Knowledge, Skills and Abilities (KSAs):

Knowledge of data analysis and statistical data modeling and security protocols for data access, data handling, and protecting and distributing confidential data. Advanced Microsoft Office (Excel, Word, PowerPoint), business objects, financials software/applications, claims processing engines, SQL, R, SAS, Python. Knowledge of data quality and integrity processes and techniques for process improvement.

Skill in managing multiple and competing priorities and identifying problems, evaluating alternatives, and implementing solutions. Skill in various programming languages and usage of computer and system tools and applications. Skill in how to explain, advocate, express facts and ideas, and negotiate with individuals and groups, internally and externally.
Ability to perform data analysis, statistics, data visualization, methods of funding, program rules. Ability to recommend, design, develop, and implement new technology/ work processes that benefit the organization. Ability to produce results through planning, development and implementation automated solutions and business processes. Ability to build, establish, and maintain effective working relationships with diverse groups. Ability to work effectively in a team environment.

Registrations, Licensure Requirements or Certifications:

N/A

INITIAL SCREENING CRITERIA

Experience writing scripts or code to extract, compile and present data or models using computer programming languages such as SQL is required.
Experience in data analysis, research, and compilation is required.

Knowledge of budget and general ledger financial reporting preferred.

Graduation from an accredited four-year college or university with major coursework in data science, business, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field is generally preferred.

Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited tothose listed in this posting. All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information please see the Texas State Auditor’s Job Descriptions, Military Crosswalk and Military Crosswalk Guide at Texas State Auditor's Office - Job Descriptions . You may also contact the DFPS Military Liaison at [e-mail] with additional questions.

Applicants selected for hire must pass a background check and if applicable a driver’s record check.

State of Texas employees are required to maintain the security and integrity of critical infrastructure as defined in Section 117.001(2), State of Texas Business and Commerce Code. Applicants selected for hire comply with this code by completing related training and abiding by agency cybersecurity and communications system usage policies.

As a state agency, DFPS is required by Texas Administrative Code (TAC 206 and 213) to ensure all Electronic Information Resources (EIR) follow accessibility standards. The staff must be familiar with the WCAG 2.1 AA and Section 508 to create accessible content including but not limited to; Microsoft Office documents, Adobe PDFs, webpages, software, training guides, video, and audio files.

DFPS uses E-Verify. You must bring your I-9 documentation with you on your first day of work. Employees must provide documentation to DFPS to show their identity and authorization to work in the US. Please review the following link for authorized documents: https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents .

In compliance with the Americans with Disabilities Act (ADA), HHS/DFPS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS/DFPS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.