Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Tailor your resume to this Data Analyst IV role.
Rezi rewrites your resume against Texas Health & Human Services Commission's job description. Free.
Tailor your resume to this Data Analyst IV role.
Rezi rewrites your resume against Texas Health & Human Services Commission's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Data Analyst IV posting at Texas Health & Human Services Commission — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Data Analyst IV posting at Texas Health & Human Services Commission — free, in seconds.
About the Role
The Data Analyst IV reports to the Financial Data Team Manager within the Office of Finance. This position performs complex data analysis, reporting, and data management activities to support DFPS financial and operational objectives. It provides technical expertise in analyzing, interpreting, validating, and presenting complex data from multiple systems and sources. The role develops data-driven solutions, identifies trends and anomalies, improves data quality, and translates complex information into actionable insights for divisional staff. The position also serves as an analytical resource, providing guidance on data practices, reporting methodologies, system requirements, and process improvements. It works collaboratively with Office of Finance staff to ensure data accuracy, reliability, accessibility, and alignment with agency requirements. This role prepares reports, dashboards, presentations, and other materials to support data-based decisions.
Responsibilities
- Performs data analysis using statistical tools such as SQL, Visual Basic, and TOAD and applying industry standard methods and techniques.
- Writes, extracts, queries, and compiles data to prepare financial 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.
- Provides other routine, ad hoc, and customized reports based on divisional needs.
- Responds to open records requests and audit inquiries.
- Takes ownership for improving data quality by establishing standards, business rules, and quality controls.
- Leads data quality activities by evaluating completeness, accuracy, consistency, and reliability across multiple systems.
- Develops and implements data validation and reconciliation processes that support root cause analysis and corrective actions.
- Establishes and maintains quality metrics, measures against results, and recommends necessary improvements to data quality.
- Supports data integration and interoperability between financial, operational, and reporting systems.
- Evaluates the impact of CAPPS Financials system changes on data structures, reporting, interfaces, and downstream processes.
- Maintains electronic data interface (EDI) layout to ensure compliance with PeopleSoft and IRS regarding data formatting.
- Ensures data in reporting databases and CAPPS Financials is updated appropriately and timely.
- Meets with staff to identify data analytics needs, responds in an accurate and timely manner to reporting or system-related questions, and recommends visualization best practices.
Requirements
- Experience writing and maintaining SQL scripts required.
- Experience analyzing financial data.
- Current or prior DFPS experience preferred.
- 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.
- Staff must be familiar with WCAG 2.1 AA and Section 508 to create accessible content.
- Employees must provide documentation to DFPS to show their identity and authorization to work in the US.
Skills
- SQL
- Data querying
- Data analysis and interpretation
- Data reconciliation
- Data validation
- Creating and maintaining technical documentation
- Presenting complex information to non-technical audiences
- Advanced skills in Microsoft Excel
- Advanced skills in other analytical/reporting tools
- Working with multiple data sources
- Working with enterprise systems
- Analyzing large, complex, and disparate datasets
- Translating business requirements into technical data solutions
- Identifying root causes
- Recommending sustainable solutions
- Managing multiple complex projects and priorities
- Working independently
- Communicating complex analytical findings clearly and effectively
- Exercising sound judgment when handling sensitive financial and organizational information
- Compiling, reviewing, and analyzing data
- Experience creating visualizations utilizing Microsoft Power BI or Tableau applications preferred.
Location
- AUSTIN
Work Type
- Eligible for Telework
- Full time remote worker
- Full time
Experience Level
- Data Analyst IV
Education Level
- 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, data science or a related field is generally preferred.
- Experience and education may be substituted for one another on a one-to-one year basis.
Salary/Compensations
- $5,425.33 - $8,886.16 Monthly
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 may be available
About the Company
- 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.
Equal Opportunity
- 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.