Data Analyst V-604590

Remote (Austin, TX)

Job Description:

The Data Analyst V performs highly complex (senior level) data analysis, data research, database management, and application development assignments for the Data Management Unit within Information and Data Management Division, Office of Data, Analytics, and Performance (ODAP). Detects data trends and anomalies and provides HHSC programs and executive management with information necessary to make data-informed management decisions and explores potential program efficiencies. Work involves conducting detailed analysis of data sets, performing data needs assessment, data acquisition, cleaning and standardization, extraction, transformation and loading into database systems; designing, coding, testing, implementing and maintaining computer applications to increase efficiency through the automation of routine tasks. Mentors ODAP staff in the use of compiled datasets. Works under limited supervision, with moderate latitude for the use of initiative and independent judgment. 

Essential Job Functions:

EJF #1: Conducts detailed analysis of data sets to extract insights and detect trends. Performs data needs assessments, acquisition, cleaning, and standardization. Leads extraction, transformation, and loading processes into database systems. Designs, codes, tests, implements, and maintains computer applications to increase efficiency.

EJF #2: Consults, collaborates, and coordinates with HHSC IT, Texas Shared Technology Services, and data trading partners to maintain and troubleshoot computer applications and data management processes. Initiates and coordinates projects to refresh and upgrade database software and server operating systems. Ensures server and database configurations are updated to maintain connectivity with HHSC systems and data trading partners. Provides triage support for applications and databases to resolve functional and performance issues.

EJF #3: Consult with ODAP staff to identify programmatic and business needs. Conducts data needs assessments. Plans, designs, and develops data systems to meet ODAP data needs. Consults and coordinates with ODAP and other HHSC staff to identify potential areas for increased efficiencies and data flow automation. Conducts data profiling and data analysis to identify data quality issues and recommend improvements. Develops project plans, objectives, and timelines and executes them. Identifies and incorporates innovative solutions to streamline workflows and processes.

EJF #4: Prepares and reviews a variety of written, oral, and graphical deliverables containing analyses of Health and Human Services data to detect data trends, outliers, and anomalies, and provides HHSC programs and leadership with information necessary to make informed decisions on streamlining workflows and processes, modification of existing data models, and recommendations on the enhancement of database system architecture. Develops and maintains data quality and data governance processes to ensure accuracy, consistency, and integrity of data in the warehouses.

EJF # 5: Trains DAP staff on ODAP Data Repository (ODAP DR) and Quality Assurance and Improvement (QAI) Datamart applications and systems. Identifies areas for learning and development and participates in training programs available to HHSC and DAP staff members. Mentors ODAP staff in the use of data systems.

 Knowledge Skills Abilities:

Knowledge of the process of computer application development.

Knowledge of Oracle 19c on the Linux platform

Knowledge of data warehouse architecture of Star and Snowflake schemas used in relational, dimensional, and multi-dimensional data modeling.

Knowledge of scripting language to import and extract database information in a Linux batch environment – preferably PERL.

Knowledge of scientific research methods, statistical techniques, mathematics, geographical concepts, and their application to data analytics.

Knowledge of the various Texas Health and Human Service (HHS) programs.

Knowledge of patient level health and demographic data (e.g., Census, Vital, Medicaid, and CHIP data including eligibility, enrollment, medical claims, and encounters).

Knowledge of the principals, practices and techniques of database design and development, database structures and theories and current database technologies.

Knowledge of medical records systems or clinical coding practices.

Knowledge of Internet and World Wide Web.

Knowledge of computer programming principles, spreadsheet macros, and database design.

Skill in developing computer applications using high level interpreted languages such as Perl.

Skill in using SAS, SPSS, SQL, R, ACCESS, Business Objects, or other statistical and database management software.

Skill in using EXCEL or other spreadsheet software.

Skill in graphical, tabular, and geographical presentation of data.

Skill in verbal and written communications.

Skill in database management with Oracle, SQL Server, or similar large database systems.

Ability to analyze and solve problems.

Ability to design, develop, code, test, implement, maintain, and document computer applications.

Ability to manage, manipulate, and analyze complex databases.

Ability to Extract, transform, and load (ETL) data from various sources into the data warehouse using tools like Informatica, PERL, and Linux shell scripts.

Ability to oversee and/or supervise the work of others.

Ability to plan, organize, and conduct data analytic projects.

Ability to work in a team and to communicate effectively.

Ability to develop and interpret statistical 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 train staff in the use of data systems.

 Registration or Licensure Requirements:


Initial Selection Criteria:

Graduation from an accredited four-year college or university. Major coursework in computer science, computer information systems, database management, information systems management, or a related field is preferred. Experience in database administration, developing and running complex queries to retrieve data from transactional databases, and/or conducting extraction, transformation, and loading (ETL) processes may be substituted for education on a year for year basis.  

 MOS Code:

25B, IT,3D0X4  HHS agencies use E-Verify. You must bring your I-9 documentation with you on your first day of work.

I-9 Form - Click here to download the I-9 form.

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

Top 10 Tips for Success when Applying to Jobs at HHSC and DSHS

Subscribe to Job Alerts