Data Analyst III (Office of Finance) at Texas Health & Human Services Commission | Austin, TX, US | Rezi

Data Analyst III (Office of Finance) at Texas Health & Human Services Commission

Data Analyst III (Office of Finance)

Texas Health & Human Services Commission · Austin, TX, US

2 days ago

Data Analyst III (Office of Finance)

Texas Health & Human Services Commission · Austin, TX, US

2 days ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now
Resume preview

Tailor your resume to this Data Analyst III (Office of Finance) role.

Rezi rewrites your resume against Texas Health & Human Services Commission's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the Data Analyst III (Office of Finance) posting at Texas Health & Human Services Commission — free, in seconds.

About the Role

The Data Analyst III reports to the Financial Data Team Manager within the Office of Finance. The position performs moderate complex functions involving analysis, quality, research, and reconciliation. Work entails querying and compiling data, developing technical solutions such as creating databases, developing software applications using computer languages, as well as other maintenance related functions such as performing data quality metrics. The position prepares financial reports, identifies data trends, and establishes data quality metrics and measures to support organizational improvements.

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.

Requirements

  • 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.
  • 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.
  • 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.

Skills

  • Data analysis
  • Statistical data modeling
  • 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
  • Data quality and integrity processes and techniques for process improvement
  • Managing multiple and competing priorities
  • Identifying problems, evaluating alternatives, and implementing solutions
  • Various programming languages
  • Usage of computer and system tools and applications
  • Explaining, advocating, expressing facts and ideas, and negotiating with individuals and groups, internally and externally
  • Perform data analysis, statistics, data visualization, methods of funding, program rules
  • Recommend, design, develop, and implement new technology/ work processes that benefit the organization
  • Produce results through planning, development and implementation automated solutions and business processes
  • Build, establish, and maintain effective working relationships with diverse groups
  • Work effectively in a team environment

Location

  • AUSTIN

Work Type

  • Eligible for Telework
  • Full time remote worker
  • Full time

Experience Level

  • Data Analyst III

Education Level

  • 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.

Salary/Compensations

  • $4,801.16 - $7,761.50 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, plus 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

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

  • All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position.
  • 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.