Data Analyst IV
Role Overview
Reports to the Financial Data Team Manager in the Office of Finance and performs complex data analysis, reporting, and data management for agency financial and operational objectives.
Acts as an analytical resource, providing guidance on data practices, reporting methods, system requirements, and process improvements.
Key Skills for This Role
Full Job Posting
Role overview
Reports to the Financial Data Team Manager in the Office of Finance and performs complex data analysis, reporting, and data management for agency financial and operational objectives.
Acts as an analytical resource, providing guidance on data practices, reporting methods, system requirements, and process improvements.
Key duties
- Analyze, interpret, validate, and present complex data from multiple systems; identify trends and anomalies and translate findings into actionable insights.
- Prepare reports, dashboards, presentations, and materials to support data-based decisions.
- Use SQL, Visual Basic, and TOAD to write, extract, query, and compile data for financial reports, including MFR, LAR, base reconciliation, AFR, SEFA, and 1099 reporting.
- Prepare routine, ad hoc, and customized reports; respond to open-records requests and audit inquiries.
- Establish data standards, business rules, quality controls, and metrics; evaluate data completeness, accuracy, consistency, and reliability.
- Develop validation and reconciliation processes to support root-cause analysis and corrective action; recommend data-quality improvements.
- Support integration and interoperability between financial, operational, and reporting systems.
- Evaluate CAPPS Financials changes for impacts on data structures, reporting, interfaces, and downstream processes; maintain EDI layouts.
- Collaborate with Office of Finance staff to ensure data is accurate, reliable, accessible, and aligned with agency requirements.
Qualifications and expertise
- Technical expertise in analyzing, interpreting, validating, and presenting complex data from multiple systems and sources.
- Use of SQL, Visual Basic, and TOAD for data analysis and reporting.
- Capability to develop data validation, reconciliation, data-quality controls, and reporting processes.
- Ability to prepare clear reports, dashboards, presentations, and other decision-support materials.
- Ability to advise on data practices, reporting methodologies, system requirements, and process improvements.
Salary and pay frequency
- Salary range is $5,425.33–$8,886.16 per month.
Employment and schedule
- Full-time, regular position with a day shift.
- Travel is listed as up to 5%.
Workplace
- The description identifies the position as full-time remote and eligible for telework.
Benefits
- Full-time State of Texas benefits include health insurance contributions, retirement plans, paid vacation and leave, optional insurance, flexible spending accounts, and employee discounts.
- Public Service Loan Forgiveness may be available to eligible employees.
About the agency
The Texas Department of Family and Protective Services works with families and communities to keep children and vulnerable adults safe through investigations, services, and referrals.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Department Of Family And Protective Services
Budget Analyst V - Method of Finance
Austin, USA
The Texas Department of Family and Protective Services is seeking a senior-level Budget Analyst to lead budget preparation, analysis, and reporting for designated program areas. The role requires advanced budget expertis
CPI Investigation Worker Trainee
Dallas, USA
Texas DFPS seeks a trainee investigator to respond to child abuse and neglect reports, assess child safety, and coordinate interventions with families and community partners. The work is mobile and demanding, with substa
Staff Services Officer I - Talent Acquisition Group
Arlington, USA
DFPS is seeking a Staff Services Officer I to support its Talent Acquisition Group and help deliver a smooth onboarding experience. The role coordinates recruitment and orientation activities, maintains personnel records