Data Analyst V

3 weeks ago


Austin, United States Texas Department of Aging & Disability Services Full time
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.

  • Budget Analyst V

    2 minutes ago


    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: Budget Analyst V Budget Analyst V The Budget Analyst V position performs highly advanced (senior-level) budget preparation and analysis work for the various DFPS program areas. Work involves overseeing the planning, organizing, coordinating, and evaluating of budgetary activities necessary to produce budget reports including the...

  • Data Analyst V

    1 month ago


    Austin, United States Health & Human Services Comm Full time

    Data Analyst V**Essential Job Functions**: EJ1: Identification and analysis of external factors impacting the demand for and utilization of Health and Human Services and the agency’s ability to provide services. Designs and produces data analyses and reports to evaluate the impact of patterns and trends in demographic, socioeconomic, health, and other...

  • Research Specialist V

    4 weeks ago


    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: The Research Specialist V reports to the Manager of the Research, Development and Methodology (RDM) Team within the Long-Term Services and Supports (LTSS) section of the Provider Finance Department (PFD) and performs advanced (senior-level) research and rate setting work, including evaluation of existing, new or alternative rate...

  • Data Management

    1 day ago


    Austin, United States Cogent Data Solutions Llc Full time

    Hello, Cogent Data Solutions LLC trying to reach you regarding a job opportunity. The role is Data Management ( Systems Analyst ) for one of our direct clients. Please take a look at the job description below and please send your updated resume. Role: Data Management ( Systems Analyst )Location: Hybrid , Tuesdays ( Onsite ) - Austin, TX ( Local Only )...


  • Austin, United States COGENT DATA SOLUTIONS LLC Full time

    Hello,Cogent Data Solutions LLC trying to reach you regarding a job opportunity. The role is Data Management ( Systems Analyst ) for one of our direct clients. Please take a look at the job description below and please send your updated resume.Role: Data Management ( Systems Analyst )Location: Hybrid , Tuesdays ( Onsite ) - Austin, TX ( Local Only )Client...


  • Austin, United States COGENT DATA SOLUTIONS LLC Full time

    Hello,Cogent Data Solutions LLC trying to reach you regarding a job opportunity. The role is Data Management ( Systems Analyst ) for one of our direct clients. Please take a look at the job description below and please send your updated resume.Role: Data Management ( Systems Analyst )Location: Hybrid , Tuesdays ( Onsite ) - Austin, TX ( Local Only )Client...

  • Data Analyst

    6 days ago


    Austin, United States ADVANTAGE BUSINESS CONSULTING LTD Full time

    **Responsibilities**: - Develop and implement databases, data collection systems, data analytics, and other strategies that optimise statistical efficiency and quality. - Acquire data from primary or secondary data sources and maintain databases/data systems. - Interpret data, analyse results using statistical techniques, and provide ongoing reports. -...

  • Data Analyst IV

    3 weeks ago


    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: Performs complex (journey-level) data analysis and data research work within the DPP Medicaid Cost / Accountability Reports data for the Health and Human Services Commission (HHSC), Financial Services Division (FSD), Provider Finance Division (PFD), Cost Report Review Unit (CRRU) to support the Directed Payment Programs (DPP). Work...

  • Systems Analyst V

    1 month ago


    Austin, United States Health & Human Services Comm Full time

    **Essential Job Functions**: - EJF2. May participate in the development and/or review of training materials to be provided to end users. Leads the assessment and analysis of training needs by identifying trends and/or soliciting input from program staff to ensure training materials and information are appropriate for both internal and external customers,...

  • Data Analyst IV

    5 days ago


    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: Under the supervision of the Performance Monitoring and Analytics Manager, the Data Analyst IV performs complex (journey-level) data collection and research, reporting and analysis to monitor, evaluate and increase efficiencies for Foster Care Litigation (FCL) activities and initiatives for Child Care Regulation (CCRL), within the Health...


  • Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: The Data Analyst V (Data Analyst Manager) reports to the Director of Operations with the Managed Care Utilization Review (MCUR) department. The Data Analyst Manager will be responsible for overseeing the day-to-day operations of the data analysts’ team, ensuring the accuracy, integrity, and efficiency of data-related processes. Performs...


  • Austin, United States Lansweeper NV Full time

    ** Data Warehouse Analyst** * Business Applications * Austin, United States ** Data Warehouse Analyst** ** Job description** *With a recently announced* *from* *and an impressive yearly revenue growth, Lansweeper is rapidly expanding its* *Global teams. We now need a Data Warehouse Analyst to help in our growth journey!* *is an IT asset management software...

  • Research Analyst

    4 weeks ago


    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: The Office of Data, Analytics, and Performance (DAP) is seeking a highly-qualified candidate to fill the position of the Research Analyst (Research Specialist V) on the Applied Statistics & Evaluation Team. This position will help DAP transform data into meaningful information to improve the well-being of Texans. The ideal candidate will...

  • Data Analyst IV

    20 hours ago


    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: Data Analyst IV The Texas Health and Human Services Commission (HHSC) seeks highly qualified candidates to fill the Data Analyst IV position within the Access & Eligibility Services (AES) Department Eligibility Operations Integrity Support Services (ISS). The Data Analyst IV serves as lead subject matter expert on data integrity,...

  • Data Analyst

    7 days ago


    Austin, United States AllianceIT Inc Full time

    SSIS and SSRS Report writer/Data AnalystAustin, TX – OnsiteMigrating and converting existing reports on our legacy mainframe environment to SSRS.Skills(Required):SSRS/SSISVisual StudioSQLDB2Additional Qualifications :Develop, design, and maintain SSRS reports and SSIS packages.Work closely with stakeholders to gather requirements and translate them into...

  • Data Analyst

    5 days ago


    Austin, United States AllianceIT Inc Full time

    SSIS and SSRS Report writer/Data AnalystAustin, TX – OnsiteMigrating and converting existing reports on our legacy mainframe environment to SSRS.Skills(Required):SSRS/SSISVisual StudioSQLDB2Additional Qualifications :Develop, design, and maintain SSRS reports and SSIS packages.Work closely with stakeholders to gather requirements and translate them into...

  • Data Analyst

    6 days ago


    Austin, United States AllianceIT Inc Full time

    SSIS and SSRS Report writer/Data AnalystAustin, TX – OnsiteMigrating and converting existing reports on our legacy mainframe environment to SSRS.Skills(Required):SSRS/SSISVisual StudioSQLDB2Additional Qualifications :Develop, design, and maintain SSRS reports and SSIS packages.Work closely with stakeholders to gather requirements and translate them into...

  • Management Analyst V

    3 weeks ago


    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: Performs highly advanced and/or supervisory (senior-level) professional organizational and policy analysis and oversight work. Conducts organizational studies and evaluations, analyzes systems and procedures, conducts work simplification studies, and prepares operations and procedures manuals to assist management in operating more...

  • Data Security Analyst

    5 hours ago


    Austin, United States Dutech Systems Full time

    Responsible for installing and uninstalling various security programs These programs often protect sensitive data using firewalls and data-encryption technology, and they must be updated on a regular basis to remove bugs and add new features. This position will perform Security Administrator duties that include assessing business requirements,...

  • Data Analyst III

    4 weeks ago


    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: Data Analyst III: The Data Analyst III within the IIS Analytics Group performs routine (journey-level) data analysis work as assigned by the IIS Analytics Group manager. Work involves data analysis and reporting of immunization data and refining analytical processes in support of Texas' Immunization programs which includes the Texas...