Data Analyst IV

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

You also might qualify for Public Service Loan Forgiveness, which could help you pay off federal student loans faster.

You can see all the details here: ERS recruitment brochure

Functional Title: Data Analyst IV Job Title: Data Analyst IV Agency: Dept of Family & Protectve Svc Department: Deputy CFO Posting Number: 22131 Closing Date: 10/20/2026 Posting Audience: Internal and External Occupational Category: Business and Financial Operations Salary Range: $5,425.33 - $8,886.16 Pay Frequency: MonthlySalary Group: TEXAS-B-24 Shift: Day Additional Shift:  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:  MOS Codes: 0231,0239,0271,0291,2652,2659,6046,6049,8051,8825,8846,8850,14N,14NX,15AX,16KX,181X,182X,183X,1D7X1 1N0X1,1N1X1,1N4X1,1N7X1,255A,25B,26B,350F,350G,351L,351M,352N,35F,35G,35L,35M,514A,514B,5I0,5I1A 65FX,65WX,681X,682X,683X,781X,782X,783X,86P0,8K000,CT,CTR,CTT,CYB10,CYB11,CYB12,CYB13,CYB14,IS,ISM ISS,IT,ITS,SEI15,SEI23 Brief Job Description:

The Data Analyst IV reports to the Financial Data Team Manager within the Office of Finance. The position performs complex data analysis, reporting, and data management activities in support of DFPS financial and operational objectives. Provides technical expertise in analyzing, interpreting, validating, and presenting complex data from multiple systems and sources. Develops data-driven solutions, identifies trends and anomalies, improves data quality, and translates complex information into actionable insights for divisional staff.

Serves as an analytical resource and provides guidance on data practices, reporting methodologies, system requirements, and process improvements. Works collaboratively with Office of Finance staff to ensure data is accurate, reliable, accessible, and aligned with agency requirements. This position prepares reports, dashboards, presentations, and other materials that clearly explain results in an effort to support data-based decisions.

Full time remote worker.

Essential Job Functions (EJFs)

Performs data analysis using statistical tools such as SQL, Visual Basic, and TOAD and applying industry standard methods and techniques. Writes, extracts, queries, and compiles data to prepare financial 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. Provides other routine, ad hoc, and customized reports based on divisional needs. Being responsive to open records requests and audit inquiries.

Take ownership for improving data quality by establishing standards, business rules, and quality controls. Leads data quality activities by evaluating completeness, accuracy, consistency, and reliability across multiple systems. Develops and implements data validation and reconciliation processes that support root cause analysis and corrective actions. Will establish and maintain quality metrics, measures against results, and recommend necessary improvements to data quality.

Supports data integration and interoperability between financial, operational, and reporting systems. Evaluates the impact of CAPPS Financials system changes on data structures, reporting, interfaces, and downstream processes. Maintains electronic data interface (EDI) layout to ensure compliance with PeopleSoft and IRS regarding data formatting. Ensure data in reporting databases and CAPPS Financials is updated appropriately and timely.

Meets with staff to identify data analytics needs, respond in an accurate and timely manner to reporting or system-related questions, and recommends visualization best practices.

Knowledge, Skills and Abilities (KSAs)

Knowledge of data management and data governance principles, data quality and validation methodologies, relational databases and data structures, and state and federal financial reporting requirements. Knowledge of business intelligence and data visualization concepts. Knowledge of data models, database design development, data mining, and segmentation techniques.

Skill in SQL and data querying, data analysis and interpretation, data reconciliation, and validation. Skills in creating and maintaining technical documentation. Skills in presenting complex information to non-technical audiences. Advanced skills in Microsoft Excel and other analytical/reporting tools as well as working with multiple data sources and enterprise systems.

Ability to analyze large, complex, and disparate datasets; translate business requirements into technical data solutions; identify root causes; and recommend sustainable solutions. Ability to manage multiple complex projects and priorities; work independently; and communicate complex analytical findings clearly and effectively. Ability to exercise sound judgment when handling sensitive financial and organizational information. Ability to compile, review, and analyze data.

Registrations, Licensure Requirements or Certifications

N/A

Initial Screening Criteria

Experience writing and maintaining SQL scripts required. Experience creating visualizations utilizing Microsoft Power BI or Tableau applications preferred. Experience analyzing financial data.

Current or prior DFPS experience preferred.

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

Experience and education may be substituted for one another on a one-to-one year basis.

Additional Information

N/A

Review our Tips for Success when applying for jobs at DFPS, DSHS and HHSC.

Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to those 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 dfpsmilvets@dfps.texas.gov 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.