Data Analyst V

The Texas Department of Family and Protective Services (DFPS) works to build on strengths of families and communities to keep children and vulnerable adults safe, so they thrive. We do this through investigations, services, and referrals.

What You Get Beyond Your Paycheck

When you join the State of Texas, your monthly paycheck is just one part of your real income. Our benefits provide extra value that many private employers simply don’t match - often adding hundreds of dollars each month to what you take home or save.

Here’s what you get as a full-time employee:

• 100% paid health insurance for you, and 50% paid for eligible family members - saving you hundreds every month in out-of-pocket medical costs
• Retirement plans with lifetime monthly payments after five years of state service, plus options to save even more with 401(k) and 457 plans
• Paid vacation, holidays, and sick leave so you can recharge and take care of life outside work (that’s time off you’re actually paid for)
• Optional dental, vision, and life insurance - at rates much lower than most private plans
• Flexible spending accounts for added tax savings on health and dependent care
• Employee discounts on things like gym memberships, electronics, and entertainment

You also might qualify for Public Service Loan Forgiveness, which could help you pay off federal student loans faster.

You can see all the details here: ERS recruitment brochure

Functional Title: Data Analyst V Job Title: Data Analyst V Agency: Dept of Family & Protectve Svc Department: Deputy CFO Posting Number: 22914 Closing Date: 11/13/2026 Posting Audience: Internal and External Occupational Category: Business and Financial Operations Salary Range: $6,377.50 - $10,785.83 Pay Frequency: Monthly Salary Group: TEXAS-B-26 Shift: Day

Additional Shift:

Telework: Eligible for Telework Travel: Up to 10% Regular/Temporary: Regular Full Time/Part Time: Full time FLSA Exempt/Non-Exempt: Exempt

Facility Location:

Job Location City: AUSTIN Job Location Address: 4900 N LAMAR BLVD

Other Locations:

MOS Codes: No military equivalent

Brief Job Description

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 activities. This position performs highly advanced (senior-level) analytical work and provides strategic leadership in the development, implementation, and oversight of enterprise financial reporting, data quality initiatives, and business intelligence solutions supporting DFPS financial and operational objectives.

The position is responsible for leading agency-wide efforts to improve data integrity, reporting consistency, system interoperability, and decision-support capabilities. Provides expert consultation to executive leadership, program areas, Information Technology, and external stakeholders regarding financial data, reporting methodologies, system requirements, and emerging analytical practices.

Oversees the development of complex data solutions, establishes data governance standards, and directs initiatives involving financial, operational, and regulatory reporting. Translates complex business and technical requirements into sustainable analytical solutions and actionable recommendations that support executive decision-making.

Leads and mentors analysts, promotes best practices for data management and reporting, and serves as the Office of Finance representative on complex enterprise projects involving financial systems, data integration, and reporting modernization efforts.

This position is eligible for remote work in accordance with agency policy and business needs. Remote work arrangements are subject to management approval and may be modified based on operational requirements.

Essential Job Functions (EJFs)

Enterprise Data Strategy and Analytics Leadership

Provides strategic leadership for enterprise financial data management, reporting, and analytics initiatives. Develops and implements analytical frameworks, reporting standards, and data governance practices that support agency-wide financial accountability, transparency, and decision-making.

Serves as the principal advisor to Office of Finance leadership regarding data strategy, reporting modernization, business intelligence capabilities, and emerging analytical technologies. Conducts highly complex analyses and presents recommendations that influence agency policy, operational processes, financial reporting, and resource allocation decisions.

Leads large-scale analytical projects involving multiple divisions, agencies, and stakeholders. Coordinates project activities, establishes priorities, manages competing business requirements, and ensures successful delivery of high-impact reporting and data solutions.

Advanced Reporting and Financial Analysis

Directs the design, development, and maintenance of enterprise reporting solutions utilizing SQL, Visual Basic, TOAD, Power BI, and other analytical tools. Oversees the preparation and validation of complex financial reports, including the Monthly Financial Report (MFR), Legislative Appropriations Request (LAR), Annual Financial Report (AFR), Schedule of Expenditures of Federal Awards (SEFA), 1099 reporting, base reconciliations, audit support, and executive-level reporting.

Develops advanced reporting methodologies and performance measures that improve organizational insight and support strategic planning efforts. Provides expert consultation regarding reporting requirements, data interpretation, and analytical approaches.

Responds to complex open records requests, external audits, federal reviews, legislative inquiries, and executive information requests requiring independent judgment and extensive knowledge of agency financial data.

Data Governance and Quality Management

Leads agency-wide data governance, data quality, and data stewardship initiatives affecting financial and operational reporting systems. Establishes standards, policies, procedures, business rules, and controls to ensure data integrity, reliability, and consistency across multiple platforms and reporting environments.

