Job/Position DescriptionThe position performs moderate complex functions involving data analysis, data quality, data research, and data reconciliation. Work entails querying and compiling data, developing technical solutions such as creating databases, developing software applications using computer languages, as well as other data maintenance related functions such as performing data quality metrics. The position prepares financial and technical reports; identifies data trends, inconsistencies, anomalies and redundancies; and establishes data quality metrics and measures.Essential Job FunctionsEssential Job Functions:Performs data integrity functions in CAPPS Fin, subsystems and applications involving the maintenance of data fields within the chart of accounts, establishing/updating data fields in CAPPS Fin in preparation for the new fiscal year, performing combo edit rule maintenance to establish correct combinations of data fields, performing system tree maintenance to establish and maintain correct data hierarchy within CAPPS Fin and other subsystems and applications, and maintain electronic data interface (EDI) layout to ensure compliance with PeopleSoft and IRS regarding data formatting (15%)Writes, extracts, queries and compiles data in the completion of audit requests, open records requests and ad hoc data requests involving writing and generating reports; extracting, querying, and compiling data; reconciling data, and researching deltas (15%)Prepares comprehensive financial and technical reports such as the Monthly Financial Report (MFR), Legislative Annual Report (LAR), base reconciliation, Annual Financial Report (AFR), Schedule of Expenditures of Federal Awards (SEFA) and 1099 reporting by extracting, querying and compiling data out of CAPPS HR, CAPPS Financials, and databases for data presentation and interpretation in identifying data trends, inconsistencies, anomalies, redundancies, and for making recommendations to make data revisions to present a more accurate picture of the data and aid in management decision-making (15%)Establishes data quality metrics, measures against results, recommends and implements improvements to data quality associated with processes such as determining and calculating the correct method of finance, forecasting and reallocating expenditures and in the process, performs related data quality assurance (15%)Writes scripts and develops code to compile and present statistics requiring various views or models using computer programming languages such as SQL and Visual Basic (10%)Establish and maintain standard work procedures governing data usage, house and display data such as developing databases, developing moderately complex queries, creating spreadsheets, and designing SharePoint sites and develops, documents and implements related data standards (10%)Performs data analysis using statistical tools such as SAS and TOAD and applying industry standard methods and techniques (10%)Maintains data quality and assurance and consults with other departments (internal and external) to determine data needs; performs other duties as assigned (10%)Attends work regularly in accordance with agency leave policy. Registrations, Licensure Requirements or CertificationsN/AKnowledge Skills AbilitiesKnowledge of data analysis and statistical data modeling and security protocols for data access, data handling, and protecting and distributing confidential data.Knowledge of budget and general ledger financial reporting preferred. Kno https://jobshrportal.hhsc.state.tx.us/ENG/CareerPortal/job_profile.cfm?szOrderID=614522 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.