Data Analyst IV

Data Analyst IV Date:Aug 13, 2025 Location:AUSTIN, TX 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:Data Analyst IV Job Title:Data Analyst IV Agency:Dept of Family & Protectve Svc Department:COA Contract Oversight & Spt Posting Number:8121 Closing Date:08/27/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: 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: MOS Codes:31D, 35L, 35M, 68X, 73A, 311A, 351L, 351M, HM, IS, NC, 183X, 230X, 683X, 783X, IV, MST, INV, ISS OAP12, 0149, 5821, 5822, 5832, 1N0X1, 4C0X1, 4E0X1, 14NX, 42SX, 43HX, 71SX, 0868, 66C, 47L, 66R 67D, L24A, 001387 Brief Job Description: The Data Analyst IV position performs moderately complex (journey-level) data analysis and data research work. Work involves conducting detailed analysis of and extensive research on data, providing results, and monitoring and implementing data quality. The Data Analyst IV analyzes and synthesizes complex contracting data and performs reporting from multiple systems by using business intelligence software. Data is used to analyze and trend areas of improvement, construct data-based decisions and agency support, and enhance controls to mitigate contract risk to further promote contract management integrity and accountability. This position will develop and enhance reporting methodologies to assess agency contract and monitoring processes and recommend improvements to policies and procedures to increase efficiency during implementation of a new contract and grants management system. The position assists with managing, maintaining, enhancing, and training on contract data systems and processes. Works under general supervision, with moderate latitude for the use of initiative and independent judgment. This position will also be responsible for providing guidance to other data analysts Essential Job Functions: Analyzes data using standard statistical tools, methods, and techniques and interprets results to identify significant differences in data. Creates, analyzes, and evaluates information and translates it into easily understandable and concise documents and presentations for diverse levels of agency staff. Creates databases to organize and quickly retrieve data/ad hoc reports. Consults with internal and external customers to identify user needs. Interacts routinely with stakeholders. Develops and maintains relationships in a manner that is customer service oriented, supportive and solution oriented, responsive, thorough and timely to meet organizational needs. Identifies and leads improvements to systems through workgroups and projects to include providing consultative services and technical assistance in the planning, implementation, and management of contracting initiatives. Collects, queries, analyzes, and prepares data requests using various (CAPPS Fin., SCOR, IMPACT, Salesforce) data systems and tools (Webi, SQL, Tableau and Databricks) for contract related reporting and financial expenditures. Provides accurate and timely reports to ensure compliance with Legislative Budget Board (LBB) reporting, Vendor Performance Tracking System (VPTS) reporting, and expenditure-based reporting. Creates complex data queries using multiple data sources. Identifies and interprets data patterns and trends and assesses data quality. Develops statistics and trend analysis and summary reports to inform the agency of contracting efficiencies, risk, and opportunities for improvement for data integrity, data-based decisions and improvements of contract management activities. Cleans and prunes data to discard irrelevant information. Ensures data integrity by identifying data gaps, errors, anomalies, inconsistencies, and redundancies in the content, structure, and relationships within data; cleans and prepares data, as necessary. Prepares concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions. Produces and maintains data visualization reports in an easy to understand format that supports decision making, identifies opportunities for efficiencies, risk management, and continuous opportunities for systematic improvements. Works with contract data to provide accurate and timely reports to ensure compliance with agency, State and Federal reporting requirements. Creates strong data visualizations using Tableau or other data visualization tools. Assists in defining, developing, and implementing data standards. Participates in the development of agency contract policy to ensure the proper application of agency data standards are supported through policy language and references. Assists in developing data quality measures, analyzing data quality results, and implementing necessary changes to ensure data quality improvement. Performs quality assurance reviews of contract reporting activities through analyzing data for integrity to assess compliance, identify best practices, increase accountability, and recommend improvements to contract policies, procedures, and tools. Implements databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality. Leads the development of tools and activities to ensure contract accountability and agency compliance with policies and procedures; the collection, recording, and analysis of contract data from diverse sources; and makes recommendations for continuous quality improvements to support contracting areas. Knowledge and understanding of relational database design and data systems architecture. Assists with managing, maintaining, enhancing, and training on contract data systems and processes. May establish and maintain standard work procedures governing the appropriate use of data. May participate in development of user manual(s) or job aids. Participates in the development of agency contract policy; developing and revising guidance, procedures, and tools for contract personnel to ensure the appropriate use of data. Performs related work as assigned. Performs other duties as assigned to maintain and support Contract Oversight and Support operations. Knowledge, Skills and Abilities: • Knowledge of data models, database design development, data mining, and segmentation techniques. • Knowledge of Master Data Management concepts and principles. • Knowledge of information security requirements. • Knowledge of risk assessment theories, techniques, and methodologies. • Knowledge and understanding of relational database design and data systems architecture. • Knowledge of procurement and contract management principles and procedures. • Skill in analyzing problems and devising effective solutions. • Skill in creating and delivering effective training presentations to individual, small group, and large group settings. • Skill in managing multiple, sometimes conflicting priorities, without jeopardizing deadlines or system milestones. • Skill in establishing and maintaining effective working relationships. • Ability to compile, review, and analyze data; to prepare reports; to maintain accuracy and attention to detail; and to communicate effectively. • Ability to create strong data visualizations using Tableau or other data visualization tools • Ability to create complex data queries using multiple data sources • Ability to read and write SQL queries • Ability to create databases to organize and quickly retrieve data/ad hoc reports. • Ability to adapt to change and maintain flexibility. • Ability to use CAPPS Financials, SCOR and Salesforce applications. • Ability to create, analyze, and evaluate information and translate it into easily understandable and concise documents and presentations for diverse levels of agency staff. • Ability to represent the agency at conferences, meetings, and forums. • Ability to understand and implement risk management and quality assurance processes. • Ability to communicate effectively with all levels of staff, executive management, and stakeholders both orally and in writing with tact and diplomacy. • Ability to use the Microsdows Suite of products including Microsoft Word, Microsoft Excel, and Microsoft Outlook, and other business intelligence software. • Must have an aptitude for details. Registrations, Licensure Requirements or Certifications: Registration or Licensure Requirements: Certified Texas Contract Manager (CTCM) and Certified Texas Contract Developer (CTCD) preferred. CTCM is required within 18 months of start date. CTCD is required within 24 months of start date. Initial Screening Criteria: 5 years of experience in data analysis, research, compilation, and/or reporting work. Graduation from an accredited four-year college or university with major coursework in data science, business analytics, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field is generally preferred. Experience and education may be substituted for one another. Certified Texas Contract Manager (CTCM) and Certified Texas Contract Developer (CTCD) preferred. Additional Information: This position is eligible for a hybrid telework schedule based on agency policy and supervisor approval. Office location may vary based on location of successful candidate. 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 [email protected] 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. Nearest Major Market:Austin