Job/Position Description This position performs moderately complex human resources (HR) data analysis and report research work. Work involves conducting detailed analysis of and extensive research on data providing results and monitoring and implementing data quality. Develops and runs recurring and ad hoc reports to provide data extracted from PeopleSoft/Oracle relational database to management and program staff. Utilizes Structured Query Language (SQL) and Structured Query Reporter (SQR) to create reports from relational databases. Prepares reports, studies, and performs specialized research initiatives. Designs and utilizes program coding with Windows and Visual Basic for Applications (VBA) scripts. Designs reports to extract and analyze data in support of a wide variety of workforce initiatives and projects. Serves as a subject matter expert on HR data and reporting functions for project groups on the development, modification, and upgrades to the Centralized Accounting and Payroll/Personnel System (CAPPS) Human Capital Management (HCM). Develops and maintains functional and technical specifications via the preparation of detailed flowcharts, tables, reports and other materials for coding, testing and documenting automated systems. Works under general supervision with moderate latitude for the use of initiative and independent judgment. This position is eligible to work in a hybrid environment with work occurring both remote and on-site in Austin. Essential Job Functions Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned. Compiles and queries data to create, maintain and modify Access, Oracle and other relational databases for extracting and tracking data and conducting analyses. Develops and processes recurring and ad hoc reports to provide data extracted from PeopleSoft/Oracle relational database to management and program staff. Develops reports using Structured Query Language (SQL) and Structured Query Reporter (SQR) to efficiently extract data. Develops SQR programs for custom reports, validates and conducts analysis to ensure data meets the customer's reporting needs. Designs automated reports and ensures they are run in accordance with established schedules. (30%) Designs and utilizes program coding with Windows and Visual Basic for Applications (VBA) scripts to achieve desired reporting results. Prepares organized and appropriately formatted presentations, reports, data summaries and analyses for distribution. Assists in developing data quality measures, analyzing data quality results, an implementing necessary changes to ensure data quality improvement (30%) Serves as a subject matter expert for HR data and policies for HR reporting functions, data analysis, and on project groups for development, modification, and upgrades to the CAPPS HCM. Assists in identifying new developments and improvements in CAPPS HCM that support, maintain or increase data integrity and security. Tests the implementation of new system functions and database and program upgrades to assess effectiveness and identify issues. Assists in identifying systems issues related to data capture and processing, and identifies data gaps, errors, anomalies and inconsistencies by analyzing content, structure and relationships within the data. (20%) Develops project documentation including system and user acceptance testing plans, test scripts, use cases and data exchange documentation that documents the current and future stat https://jobshrportal.hhsc.state.tx.us/ENG/CareerPortal/job_profile.cfm?szOrderID=600048 Copy the URL in the preceding sentence to an Internet Explorer browser to apply to the job directly through the Texas Health and Human Services Career Portal.