Business Analyst III

• 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

Functional Title: Business Analyst III
Job Title: Information Technology BA III
Agency: Dept of Family & Protectve Svc
Department: Software Development Res-Op
Posting Number: 15161
Closing Date: 04/06/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: Days (First)
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: Austin; Dallas; Fort Worth; Houston; San Antonio
MOS Codes: 8846,8848,8858,14NX,15AX,16KX,181X,182X,1D7X1,255A,25B,26B,62E,681X,682X,781X,782X,CYB10,CYB11,ISM
IT,Z Prefix

As a Business Analyst III on the Application Development team, this position is responsible for performing advanced (senior-level) business and data analysis tasks. This includes gathering, developing, and documenting user stories, defining acceptance criteria, and evaluating and improving business processes and tools. The primary focus of the BA III is to collaborate with internal and external agency stakeholders to analyze, gather, and document reporting requirements and data needs for software development projects, system enhancements, and production defects. This role will work closely with the Data Management team, the ODSI team, and various stakeholders or customers to provide status updates on defects and enhancements while managing and maintaining the backlog of data requirements for ongoing and upcoming initiatives. The ideal candidate should have a strong understanding of the Agile framework, as well as expertise in data manipulation, extraction, and validation processes. Additionally, this role requires knowledge of data warehouse dimensional modeling and experience with leveraging ETL tools and frameworks to design, develop, and optimize data pipelines.

• Performs advanced data analysis to support defect resolution or enhancement projects.
• Gather and document user stories and acceptance criteria.
• Host/Contribute to Agile Scrum events such as Daily Stand ups, Sprint Planning, Refinement sessions, etc.
• Engage with internal and external agency stakeholders to gather and document reporting requirements and data needs.
• Contribute, Maintain, and prioritize the backlog for the Data Management team.
• Provide regular updates to agency customers and stakeholders on the status of defects and enhancement requests.
• Work with ETL tools and frameworks to design, maintain, and optimize data pipelines.
• Conducts work sessions with users and project team members to document requirements, develop use cases, and/or technology solutions.
• Assists Business analysts from project teams to ensure reporting and data requirements are gathered and delivered within project timelines working with Data Management and ODSI.
• Participates in release activities and application development implementation activities.
• Develops and coordinates other special projects and performs other duties as assigned.
• Train other business analysts on using SQL to perform analysis.

• Ability to use SQL queries to join and pull data from various databases.
• Ability to write SQL scripts to transform, filter, sort, and group data according to business needs.
• Ability to analyze complex data sets by joining information from multiple tables to identify data anomalies
• Ability to read Stored Procedures, Unix Scripts and SQL queries to troubleshoot data anomalies in an ETL pipeline.
• Ability to write SQL queries systematically scan datasets for deviations from the established normal behavior.
• Ability to Verify data quality using SQL to ensure the accuracy and reliability of analysis and reports.
• Ability to Create source to target mapping documents for ETL pipelines.
• Knowledge of Business Analysis key concepts, elicitation and collaboration, strategy analysis, solution evaluation, competencies, and techniques.
• Knowledge of Software Development Life Cycle (SDLC) and high-level system design methodologies and techniques (entity/relationship models, data/process flow diagrams); object-oriented programming and programming client/server applications.
• Ability to research, understand, and summarize key and abstract ideas and when applicable, suggest recommendations from those findings.
• Strong analytical and critical thinking skills.
• Ability to identify and mitigate key issues affecting the progress of an organization and present solutions.
• Working knowledge of productivity software including Microsoft Office Suite to include MS Word, Excel, PowerPoint, MS Project, SharePoint, Visio and/or SQL.
• Demonstrates excellent organization skills, e.g., defines and organizes tasks, responsibilities, and priorities.
• Ability to develop documentation that maps and illustrates processes and develop framework for process improvement.
• Demonstrated experience in expressing technical and business concepts and conclusions orally and in writing.
• Ability to lead others.
• Skilled in problem root cause analysis and negotiating problem resolution.

• Scrum Master or Scrum Product Owner certification is a plus but not required.

• CBAP or similar Business Analyst certification is a plus but not required.
• ETL and Data Analytics Certifications

• Graduation from an accredited College or University
• Degree in computer science, computer information systems, management information systems, or a related field, preferred.
• Work experience may be substituted for education on a year-for-year basis.
• At least three (3) years’ full-time experience in data analysis, data integration, and ETL processes.
• Business Analysis experience is preferred
• DFPS program 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.