Data Analyst V (AUSTIN, TX)

Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.

Data Analysis and Visualization – Compiles, queries, and loads data points using SQL, and other query languages, into databases from a variety of source formats to support complex analyses.

Cleans and prepares data, as necessary, for access to other analysts in their work products as well as data visualization.

Provides guidance and mentorship on data use and best practices to analysts throughout the department. (20%)

Data Quality – Establishes and updates data quality metrics, recommending and implementing improvements to data quality associated with processes.

Ensures data integrity by identifying data gaps, errors, anomalies, inconsistencies, and redundancies in the content, structure, and relationships within data; coordinates with stakeholders to improve data quality.

Interprets results to identify significant differences in data.

Identifies and interprets data patterns and trends and assesses data quality. (20%)

Reporting – Oversees development of high-quality written projects and reports; guides the selection of data management tools, the development of standards, usage guidelines, and procedures for those tools to be used by the rest of the team.

Defines, develops, and implements data standards.

Coordinates with others who collect, organize, analyze, and prepare materials in response to requests for information and reports specific to the data.

Prepares concise, comprehensive technical reports to present and interpret data; makes recommendations on revisions to data collection methodologies.

Develops software applications or programming to use for financial analysis, statistical modeling, and graphic analysis. (5%)

Coordination – Utilizes strong communication skills to explain PFD and Data Integration business processes and negotiate for information and resources needed to ensure successful initiatives.

Consults with internal and external stakeholders regarding PFD data needs and requests.

Coordinates with subject matter experts to ensure accuracy of reporting tools, workflows and reporting procedures. (20%)

Process Improvement – Provides feedback regarding systematic changes to improve data collection and align data infrastructure with business needs.

Makes recommendation to improve efficiency and quality of data and reporting processes.

Provides routine updates on the status of projects and initiatives. (20%)

Infrastructure Support – Oversees, plans, directs and monitors key analytic functions relating to the day-to-day activities of the Data Integration & PFD.

Performs quality assurance and serve as a subject matter expert on data integrity, extraction, and compilation. (10%)

Performs other work as assigned or required to maintain and support the office and HHSC operations. (5%)

Knowledge of:

• Knowledge of data analysis techniques and best practices.
• Knowledge of data quality and integrity processes.
• Knowledge of the principles, practices and techniques of database and application design, development and structure.

Skill in:

• Skill in complex analytic work, identifying trends, concerns, recommending opportunities for improvement as well as areas of excellence.
• Skill in using SQL, SAS, SPSS, Python, and other query languages.
• Skill in using Extract, Transform and Load tools.

Ability to:

• Ability to work collaboratively across PFD to accomplish objectives.
• A keen attention to detail and the ability to implement creative solutions to problems.
• Able to balance team and individual responsibilities.
• Ability to work on a team, and to be flexible and creative with data demands.
• Ability to plan, organize and conduct data analytic projects.
• Ability to develop and interpret data charts, maps, and tables.
• Ability to interpret and publish data analytic findings.
• Ability to exercise independent judgment and show initiative.
• Ability to maintain detailed and organized documentation of data analytic projects.
• Ability to compile, review, and analyze data; to prepare reports; to maintain accuracy and attention to detail; to communicate effectively; and to supervise the work of others.

Graduation from an accredited four-year college or university with a bachelor’s degree in social science; business, including accounting and statistics; mathematics; physics; economics; health-related field; political science; or other closely related field.

At least three years of work and deep experience with data analytics.

with Health and Human Services data is preferred.

Education and work experience can be substituted for one another on a year-for-year basis.

with Medicaid and/or healthcare finance preferred.

with cloud-based database(s) preferred.

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 .

In compliance with the Americans with Disabilities Act (ADA), HHSC and DSHS 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 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.

Depending on the program area and position requirements, applicants selected for hire may be required to pass background and other due diligence checks.

HHSC uses E-Verify.

You must bring your I-9 documentation with you on your first day of work.

Download the I-9 Form

This position may be eligible for telework.

Please note, all HHS positions are subject to state and agency telework policies in addition to the discretion of the direct supervisor and business needs.