Data Analyst III (Office of Finance)

Texas Health & Human Services Commission • Austin, TX

5d • $4,801 - $7,762 • Remote

About The Position

The Data Analyst III reports to the Financial Data Team Manager within the Office of Finance. The position performs moderate complex functions involving analysis, quality, research, and reconciliation. Work entails querying and compiling data, developing technical solutions such as creating databases, developing software applications using computer languages, as well as other maintenance related functions such as performing data quality metrics. The position prepares financial reports, identifies data trends, and establishes data quality metrics and measures to support organizational improvements. Full time remote worker.

Requirements

• Experience writing scripts or code to extract, compile and present data or models using computer programming languages such as SQL is required.
• Experience in data analysis, research, and compilation is required.
• Knowledge of data analysis and statistical data modeling and security protocols for data access, data handling, and protecting and distributing confidential data.
• Advanced Microsoft Office (Excel, Word, PowerPoint), business objects, financials software/applications, claims processing engines, SQL, R, SAS, Python.
• Knowledge of data quality and integrity processes and techniques for process improvement.
• Skill in managing multiple and competing priorities and identifying problems, evaluating alternatives, and implementing solutions.
• Skill in various programming languages and usage of computer and system tools and applications.
• Skill in how to explain, advocate, express facts and ideas, and negotiate with individuals and groups, internally and externally.
• Ability to perform data analysis, statistics, data visualization, methods of funding, program rules.
• Ability to recommend, design, develop, and implement new technology/ work processes that benefit the organization.
• Ability to produce results through planning, development and implementation automated solutions and business processes.
• Ability to build, establish, and maintain effective working relationships with diverse groups.
• Ability to work effectively in a team environment.
• Must pass a background check and if applicable a driver’s record check.
• Must maintain the security and integrity of critical infrastructure.
• Must be familiar with WCAG 2.1 AA and Section 508 to create accessible content.
• Must provide documentation to show identity and authorization to work in the US.

Nice To Haves

• Knowledge of budget and general ledger financial reporting preferred.
• Graduation from an accredited four-year college or university with major coursework in data science, business, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field is generally preferred.

Responsibilities

• Performs data integrity functions in CAPPS Fin, subsystems, and applications involving the maintenance of financial data fields within the chart of accounts, establishing/updating data fields, 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.
• Maintains electronic data interface (EDI) layout to ensure compliance with PeopleSoft and IRS regarding data formatting.
• Serves as the security coordinator for the internal and external financial systems. Reviews, analysis, and determines the appropriateness of the roles, identifies conflicts, and recommends changes. Performs user access audits and certifications. Recommends changes and improvements to ensure compliance with Comptroller policies and best practices.
• Writes, extracts, queries, and compiles data for the completion of audit requests, open records requests, and ad hoc requests requiring use of computer programming languages such as SQL and Visual Basic. Performs data analysis using statistical tools such as SAS and TOAD and applying industry standard methods and techniques.
• Prepares data sets, financial and technical reports to be used for agency’s major 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 other databases for presentation, identifying trends, inconsistencies, anomalies, redundancies, and for making decisions and recommendations to make data revisions to present a more accurate picture of the data and aid in management decision-making.
• Attends work regularly in accordance with agency leave policy.

Benefits

• 100% paid health insurance for you, and 50% paid for eligible family members
• Retirement plans with lifetime monthly payments after five years of state service
• Options to save even more with 401(k) and 457 plans
• Paid vacation, holidays, and sick leave
• Optional dental, vision, and life insurance
• Flexible spending accounts for added tax savings on health and dependent care
• Employee discounts on things like gym memberships, electronics, and entertainment
• Public Service Loan Forgiveness

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level