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: DDS Systems Analyst V
Job Title: Systems Analyst V
Agency: Dept of Family & Protectve Svc
Department: DATA & DECISION SUPPORT/DDS
Posting Number: 16662
Closing Date: 11/18/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 10%
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: Austin; Abilene; Alamo; Alice; Alpine; Alvin; Amarillo; Anahuac; Andrews; Angleton; Anson; Aransas Pass; Archer City; Arlington; Athens; Atlanta; Bacliff; Ballinger; Bandera; Bastrop; Bay City; Baytown; Beaumont; Bedford; Beeville; Bellville; Big Spring; Boerne; Bonham; Borger; Bowie; Brady; Breckenridge; Brenham; Brownfield; Brownsville; Brownwood; Bryan; Burnet; Caldwell; Cameron; Canton; Canutillo; Carlsbad; Carrizo Springs; Carrollton; Carthage; Center; Centerville; Childress; Clarksville; Cleburne; Cleveland; Coldspring; Columbus; Conroe; Copperas Cove; Corpus Christi; Corsicana; Crockett; Crosby; Crystal City; Cuero; Cypress; Daingerfield; Dallas; Decatur; Del Rio; Denton; Dickinson; Dumas; Duncanville; Eagle Pass; Eastland; Edinburg; El Paso; Elgin; Elsa; Ennis; Fabens; Falfurrias; Floresville; Fort Stockton; Fort Worth; Fredericksburg; Gainesville; Galveston; Garland; Gatesville; Georgetown; Giddings; Gilmer; Goliad; Gonzales; Graham; Granbury; Grand Prairie; Grapevine; Greenville; Hallettsville; Hamilton; Harlingen; Haskell; Hearne; Hemphill; Hempstead; Henderson; Hereford; Hillsboro; Hondo; Houston; Humble; Huntsville; Hurst; Irving; Jacksonville; Jasper; Johnson City; Jourdanton; Karnes City; Katy; Kaufman; Kerrville; Killeen; Kingsville; Kingwood; Kirbyville; La Grange; Lake Jackson; Lake Worth; Lamesa; Lampasas; Lancaster; Laredo; Levelland; Lewisville; Liberty; Linden; Littlefield; Livingston; Llano; Lockhart; Longview; Lubbock; Lufkin; Lumberton; Madisonville; Marble Falls; Marfa; Marlin; Marshall; Mcallen; Mckinney; Mercedes; Meridian; Mesquite; Mexia; Midland; Mineola; Mineral Wells; Mission; Monahans; Mount Pleasant; Mount Vernon; Nacogdoches; Navasota; New Boston; New Braunfels; Odessa; Orange; Palestine; Pampa; Paris; Pasadena; Pearland; Pearsall; Pecos; Perryton; Pharr; Pittsburg; Plainview; Plano; Pollok; Port Arthur; Port Lavaca; Presidio; Quitman; Raymondville; Refugio; Richardson; Richmond; Rio Grande City; Robstown; Rockwall; Rosenberg; Round Rock; Rowlett; Rusk; San Angelo; San Antonio; San Benito; San Juan; San Marcos; San Saba; Schertz; Seguin; Seminole; Seymour; Sherman; Silsbee; Sinton; Snyder; Socorro; Sonora; South Houston; Stephenville; Sugar Land; Sulphur Springs; Sweetwater; Taylor; Temple; Terrell; Texarkana; Texas City; The Woodlands; Tomball; Trinity; Tyler; Uvalde; Van Horn; Vernon; Victoria; Waco; Washington; Watauga; Waxahachie; Weatherford; Webster; Weslaco; Wharton; Wichita Falls; Woodville; Zapata
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
Brief Job Description:
DDS Systems Analyst - This position is part of the Data and Decision Support (DDS) division within the Office of Data and Systems Improvement (ODSI). The position will report to the Ad Hoc unit manager.
The ODSI mission is to ensure effective coordination, communication and consistency around data reporting and how it’s used in understanding and improving performance and outcomes. DDS supports that mission by supplying data and reports that empower DFPS leadership and stakeholders to the best decisions backed by relevant, high-quality information.
DDS is responsible for the production of agency data that encompasses the work of DFPS. This includes data about abuse and neglect investigations of children, adults and other vulnerable Texans, as well as data about children in conservatorship, prevention efforts, financial information, and other legislatively mandated reporting, Data is produced for both internal and external stakeholders, including other state agencies, open records requests, and media requests. DDS conducts quality assurance reviews of data to ensure consistency and the validity of data produced. DDS also creates and maintains online reports.
We’re looking for someone who wants to dedicate their SQL data mining/reporting skills, problem solving/critical thinking skills, and attention to detail to helping DFPS serve and protect vulnerable Texans. At DDS we take the data collected during the field work done by DFPS, and work to make that data available and digestible to a diverse audience. We create data reports for both internal and external stakeholders to help the agency make better data driven decisions. We need someone who thrives in a fast-paced environment with changing priorities, who is intellectually curious, and who wants to understand what the data means. This position needs someone who is meticulous, adheres to standards, has an eye for quality assurance, and is not afraid of pointing out mistakes or inconsistencies.
Essential Job Functions (EJFs):
The specific job functions include:
- Creating complex original SQL coding extracted from multiple large agency and external databases, gathering requirements for data requests, and evaluating and/or modifying existing code to produce both internally and externally releasable reports for the agency. (40%)
- Providing quality assurance reviews for the work products of other analysts. (40%)
- Documenting, designing, validating, and implementing reports for multiple areas of specialization using selected DFPS methodology and reporting tools. (10%)
- Promoting and demonstrating appropriate professional behavior and communication among coworkers and all work-related contacts. (5%)
- Participating in data system design meetings for new agency initiatives to ensure the agency’s ability to report applicable data. (3%)
- Serving as a lead analyst on assigned projects of varying levels of complexity and acting as mentor/on-the-job trainer for new and junior analysts. (2%)
Knowledge, Skills and Abilities (KSAs):
Knowledge of:
- relational databases
- data processing practices and theory
Skill in:
- writing complex original code and revising existing code in SQL and/or PL/SQL
- researching, troubleshooting, and solving data issues and complex problems
- analysis, problem solving, data comprehension, reporting methodologies, math, and designing statistical reports and charts/graphs
- using selected software including TOAD, Oracle SQL Developer, Databricks, and/or Bitbucket
Ability to:
- analyze, consolidate, and interpret complex data, procedures, and systems and write original or revise existing program code as required
- perform detailed work accurately and timely
- learn and apply new technology and skills
- work under stressful conditions and manage multiple projects with tight deadlines
- adapt and modify behavior in response to changes in situations or priorities
- present information to a variety of audiences (verbally and in writing) and to communicate clearly, concisely, and effectively
- work hours as needed to meet defined deadlines and support the agency’s critical reporting requirements
Registrations, Licensure Requirements or Certifications:
N/A
Initial Screening Criteria:
DFPS programmatic experience is preferred.
Systems Analyst IV
- Experience writing original SQL code, and
- Experience using TOAD/SQL*Developer or other software development tool, and
- Experience with relational databases, and
- Experience creating reports in Excel, and
- Ability to understand and present complex data products to a wide audience
Systems Analyst V
- All of the above criteria, and
- Experience in developing standards or ensuring data and report quality or CQI, or
- Experience in leading meetings or workgroups, or
- Experience in being a team lead, a mentor, or supervisor in a technical setting
Additional Information:
This position may be filled as a Systems Analyst IV, or V. Salary range is between $5,098.00 and $ 8,561.49 (monthly) depending on the level at which the position is filled and the department budget. The position is filled in accordance with agency policies. The person in this position will perform their job duties remotely (telework, work from home) within the state of Texas and will keep regular work hours in accordance with agency policy. The position may require in person attendance in Austin for certain meetings.
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.
SQL data mining/reporting; SQL/PL-SQL coding; QA reviews; data documentation and reporting; TOAD/SQL Developer; relational databases; Excel reporting; ability to present data clearly.
Key Responsibilities
- writing SQL
- QA reviews
- documenting reports
Skills & Tools
TOAD, Oracle SQL Developer, Databricks, Bitbucket
Job Details
- Category: Information Technology
- Seniority: Senior Level
- Commitment: Full Time
- Workplace: Remote — Austin, Texas, United States
- Salary: USD 69,571 – 114,099 / year
- Languages: English
About Texas.gov | The Official Website of the State of Texas
Public sector technology services provider. — Industry: Information Technology