Remote Data Analyst III — Finance & Analytics

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

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.