The Data Analyst V performs highly complex (senior-level) data analysis, data research, database management, and application development assignments for the Aging and Disability Data Management (ADDM) section in the Center for Analytics and Decision Support (CADS) in order to detect data trends and anomalies, optimize health outcomes, and provide HHSC programs and executive management with information necessary to make data-informed management decisions and explore 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; and mentoring ADDM team members in the use of compiled data sets. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment. Essential Job Functions:
EJF #1: Consults and coordinates with ADDM, CADS and other HHSC staff in order to identify potential areas for increased efficiencies through the use of automation. Designs, develops, codes, tests, implements and maintains and documents computer applications to implement those efficiencies. (40%)
EJF #2: Consults and coordinates with ADDM, CADS and other HHSC staff in order to identify business needs related to Long Term Services and Supports (LTSS) and reference data in various HHS and other systems and transform research and reporting requirements into ADDM/CADS data systems. Acquires, extracts, cleans, transforms and loads needed datasets into ADDM/CADS database systems. Mentors ADDM staff in the use of data systems. (40%)
EJF #3: Prepares and reviews a variety of written, oral, and graphical deliverables containing analyses of Health and Human Services data in order to detect data trends and anomalies, optimize health outcomes, and also to provide HHSC programs and executive management with information necessary to make data-informed decisions. (20%) Knowledge Skills Abilities:
Knowledge of the process of computer application development.
Knowledge of data analysis techniques.
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 design, develop, code, test, implement, maintain and document computer applications.
Ability to manage, manipulate, and analyze complex databases.
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:
N/A Initial Selection Criteria:
Graduation from an accredited 4 year college or university with major coursework in a social science, business, statistical or related field. Master's Degree preferred. Three or more years work and experience with acquisition, collection, management, analyses and dissemination of health and human services related data and/or large datasets preferred. Skills in performing ETL preferred. Demonstrated ability to build applications or ETL scripts using scripting/programming languages such as Visual Basic, Perl, and PowerShell preferred. Additional Information:
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.