IT/ OPS Data Analyst IV

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: IT/ OPS Data Analyst IV 
Job Title: Data Analyst IV 
Agency: Dept of Family & Protectve Svc 
Department: IT Operations-Operating 
Posting Number: 8479 
Closing Date: 09/08/2025 
Posting Audience: Internal and External 
Occupational Category: Computer and Mathematical 
Salary Group: TEXAS-B-24 
Salary Range: $5,425.32 - $8,886.16 
Pay Frequency: Monthly
Shift: Day 
Additional Shift: Days (First) 
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: 25B 
IT 
275 
 

The Texas Department of Family and Protective Services (DFPS) is currently seeking a Data Analyst IV for a full-time position within the IT Operations team of our IT Department.

The Data Analyst IV works under the supervision of the IT Operations Data Management Team. This position performs highly complex (mid-level) database development work. The work involves coordinating the planning, development, maintenance, and monitoring of integrated database systems; evaluating and reviewing database policies and procedures; and maintaining data integrity. This position interfaces with DIR, other Health and Human Services agencies, the outsourced network provider, the data center service provider, and other entities to implement, maintain, and support the technical platform of the agency. The Data Analyst works with the IRM team in support of application development and maintenance efforts. This position should have knowledge and understanding of data warehouse dimensional modeling as well as modern data platforms such as Databricks and should be able to leverage ETL tools and frameworks to design, maintain, and optimize data pipelines.

The mission of DFPS is to protect children, the elderly, and people with disabilities from abuse, neglect, and exploitation by involving clients, families, and communities. We are looking to grow our teams with people like you who share our energy and enthusiasm to get behind our mission of protecting those among us who are most in need.

This position is 100% teleworking within the state of Texas and requires that the candidate maintain personal wi-fi and webcam capabilities during work hours to perform their duties. This position often works outside normal business hours, nights, and weekends. This position may require occasional onsite work as needed.

This position is a full-time position that includes other State of Texas benefits as described in this SAO site:  http://www.sao.texas.gov/SAOReports/ReportNumber?id=18-704 

Essential Job Functions (EJFs): 

• Works with stakeholders to understand their technological needs and issues in performing their day-to-day work. 
• Collect, clean, and integrate data from disparate sources using ETL processes and modern data engineering tools.
• Build, manage, and optimize data pipelines using Databricks and cloud-based big data environments.
• Apply Master Data Management (MDM) practices to ensure data consistency, quality, and governance across domains.
• Analyze large datasets to identify patterns, trends, and actionable insights; prepare reports, dashboards, and visualizations for stakeholders.
• Work closely with IT and business teams to define, document, and implement data architecture standards and integration processes.
• Collaborate on the development and maintenance of data models, both logical and physical, that support analytics and operational needs.
• Assist in developing and documenting procedures for data ingestion, transformation, storage, and retrieval.
• Ensure compliance with data security, privacy, and quality standards.
• Provide guidance and training to team members on Databricks, MDM concepts, and ETL best practices.
• Support continuous improvement of data workflows, including performance tuning and automation.
• Assist in the design, documentation, and implementation of processes and procedures necessary to backup, save, retrieve, and recover databases in support of development teams and from hardware and software failures.
• Assist in database performance monitoring and implementation of efficiency improvements.
• Provide proactive and reactive database management support and training to development teams and other database customers.
• Work together with development teams, architects, web/java developers, database administrators, system administrators, business analysts, and other team members in performing work tasks.
• Performs other duties as assigned.

Knowledge, Skills, and Abilities (KSAs):

• Knowledge of relational and non-relational database systems, data modeling, and SQL programming.
• Knowledge of Databricks architecture and notebook-based analytics workflows.
• Knowledge of MDM concepts and tools for managing golden records and enterprise reference data.
• Knowledge of ETL/ELT tools (e.g., Informatica, Talend, Azure Data Factory, SSIS) and cloud-based data integration platforms.
• Skill in building, maintaining, and troubleshooting data pipelines.
• Skill in creating dashboards and visualizations using tools such as Tableau or Power BI.
• Ability to identify and define data requirements and transform them into actionable technical solutions.
• Strong problem-solving and critical thinking skills applied to complex data challenges.
• Ability to communicate effectively with both technical and non-technical audiences.
• Knowledge of database structures and theories, current database technologies, and data analysis techniques
• Knowledge of the principles, practices and techniques of computer programming and systems design.
• Skill in providing responsive and effective customer service.
• Ability to communicate effectively both verbally and in writing, to serve as a technical consultant to technical colleagues, to clearly and accurately document relevant issues, and to prepare accurate, concise, reliable reports.
• Skill in advanced trouble shooting. 

Registrations, Licensure Requirements or Certifications:

N/A

Initial Screening Criteria: 

• Graduation from an accredited College or University with a degree in computer science, computer information systems, management information systems, or a related field. Work experience may be substituted for education on a year-for-year basis.
• Preferred: Five (5) Years’ full-time experience in data analysis, data integration, and ETL processes.
• Preferred: One (1) Year full-time experience with Databricks and cloud-based analytics platforms.
• Preferred: One (1) Year full-time experience programming Oracle SQL/PLSQL and Unix shell script.
• Preferred: One (1) Year full-time experience of MDM principles.
• Preferred: One (1) Year full-time experience with at least one major ETL tool or framework and a modern visualization platform.

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.