Develops and oversees data quality monitoring programs, validation processes, reconciliation activities, and performance metrics. Identifies systemic data issues, conducts root cause analysis, and develops long-term corrective actions that improve data quality and business processes.

Establishes and maintains documentation, data dictionaries, reporting standards, metadata, and governance artifacts supporting compliance, continuity, and organizational knowledge management.

Systems Integration and Technical Leadership

Provides leadership and technical oversight for data integration efforts involving CAPPS Financials, reporting databases, financial interfaces, enterprise applications, and external reporting systems.

Evaluates the impact of major system implementations, upgrades, and enhancements on financial data structures, reporting frameworks, business processes, and downstream dependencies. Recommends strategic improvements to system architecture, data flows, and reporting environments.

Maintains oversight of Electronic Data Interchange (EDI) layouts and related technical specifications to ensure compliance with PeopleSoft, IRS, state, and federal reporting requirements.

Collaborates with agency technology staff, vendors, and business stakeholders to design and implement enterprise reporting and analytics solutions.

Consultation, Training, and Mentorship

Serves as the recognized agency expert for financial data management and advanced analytics. Provides consultation to executive leadership, management, program staff, and technical teams regarding complex reporting and data-related issues.

Provides leadership, mentoring, and technical guidance to analysts and other staff. Establishes best practices, analytical methodologies, documentation standards, and reporting procedures to improve organizational capabilities and consistency.

Develops and delivers presentations, briefings, training materials, and executive summaries for leadership, oversight entities, auditors, and external stakeholders.

Performs other duties as assigned.

Knowledge, Skills, and Abilities (KSAs)

Knowledge of:

• Enterprise data governance frameworks, data stewardship principles, and data quality management methodologies.
• Advanced statistical analysis, data mining, predictive analytics, and business intelligence concepts.
• Financial management, governmental accounting principles, and state and federal financial reporting requirements.
• Relational database design, data architecture, systems integration, and enterprise reporting environments.
• CAPPS Financials, PeopleSoft applications, and financial reporting systems.
• Project management principles, organizational change management, and strategic planning methodologies.
• Business process improvement and performance measurement techniques.

Skill in:

• Advanced SQL development, data extraction, data modeling, and data querying.
• Leading complex analytical and reporting initiatives.
• Designing enterprise reporting and business intelligence solutions.
• Data quality management, reconciliation, validation, and root cause analysis.
• Strategic problem solving and process improvement.
• Developing technical documentation, standards, policies, and procedures.
• Presenting complex technical and financial information to executive and non-technical audiences.
• Advanced Microsoft Excel, Power BI, Tableau, and related analytical technologies.

Ability to:

• Lead enterprise-wide data and analytics initiatives with significant organizational impact.
• Serve as the principal subject matter expert for financial data management and reporting.
• Translate business objectives into strategic data and reporting solutions.
• Analyze highly complex data from multiple sources and develop actionable recommendations.
• Evaluate long-term operational, financial, and technical impacts of proposed changes.
• Influence decision-making across organizational boundaries.
• Manage multiple high-priority projects and competing deadlines.
• Communicate effectively with executives, business stakeholders, auditors, technical staff, and external partners.
• Exercise extensive independent judgment and initiative in resolving complex analytical and operational issues.

Registrations, Licensure Requirements or Certifications: N/A

Initial Screening Criteria

• 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.
• Current or prior CAPPS experience preferred.

Graduation from an accredited four-year 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 be substituted for one another on a year-for-year basis.

Review our Tips for Success when applying for jobs at DFPS, DSHS and HHSC.

Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to those listed in this posting. All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information please see the Texas State Auditor’s Job Descriptions, Military Crosswalk and Military Crosswalk Guide at Texas State Auditor's Office - Job Descriptions. You may also contact the DFPS Military Liaison at dfpsmilvets@dfps.texas.gov with additional questions.

Applicants selected for hire must pass a background check and if applicable a driver’s record check.

State of Texas employees are required to maintain the security and integrity of critical infrastructure as defined in Section 117.001(2), State of Texas Business and Commerce Code. Applicants selected for hire comply with this code by completing related training and abiding by agency cybersecurity and communications system usage policies.

As a state agency, DFPS is required by Texas Administrative Code (TAC 206 and 213) to ensure all Electronic Information Resources (EIR) follow accessibility standards. The staff must be familiar with the WCAG 2.1 AA and Section 508 to create accessible content including but not limited to; Microsoft Office documents, Adobe PDFs, webpages, software, training guides, video, and audio files.

DFPS uses E-Verify. You must bring your I-9 documentation with you on your first day of work. Employees must provide documentation to DFPS to show their identity and authorization to work in the US. Please review the following link for authorized documents: https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents .

In compliance with the Americans with Disabilities Act (ADA), HHS/DFPS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS/DFPS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.