Apply on Employer Site

Texas Department of Family and Protective Services · 22 hours ago

Data Analyst IV

Austin, TX

Full-time

Hybrid

Senior Level

$5,425.33/mo - $8,886.16/mo

5+ years exp

The Texas Department of Family and Protective Services (DFPS) is responsible for protecting vulnerable populations in Texas. The Data Analyst IV position involves conducting complex data analysis and research, providing reporting and monitoring data quality to enhance contract management integrity and accountability.

Individual & Family Services

Responsibilities

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

Qualification

Data analysisSQLTableauData visualizationData quality managementMaster Data ManagementContract managementTraining presentationsProblem solvingEffective communicationRelationship buildingAttention to detail

Required

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

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 Microsoft Suite of products including Microsoft Word, Microsoft Excel, and Microsoft Outlook, and other business intelligence software

Must have an aptitude for details