Job/Position DescriptionThe position performs complex functions involving data analysis, data quality, data research, report development and data reconciliation. Work entails querying and compiling data, developing technical solutions such as creating databases, Microsoft Power APP applications, identify data gaps, errors, anomalies, inconsistencies, 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 FunctionsCollects, queries, and analyzes data using standard statistical tools, applications, methods, and techniques.and#149;Performs data analysis using statistical tools such as Statistical Analysis System (SAS) and TOAD and applying industry standard methods and techniques. and#149;Ensures data is correct by running queries, pulling ad hoc data, writes reports, and presents findings.and#149;Ensures system combination are correct and maintains data fields within the chart of accounts, establishes/updates data fields in CAPPS Financials. and#149;Reviews and approves security request for CAPPS Financials, USAS, TOSS and related systems.and#149;Build SQL scripts to add, delete and update data on system databases.and#149;Writes, extracts, queries, and compiles data in the completion of audit requests, open records requests.and#149;Creates and maintains Microsoft Power APP applications.Interprets data analysis results to identify significant differences and trends in data to inform decisions.and#149;Reviews data accuracy and interprets and identifies data trends, inconsistencies, anomalies, and redundancies.and#149;Establishes data quality metrics, measures against results, and recommends improvements to data quality.Consults with internal and external customers to identify data analytics needs.and#149;Maintains electronic data interface (EDI) layout to ensure compliance with PeopleSoft and IRS regarding data formatting.and#149;Meets with project teams, auditors, and vendors.and#149;Responds orally and written communication regarding current reporting process.and#149;Reviews the financial data team mailbox and responds in an accurate and timely manner to any reporting or system related questions.and#149;Meets with managers and staff to collect and gather new data requirements.and#149;Writes scope documents and gathers project and report requirements. Cleans and prunes data to discard irrelevant information.and#149;Reviews the recommendations and completes the data clean up as necessary and ensures files are not too large or corrupt. and#149;Completes daily report refresh and publishes them to SharePoint for financial analyst to utilize.and#149;Reviews data for accuracy and inconsistenciesand#149;Reviews CAPPS Financials system codes tables and look up tables to ensure lookup data is up to date.Participates in developing methods for mitigating data issues and deploying those methods to correct issues.and#149;Verifies data accuracy on reports created by Finance Data team.and#149;Develops and deploys methods and solutions to correct data inaccuracies in the reports.and#149;Develops and implements methods and solutions to prevent data issues in the future. and#149;Reviews and maintains database macros and formulas and ensures the accuracy. Prepares concise, comprehensive technical reports to present and make and justify recommendations on data revisions.and#149;Gathers data to prepares comprehensive financial and https://jobshrportal.hhsc.state.tx.us/ENG/CareerPortal/job_profile.cfm?szOrderID=615418 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.