Data Analyst V

Texas Health & Human Services Commission • Austin, TX

6d • $6,378 - $10,786 • Hybrid

About The Position

The Data Analyst V reports to the Financial Data Team Manager within the Office of Finance and serves as the lead subject matter expert for financial data management, analytics, reporting, and data governance. This senior-level position provides strategic leadership for enterprise financial reporting, data quality initiatives, and business intelligence solutions that support DFPS financial and operational objectives. It leads agency-wide efforts to improve data integrity, reporting consistency, system interoperability, and decision-support capabilities, and advises executive leadership, program areas, Information Technology, and external stakeholders on financial data, reporting methodologies, system requirements, and analytical practices.

The position oversees complex data solutions, establishes data governance standards, and directs initiatives involving financial, operational, and regulatory reporting. It translates business and technical requirements into sustainable analytical solutions and actionable recommendations, leads and mentors analysts, and represents the Office of Finance on enterprise projects involving financial systems, data integration, and reporting modernization. Remote work may be available in accordance with agency policy and business needs, subject to management approval and operational requirements.

Requirements

• Experience developing, maintaining, and optimizing complex SQL scripts and database solutions.
• Experience designing and implementing reporting, dashboard, and business intelligence solutions using Power BI, Tableau, or similar technologies.
• Experience leading enterprise data governance, data quality, or large-scale reporting initiatives.
• Experience analyzing and reporting financial data in a governmental, accounting, auditing, or regulatory environment.
• Experience serving as a lead analyst, project lead, technical lead, or subject matter expert.
• Knowledge of enterprise data governance frameworks, data stewardship, and data quality management methodologies.
• Knowledge of advanced statistical analysis, data mining, predictive analytics, and business intelligence concepts.
• Knowledge of financial management, governmental accounting, and state and federal financial reporting requirements.
• Knowledge of relational database design, data architecture, systems integration, and enterprise reporting environments.
• Knowledge of CAPPS Financials, PeopleSoft applications, and financial reporting systems.
• Knowledge of project management, organizational change management, strategic planning, business process improvement, and performance measurement.
• Skill in advanced SQL development, data extraction, data modeling, and data querying.
• Skill in leading complex analytical and reporting initiatives and designing enterprise reporting and business intelligence solutions.
• Skill in data quality management, reconciliation, validation, root cause analysis, strategic problem solving, and process improvement.
• Skill in developing technical documentation, standards, policies, and procedures.
• Skill in presenting complex technical and financial information to executive and non-technical audiences.
• Skill in advanced Microsoft Excel, Power BI, Tableau, and related analytical technologies.
• Ability to lead enterprise-wide data and analytics initiatives and serve as the principal subject matter expert for financial data management and reporting.
• Ability to translate business objectives into strategic data and reporting solutions and develop actionable recommendations from complex, multi-source data.
• Ability to evaluate long-term operational, financial, and technical impacts; influence decisions across organizational boundaries; and manage multiple high-priority projects and deadlines.
• Ability to communicate effectively with executives, business stakeholders, auditors, technical staff, and external partners.
• Ability to exercise extensive independent judgment and initiative in resolving complex analytical and operational issues.
• A four-year degree from an accredited 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; experience and education may substitute for one another year for year.
• Selected applicants must pass a background check and, if applicable, a driver’s record check.
• Staff must be familiar with WCAG 2.1 AA and Section 508 accessibility standards for electronic information resources.
• Employees must provide documentation of identity and authorization to work in the United States.

Nice To Haves

• Current or prior CAPPS experience is preferred.
• A four-year degree from an accredited college or university in a related field is generally preferred.

Responsibilities

• Provide strategic leadership for enterprise financial data management, reporting, analytics, analytical frameworks, reporting standards, and data governance practices.
• Advise Office of Finance leadership on data strategy, reporting modernization, business intelligence capabilities, and emerging analytical technologies.
• Conduct complex analyses and present recommendations affecting agency policy, operations, financial reporting, and resource allocation.
• Lead large-scale analytical projects involving multiple divisions, agencies, and stakeholders; coordinate activities, set priorities, manage competing requirements, and deliver reporting and data solutions.
• Direct the design, development, and maintenance of enterprise reporting solutions using SQL, Visual Basic, TOAD, Power BI, and other analytical tools.
• Oversee preparation and validation of complex financial reports, including MFR, LAR, AFR, SEFA, 1099 reporting, base reconciliations, audit support, and executive reporting.
• Develop reporting methodologies and performance measures, and consult on reporting requirements, data interpretation, and analytical approaches.
• Respond to complex open records requests, external audits, federal reviews, legislative inquiries, and executive information requests.
• Lead agency-wide data governance, data quality, and data stewardship initiatives; establish standards, policies, procedures, business rules, and controls.
• Develop and oversee data quality monitoring, validation, reconciliation, and performance measurement; identify systemic issues, analyze root causes, and implement corrective actions.
• Maintain documentation, data dictionaries, reporting standards, metadata, and governance artifacts.
• Lead and provide technical oversight for data integration involving CAPPS Financials, reporting databases, financial interfaces, enterprise applications, and external reporting systems.
• Evaluate the effects of system implementations, upgrades, and enhancements on financial data, reporting, business processes, and downstream dependencies; recommend improvements to architecture, data flows, and reporting environments.
• Oversee EDI layouts and technical specifications for compliance with PeopleSoft, IRS, state, and federal reporting requirements.
• Collaborate with agency technology staff, vendors, and business stakeholders to design and implement enterprise reporting and analytics solutions.
• Provide consultation, leadership, mentoring, and technical guidance to analysts and other staff; establish analytical and documentation best practices.
• Develop and deliver presentations, briefings, training materials, and executive summaries for leadership, oversight entities, auditors, and external stakeholders.
• Perform other duties as assigned.

Benefits

• 100% paid health insurance for the employee and 50% paid for eligible family members.
• Retirement plans with lifetime monthly payments after five years of state service, plus 401(k) and 457 savings plans.
• Paid vacation, holidays, and sick leave.
• Optional dental, vision, and life insurance at rates described as lower than most private plans.
• Flexible spending accounts for health and dependent care.
• Employee discounts, including gym memberships, electronics, and entertainment.
• Potential eligibility for Public Service Loan Forgiveness.

What This Job Offers

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