PCS Reporting Systems Analyst

HEALTH AND HUMAN SERVICES COMMISSION; Lampasas (TX); On-site; USD 65,000 - 106,000; Full time

Benefits offered by this job

Telework eligible

Health insurance

Job summary

Texas Department of Family and Protective Services (DFPS) is seeking a Systems Analyst to support the PCS Reporting unit. This role focuses on designing, validating, and delivering data reports critical for safeguarding children and vulnerable adults.

The position involves collaboration across agency staff, data systems, and stakeholders to ensure accurate, timely reporting and to mentor junior analysts as needed.

Qualifications

• Relational databases knowledge and data processing basics.
• Ability to analyze complex data and translate to reports.
• Knowledge of reporting methods, math and statistics.
• Creative problem solving under tight deadlines.
• Strong SQL and Excel skills; willingness to learn new tools.

Responsibilities

• Designing, validating, and implementing report methodologies and documenting procedures.
• Developing programming code and report design to translate requests into useful reports.
• Participating in data system design meetings for new agency initiatives.
• Interacting with program staff and analysts to ensure requirements are met and reviewed.
• Performing quality assurance to ensure report accuracy for distribution.
• Serving as lead analyst and mentor on assigned projects.

Skills

SQL

Excel

Data analysis

Data reporting

Communication

Tools

SQL

Job description

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: PCS Reporting Systems Analyst Job Title: Systems Analyst V Agency: Dept of Family & Protectve Svc Department: DATA & PERFORMANCE REPORT/RMD Posting Number: 19587 Closing Date: 08/20/2026 Posting Audience: Internal and External Occupational Category: Computer and Mathematical Salary Range: $5,797.66- $9,508.25 Pay Frequency: Monthly Salary Group: TEXAS-B-25 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: LAMPASAS Job Location Address: 204 RIVERVIEW DR Other Locations: Austin MOS Codes: 0171,8848,8858,181X,182X,1D7X1,255A,255S,25B,25D,25H,26B,62E,681X,682X,781X,CTI,CTM,CTR,CYB10,CYB11 ISM,IT,Z Prefix

Job Description

DAPR Systems Analyst III - V:
This Systems Analyst will be part of the Department of Family and Protective Services (DFPS) Office of Data and Systems Improvement (ODSI). The position will act as a systems analyst in the Data and Performance Reporting Division, specifically for the Unit responsible for Purchased Client Services (PCS) Reporting. DAPR works to build a preeminent system for reporting on the protection of children and vulnerable adults from abuse, neglect, and exploitation by partnering with DFPS leadership to provide data to inform decision‑making at the highest levels of the agency as well as for our community partners, legislative oversight entities, and the general public.
The DAPR Division is responsible for provision of agency statistical data including Legislative Budget Board performance measures, operating budget, legislative appropriation request, agency Online Data Book, various routine and ad hoc management reports, data requested by the legislature and other public officials, and data reported to the federal government. The division also provides data requested by the media and public via the Public Information Act (open records) as well as data related to both state and internal audits, grants, studies, and data sharing projects with other public interests. The division is responsible for conducting quality assurance review of any data to be released outside the agency to ensure validity and consistency of reported data. The division also is responsible for development of data warehouse online reports and the supporting specialized tables and/or elements.
This position may be filled as a Systems Analyst III, IV, or V with a career ladder option for future promotions.

Essential Job Functions

We're looking for someone who wants to dedicate their talents and abilities to serving and protecting the most vulnerable Texans. Someone who is excited to be a part of an established team of highly skilled, capable, and motivated individuals. We want someone who is intellectually curious, eager to create original programming code and evaluate and/or modify existing programs at varying levels of complexity and who's not afraid to think outside the box for innovative and new ways of doing things. We need someone who can engage a variety of people across the agency, building strong relationships and support for the work of our division.

The Specific Job Functions Include

• Designing, validating, and implementing report methodologies for multiple areas of specialization while documenting processes and procedures for technical and non‑technical users.
• Developing programming code and report design to ensure user requests are properly translated into useful reports.
• Participating in data system design meetings for new agency initiatives to provide strategic guidance and ensure the agency's ability to report relevant data.
• Interacting routinely with agency program staff, division managers, regional staff, and other analysts to provide strategic guidance and ensure requirements are met and work products are appropriately reviewed and validated.
• Performing quality assurance tasks to ensure accuracy of reports created by colleagues within the division for distribution to the agency or the public.
• Eventually serving as a lead analyst on assigned projects of any level of complexity and acting as mentor and on‑the‑job trainer for new and junior analysts when capable.

Registrations, Licensure Requirements or Certifications

None

Knowledge, Skills And Abilities

• Understanding of and demonstrated skill in relational databases, data processing practices and theory.
• Ability to analyze, consolidate, and interpret complex data, procedures, and systems; and to write or revise program code as required.
• Comprehension of data solutions, reporting methodologies, math, and statistical report design.
• An ability to creatively solve complex data problems, apply new technology, and perform detailed work accurately under stressful conditions while managing multiple projects and tight deadlines.
• Technical Skills - in using SQL code, Excel, and the willingness to learn selected software as required by the division.
• Communication Skills - the ability to present information to a variety of audiences verbally and in writing and to communicate clearly, concisely, and effectively.
• Ability to work the hours needed to meet defined deadlines and support the agency's mission critical reporting requirements.

Initial Screening Criteria

• Skill in writing SQL code.
• Skill in using Excel (power users are welcome).
• Experience in data extraction and report layout and design.
• DFPS experience preferred.

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 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: .

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-. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.