Functional Title: Senior Financial Analyst IV Job Title: Financial Analyst IV Agency: Dept of Family & Protectve Svc Department: CHIEF INFORMATION OFFICE-CAP Posting Number: 15183 Closing Date: 10/06/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: 3404,3408,8844,36A,70C,36B,65FX,65WX,6F0X1,F&S,FIN10
Brief Job Description:
Performs highly advanced (senior-level) financial analysis and regulatory work within Information Technology Services (ITS). Work involves building analytical tools, translate financial information into actionable insights, design and development of financial applications, automation of processes used to produce operational financial results, and creation of automated dashboards to support strategic decision-making.
This is a hybrid role for a highly skilled and analytical professional with combined software/database development, architecture, and advanced financial analysis. The candidate will serve as the primary bridge between the Finance Department and the Oracle environment. The Senior Financial Analyst will be responsible for leading the architecture for the ITS Finance environment, including query development, refining SQL queries, and building sophisticated data models in Power Pivot and Power BI.
Work also involves reviewing, analyzing, and evaluating financial and operational data; creating dashboards, preparing ah-hoc reports, presentations, and responding to internal inquiries. The candidate should have advanced skills using Excel, SQL, creating relational databases, Oracle environments, and modern data visualization tools such as Power BI and Power Pivot, as well as other tools. Ideally, the candidate should have a working knowledge of the state Appropriation Bills.
The mission of DFPS is to protect children, the elderly, and people with disabilities from abuse, neglect, and exploitation by involving clients, families, and communities. We are looking to grow our teams with people who share our energy and enthusiasm to get behind our mission of protecting those among us who are most in need.
This position is classified as a full-time position (40 hours a week). Work outside of regular hours may be required. Travel to other Austin offices(s) may be required. Works under minimal supervision, with latitude to use initiative and independent judgement.
Essential Job Functions:
Accounting and Financial Responsibilities:
- Design, develop, and maintain relational Oracle database tables to support financial and operational reporting needs.
- Write, optimize, and maintain complex SQL queries, stored procedures, and data pipelines.
- Manage and support Oracle database environment, ensuring data integrity, performance and security.
- Develop and maintain data models to support analytics and reporting.
- Design and develop interactive dashboards and reports using Power BI and Power Pivot.
- Reviews, analyzes, evaluates financial data, and performs budget monitoring, projections, cost analysis for the agency IT program.
- Develop and maintain accurate and timely departmental budget reports about the condition of the ITS Program finances.
- Assists with development of financial related procedures for the ITS Program.
- Interprets state and federal fiscal policies, procedures, and regulations; and maintains knowledge of state and federal funding policies and regulations as they affect the ITS operations and project fiscal responsibilities.
- Monitors ongoing project and operational financial data and makes recommendations for next actions based on findings.
Knowledge Skills and Abilities:
- Four to seven years' experience performing accounting, budgeting, financial planning, cost accounting, and cost recovery in a mid- to large-sized organization; with at least two years within an IT environment (and some experience in a non-profit or public-sector organization).
- Deep knowledge of tools such as Advanced Excel, Power BI, Power Automate, Power Pivot, DAX and SQL, with the ability to design and implement scalable dashboards, automated workflows, and data pipelines.
- Skilled in transforming raw data into actionable insights and streamlining manual reporting processes.
- Significant experience with ORACL ERP and financial systems
- Able to extract, transform, and load (ETL) data from multiple sources to support comprehensive financial reporting and analysis.
- Strong ability to perform complex ad hoc analyses, interpret large datasets, and identify trends, anomalies, and opportunities. Adept at using data to answer open-ended business questions and support strategic initiatives.
- Excellent communication skills, with the ability to translate technical findings into clear, actionable insights for non-technical stakeholders.
- Knowledge of automated accounting systems and resource and time tracking databases.
- Ability to analyze, evaluate, and summarize financial and management records for accuracy and conformance to standards.
- Ability to provide accurate and fact-based supporting documentation.
- Ability to document policies, procedures, and processes.
- Advanced Microsoft Office skills, particularly Excel; and Power BI, Power Pivot, database development, and Oracle.
Registrations, Licensure Requirements or Certifications:
- Prefer CPA or CMA certification.
- Prefer SQL and MS Certification
Initial Screening Criteria:
- At least three years' progressive experience developing, maintaining, and analyzing budgets, forecasts, cost allocations, and financial models to support business planning.
- Experience supporting month-end and quarter-end reporting cycles with data validation and variance analysis.
- Deep knowledge of tools such as Advanced Excel, Power BI, Power Automate, Power Pivot, DAX and SQL, with the ability to design and implement scalable dashboards, automated workflows, and data pipelines.
- Skilled in transforming raw data into actionable insights and streamlining manual reporting processes.
- Three years of experience in corporate finance, FP&A, and data analytics.
- Experience with ORACL ERP and financial systems. Minimum of four years experience in programming and data analysis. Minimum of three years experience in budgeting/forecasting and accounting.
- Graduation from an accredited four-year college or university with major coursework in accounting; or documented experience related to this position.
- Experience and education may be substituted for one another on a year-for-year basis.
Additional Information:
This position is designated as remote. However periodically, with advanced notice, will be required to be onsite in Austin State Office.
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.
