Data Analyst III (Office of Finance)

Summary

The Texas Department of Family and Protective Services works to protect children and vulnerable adults through investigations, services, and referrals. The Data Analyst III supports the Office of Finance by analyzing, querying, reconciling, and compiling financial data, maintaining data integrity and security, preparing financial reports, and identifying trends and anomalies to support organizational decision-making.

Responsibilities

• Performs data integrity functions in CAPPS Fin, subsystems, and applications involving the maintenance of financial data fields within the chart of accounts, establishing/updating data fields, performing combo edit rule maintenance to establish correct combinations of data fields, performing system tree maintenance to establish and maintain correct data hierarchy within CAPPS Fin and other subsystems and applications. Maintains electronic data interface (EDI) layout to ensure compliance with PeopleSoft and IRS regarding data formatting
• Serves as the security coordinator for the internal and external financial systems. Reviews, analysis, and determines the appropriateness of the roles, identifies conflicts, and recommends changes. Performs user access audits and certifications. Recommends changes and improvements to ensure compliance with Comptroller policies and best practices
• Writes, extracts, queries, and compiles data for the completion of audit requests, open records requests, and ad hoc requests requiring use of computer programming languages such as SQL and Visual Basic. Performs data analysis using statistical tools such as SAS and TOAD and applying industry standard methods and techniques
• Prepares data sets, financial and technical reports to be used for agency’s major 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 by extracting, querying and compiling data out of CAPPS HR, CAPPS Financials, and other databases for presentation, identifying trends, inconsistencies, anomalies, redundancies, and for making decisions and recommendations to make data revisions to present a more accurate picture of the data and aid in management decision-making
• Attends work regularly in accordance with agency leave policy

Skills

• Knowledge of data analysis and statistical data modeling and security protocols for data access, data handling, and protecting and distributing confidential data
• Advanced Microsoft Office (Excel, Word, PowerPoint), business objects, financials software/applications, claims processing engines, SQL, R, SAS, Python
• Knowledge of data quality and integrity processes and techniques for process improvement
• Skill in managing multiple and competing priorities and identifying problems, evaluating alternatives, and implementing solutions
• Skill in various programming languages and usage of computer and system tools and applications
• Skill in how to explain, advocate, express facts and ideas, and negotiate with individuals and groups, internally and externally
• Ability to perform data analysis, statistics, data visualization, methods of funding, program rules
• Ability to recommend, design, develop, and implement new technology/ work processes that benefit the organization
• Ability to produce results through planning, development and implementation automated solutions and business processes
• Ability to build, establish, and maintain effective working relationships with diverse groups
• Ability to work effectively in a team environment
• Experience writing scripts or code to extract, compile and present data or models using computer programming languages such as SQL is required
• Experience in data analysis, research, and compilation is required
• Knowledge of budget and general ledger financial reporting preferred
• Graduation from an accredited four-year college or university with major coursework in data science, business, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field is generally preferred
• 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

Qualifications

Must Haves

• Knowledge of data analysis and statistical data modeling and security protocols for data access, data handling, and protecting and distributing confidential data
• Advanced Microsoft Office (Excel, Word, PowerPoint), business objects, financials software/applications, claims processing engines, SQL, R, SAS, Python
• Knowledge of data quality and integrity processes and techniques for process improvement
• Skill in managing multiple and competing priorities and identifying problems, evaluating alternatives, and implementing solutions
• Skill in various programming languages and usage of computer and system tools and applications
• Skill in how to explain, advocate, express facts and ideas, and negotiate with individuals and groups, internally and externally
• Ability to perform data analysis, statistics, data visualization, methods of funding, program rules
• Ability to recommend, design, develop, and implement new technology/ work processes that benefit the organization
• Ability to produce results through planning, development and implementation automated solutions and business processes
• Ability to build, establish, and maintain effective working relationships with diverse groups
• Ability to work effectively in a team environment
• Experience writing scripts or code to extract, compile and present data or models using computer programming languages such as SQL is required
• Experience in data analysis, research, and compilation is required

Nice to Haves

• Knowledge of budget and general ledger financial reporting preferred
• Graduation from an accredited four-year college or university with major coursework in data science, business, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field is generally preferred
• 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

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, plus options to save even more with 401(k) and 457 plans
• Paid vacation, holidays, and sick leave
• 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.
• Eligible for Telework
• Full time remote worker