Texas Health and Human Services Commission
WHY WORK FOR DFPS?
The Texas Department of Family and Protective Services (DFPS) is responsible for protecting the unprotected - children, elderly, and people with disabilities - from abuse, neglect, and exploitation. DFPS accomplishes this responsibility by employing over 12,000 workers who live up to the agency's Mission, Vision, & Values in service to the citizens of Texas. DFPS is not only a qualifying organization for the Public Service Loan Forgiveness Program but also offers excellent health benefits, special discounts on many products and services through the Discount Purchase Program, longevity pay, generous paid leave, access to the Wellness program, lifetime retirement annuity, Texa$aver 401(k) and 457 Programs under the Employees Retirement System of Texas.
Functional Title:
ODSI Data Analyst IV Job Title:
Data Analyst IV Agency:
Dept of Family & Protectve Svc Department:
DATA & DECISION SUPPORT/DDS Posting Number:
10973 Closing Date:
12/05/2025 Posting Audience:
Internal and External Occupational Category:
Computer and Mathematical Salary Group:
TEXAS-B-24 Salary Range:
$5,425.33 - $7,718.92 Pay Frequency:
Monthly 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 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
Job Description
The Department of Family and Protective Services (DFPS) Data Infrastructure & Technology (DIT) Division Data Analyst IV is selected by and reports to the DIT Manager. This position performs advanced (senior level) computer data analysis work involving analyzing and identifying user requirements, procedures, and problems to automate processing or to improve existing systems. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.
Work involves building and maintaining the infrastructure for data collection, storage, and processing. The duties entail creating data pipelines, ensuring data quality and security, optimizing databases, and collaborating with other ODSI staff as well as other DFPS staff to make data accessible for analysis and business decisions.
Current processes within DIT are implemented using Unix Shell scripting for job scheduling, SQL and/or PL/SQL in Toad for the ETL logic, .ASP and VBScript/HTML for reporting. DIT division with other ODSI staff as well as other DFPS staff are working towards modernizing the Data Warehouse ETL Logic using Databricks as the Integrated Data Platform to curate the data for the reporting layer that will be leveraged using Excel reports/ Tableau dashboards. Data Governance is implemented using Informatica to hold the master data for DFPS. This position may have the ability to leverage and use these tools and technologies to implement the data warehouse solution for creating new solutions or when evaluating and modifying existing programs.
The analyst creates original programming logic and evaluates and/or modifies existing programs of any level of complexity to consider changes in requirements. The analyst may prepare diagrams and logic flowcharts for detailed coding and for the documentation of programming work. The analyst may be required to review work products developed by other analysts and to interact with the agency Program staff, division managers, regional staff, and/or other analysts to ensure requirements are met and that all work products are appropriately reviewed and validated.
The analyst may interact with staff from other agencies and outside entities as required to facilitate data collaboration, obtain required work products, or consultation. The analyst participates in system design meetings for new agency initiatives to ensure the agency's ability to report applicable data. The analyst may serve as a lead analyst on assigned projects of any level of complexity and may act as a mentor and on-the-job trainer for new or junior analysts.
Registrations, Licensure Requirements or Certifications:
N/A
Essential Job Function (EJF):
Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned. Coordinate and/or participate in the development and execution of enterprise-level strategies and technical direction, including establishing processes and procedures for executing and maintaining technology road maps. Coordinate with users to identify system requirements, develop functional design specifications to meet requirements, and solve complex operational problems. Coordinates with end-users and stakeholders to clarify the specifications and requirements are complete to provide recommendations on operational issues. Identifies solutions to any complex problems users may have and provides proof of concept or a design solution to meet their needs when appropriate. Review existing queries and explain plans for performance issues and recommend alternative ways to resolve performance issues. Provides analysis and review of Structured Query Language (SQL), Procedural Language/Structured Query Language (PL/SQL) or other code for validity. Completes MDC (monthly data-compilation) support on a rotation schedule after the first few months of being on the job. Analyze user needs, define the system's scope, document requirements, and translate the user needs and requirements into functional specifications for the design of business systems.
Participate in requirements and design meetings with stakeholders, requestors and users as needed to identify scope, translate user's needs into proper requirements and develop the right design for the ETL to automate the report on the Safety Net. Participates in meetings with stakeholders, requesters, and users to present and discuss finalized products.
Develop the ETL logic for the Data Warehouse tables and implement the reports using the current process identified in the job description. After system review, develop and prepare reports and recommendations to include project scope, work and cost estimation for work assigned and participate in project planning meetings. Develops and prepares optimum solutions for systems improvements, recommendations to include procedures, reports, upgrades, revisions, business process improvements, etc. Familiarity with modernization tools identified in the job description is essential for this role to be available to participate in project planning meetings, system review, development and recommendation for new data warehouse solutions for data lake implementation and reporting. Aids others within ODSI and other DFPS staff in the assessment, development and production of ETL logic to develop the back-end tables for reporting, dashboard needs, Databook, automation for reporting LBB performance measures, FCL (Foster Care Litigation reports) and other data and statistical reports as needed. Analyzes new or existing procedures, information systems, or utility programs for efficiency and effectiveness. Analyzes on an ongoing basis existing functionality (code / procedures / systems) to determine refactoring and reusability can be achieved. Analyzes application and system functionality and interprets reporting requirements to develop technical specifications. Coordinate projects that involve cross-functional agency systems and other state entities, including planning and scheduling during project development and implementation stages. Coordinates meetings internally within division staff and across agency staff for requirements and design session or clarifying reporting needs. Provides data, reporting, and technical support subject matter expertise to agency staff and management and external entities regarding agency data warehouse and reporting systems, functions and processes. Managers multiple, complex assignments and projects and analyzes data requests.
Coordinate, plan, and schedule the installation of or training for new or revised systems and define business process requirements. Coordinate, plan, and schedule training for new and existing staff on new technical systems and processes. Coordinate, plan, and schedule training for new and existing staff on revised technical systems and processes. Coordinates testing of data and applications when systems are upgraded and trains staff, as appropriate.
Knowledge Skills Abilities
Knowledge of relational databases and database development is the best practice. Knowledge of Structured Query Language (SQL), Procedural Language/Structured Query Language (PL/SQL) Knowledge of database design, database development, data mining and writing SQL queries. Knowledge in data analysis, data extraction, translation, and load (ETL) is required. Knowledge of record keeping, including security procedures for handling, protecting, and distributing confidential data. Knowledge and Work Experience in group dynamics. Skill in using software tools such as SQL*Plus, TOAD, Oracle, SQL Developer, Business Intelligence tools etc. Skill in using Microsoft Suite products such as Microsoft Word, Microsoft Excel, PowerPoint etc. Skill is using Databricks as a platform for Data Warehousing to ingest, transform, govern and analyze data is preferred. Skill in using Informatica for data governance, master data management, data quality is preferred. Skill in researching and troubleshooting data issues and solving complex problems. Skill in analysis, problem solving, data comprehension, reporting methodologies, math, and designing statistical reports and charts/graphs. Skills in planning, scheduling and prioritizing work assignments. Ability to analyze systems, procedures, problems and develop solutions. Ability to compile, review and analyze data; to prepare reports; to maintain accuracy and attention to detail; to communicate effectively; and to provide guidance to others. Ability to maintain effective relations with all levels of staff and management as well as external entities Ability to work hours as needed to meet defined deadlines and support the agency's mission critical reporting requirements. Ability to work under stressful conditions and manage multiple projects and tight deadlines. Ability to develop Report layout/design/implementation is required. (Using any reporting tools- Example: Excel, Power BI, Tableau, ASP & VB Script etc.) Ability to perform detailed work accurately and in accordance with standards. Initial Criteria
Experience in writing SQL is required. Experience in writing PL/SQL code is required. Experience in using MS Word and Excel is required. Experience in using any one of these software tools such as Oracle or Sql Plus or Sql Developer or Toad is required for database development. Experience in data extraction, transformation, and load (ETL) is required. Experience in database design concepts and implementation is required. Experience in Report layout/design/implementation is preferred. Skills and familiarity with tools like Databricks and Informatica is preferred. 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 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.
The Texas Department of Family and Protective Services (DFPS) is responsible for protecting the unprotected - children, elderly, and people with disabilities - from abuse, neglect, and exploitation. DFPS accomplishes this responsibility by employing over 12,000 workers who live up to the agency's Mission, Vision, & Values in service to the citizens of Texas. DFPS is not only a qualifying organization for the Public Service Loan Forgiveness Program but also offers excellent health benefits, special discounts on many products and services through the Discount Purchase Program, longevity pay, generous paid leave, access to the Wellness program, lifetime retirement annuity, Texa$aver 401(k) and 457 Programs under the Employees Retirement System of Texas.
Functional Title:
ODSI Data Analyst IV Job Title:
Data Analyst IV Agency:
Dept of Family & Protectve Svc Department:
DATA & DECISION SUPPORT/DDS Posting Number:
10973 Closing Date:
12/05/2025 Posting Audience:
Internal and External Occupational Category:
Computer and Mathematical Salary Group:
TEXAS-B-24 Salary Range:
$5,425.33 - $7,718.92 Pay Frequency:
Monthly 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 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
Job Description
The Department of Family and Protective Services (DFPS) Data Infrastructure & Technology (DIT) Division Data Analyst IV is selected by and reports to the DIT Manager. This position performs advanced (senior level) computer data analysis work involving analyzing and identifying user requirements, procedures, and problems to automate processing or to improve existing systems. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.
Work involves building and maintaining the infrastructure for data collection, storage, and processing. The duties entail creating data pipelines, ensuring data quality and security, optimizing databases, and collaborating with other ODSI staff as well as other DFPS staff to make data accessible for analysis and business decisions.
Current processes within DIT are implemented using Unix Shell scripting for job scheduling, SQL and/or PL/SQL in Toad for the ETL logic, .ASP and VBScript/HTML for reporting. DIT division with other ODSI staff as well as other DFPS staff are working towards modernizing the Data Warehouse ETL Logic using Databricks as the Integrated Data Platform to curate the data for the reporting layer that will be leveraged using Excel reports/ Tableau dashboards. Data Governance is implemented using Informatica to hold the master data for DFPS. This position may have the ability to leverage and use these tools and technologies to implement the data warehouse solution for creating new solutions or when evaluating and modifying existing programs.
The analyst creates original programming logic and evaluates and/or modifies existing programs of any level of complexity to consider changes in requirements. The analyst may prepare diagrams and logic flowcharts for detailed coding and for the documentation of programming work. The analyst may be required to review work products developed by other analysts and to interact with the agency Program staff, division managers, regional staff, and/or other analysts to ensure requirements are met and that all work products are appropriately reviewed and validated.
The analyst may interact with staff from other agencies and outside entities as required to facilitate data collaboration, obtain required work products, or consultation. The analyst participates in system design meetings for new agency initiatives to ensure the agency's ability to report applicable data. The analyst may serve as a lead analyst on assigned projects of any level of complexity and may act as a mentor and on-the-job trainer for new or junior analysts.
Registrations, Licensure Requirements or Certifications:
N/A
Essential Job Function (EJF):
Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned. Coordinate and/or participate in the development and execution of enterprise-level strategies and technical direction, including establishing processes and procedures for executing and maintaining technology road maps. Coordinate with users to identify system requirements, develop functional design specifications to meet requirements, and solve complex operational problems. Coordinates with end-users and stakeholders to clarify the specifications and requirements are complete to provide recommendations on operational issues. Identifies solutions to any complex problems users may have and provides proof of concept or a design solution to meet their needs when appropriate. Review existing queries and explain plans for performance issues and recommend alternative ways to resolve performance issues. Provides analysis and review of Structured Query Language (SQL), Procedural Language/Structured Query Language (PL/SQL) or other code for validity. Completes MDC (monthly data-compilation) support on a rotation schedule after the first few months of being on the job. Analyze user needs, define the system's scope, document requirements, and translate the user needs and requirements into functional specifications for the design of business systems.
Participate in requirements and design meetings with stakeholders, requestors and users as needed to identify scope, translate user's needs into proper requirements and develop the right design for the ETL to automate the report on the Safety Net. Participates in meetings with stakeholders, requesters, and users to present and discuss finalized products.
Develop the ETL logic for the Data Warehouse tables and implement the reports using the current process identified in the job description. After system review, develop and prepare reports and recommendations to include project scope, work and cost estimation for work assigned and participate in project planning meetings. Develops and prepares optimum solutions for systems improvements, recommendations to include procedures, reports, upgrades, revisions, business process improvements, etc. Familiarity with modernization tools identified in the job description is essential for this role to be available to participate in project planning meetings, system review, development and recommendation for new data warehouse solutions for data lake implementation and reporting. Aids others within ODSI and other DFPS staff in the assessment, development and production of ETL logic to develop the back-end tables for reporting, dashboard needs, Databook, automation for reporting LBB performance measures, FCL (Foster Care Litigation reports) and other data and statistical reports as needed. Analyzes new or existing procedures, information systems, or utility programs for efficiency and effectiveness. Analyzes on an ongoing basis existing functionality (code / procedures / systems) to determine refactoring and reusability can be achieved. Analyzes application and system functionality and interprets reporting requirements to develop technical specifications. Coordinate projects that involve cross-functional agency systems and other state entities, including planning and scheduling during project development and implementation stages. Coordinates meetings internally within division staff and across agency staff for requirements and design session or clarifying reporting needs. Provides data, reporting, and technical support subject matter expertise to agency staff and management and external entities regarding agency data warehouse and reporting systems, functions and processes. Managers multiple, complex assignments and projects and analyzes data requests.
Coordinate, plan, and schedule the installation of or training for new or revised systems and define business process requirements. Coordinate, plan, and schedule training for new and existing staff on new technical systems and processes. Coordinate, plan, and schedule training for new and existing staff on revised technical systems and processes. Coordinates testing of data and applications when systems are upgraded and trains staff, as appropriate.
Knowledge Skills Abilities
Knowledge of relational databases and database development is the best practice. Knowledge of Structured Query Language (SQL), Procedural Language/Structured Query Language (PL/SQL) Knowledge of database design, database development, data mining and writing SQL queries. Knowledge in data analysis, data extraction, translation, and load (ETL) is required. Knowledge of record keeping, including security procedures for handling, protecting, and distributing confidential data. Knowledge and Work Experience in group dynamics. Skill in using software tools such as SQL*Plus, TOAD, Oracle, SQL Developer, Business Intelligence tools etc. Skill in using Microsoft Suite products such as Microsoft Word, Microsoft Excel, PowerPoint etc. Skill is using Databricks as a platform for Data Warehousing to ingest, transform, govern and analyze data is preferred. Skill in using Informatica for data governance, master data management, data quality is preferred. Skill in researching and troubleshooting data issues and solving complex problems. Skill in analysis, problem solving, data comprehension, reporting methodologies, math, and designing statistical reports and charts/graphs. Skills in planning, scheduling and prioritizing work assignments. Ability to analyze systems, procedures, problems and develop solutions. Ability to compile, review and analyze data; to prepare reports; to maintain accuracy and attention to detail; to communicate effectively; and to provide guidance to others. Ability to maintain effective relations with all levels of staff and management as well as external entities Ability to work hours as needed to meet defined deadlines and support the agency's mission critical reporting requirements. Ability to work under stressful conditions and manage multiple projects and tight deadlines. Ability to develop Report layout/design/implementation is required. (Using any reporting tools- Example: Excel, Power BI, Tableau, ASP & VB Script etc.) Ability to perform detailed work accurately and in accordance with standards. Initial Criteria
Experience in writing SQL is required. Experience in writing PL/SQL code is required. Experience in using MS Word and Excel is required. Experience in using any one of these software tools such as Oracle or Sql Plus or Sql Developer or Toad is required for database development. Experience in data extraction, transformation, and load (ETL) is required. Experience in database design concepts and implementation is required. Experience in Report layout/design/implementation is preferred. Skills and familiarity with tools like Databricks and Informatica is preferred. 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 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.