Data Analyst III

TX-HHSC-DSHS-DFPS • Austin, TX

18h • Onsite

About The Position

Data Analyst III (DA III) performs highly advanced (senior-level) analysis, research and evaluation of vital statistics data (birth, death, fetal death) to make recommendations on improving data quality and accuracy of vital statistics for public health purposes to Vital Statistics Section (VSS) and Department of State Health Services (DSHS), legislative entities, and Vital Statistics federal partners. The DA III reports to the VSS Analytics and Analysis Data Analyst V Manager. The DA III provides daily counsel to the manager in establishing daily activities of the data management team, including setting goals and objectives, priorities and standards to achieve established goals, and data analysis and research of team activities. The DA III manages the development, implementation, and analysis of vital statistics data projects; the review and analysis of legislation, regulations, and policy requiring data analysis and research activities; and the preparation and presentation of data analysis and research findings. The DA III implements advanced evaluative and statistical methods to vital statistics data; writes advanced scripts and code for computer based statistical software to enhance an understanding of VSS programs and issues. This position develops, prepares and writes a variety of reports, studies, and other deliverables for VSS administration; including policy analysis containing analyses of vital statistics data, the methods and procedures used, and the relevant sources referenced. The DA III provides consultation and assistance to internal and external staff and other DSHS agencies in developing evaluative methods and strategies for more effective reporting of data and analyses. Assists the DA V to insure team goals are met. Performs work under minimal supervision with considerable latitude for the use of initiative and independent judgement.

Requirements

• Knowledge of and ability to interpret Texas Vital Statistics laws, policies, procedures and regulations.
• Knowledge of vital statistics and other population-based data sources for surveillance.
• Knowledge of web-based data systems.
• Knowledge of running queries, report writing, and presenting findings.
• Knowledge of data models and database design development.
• Knowledge of data mining and segmentation techniques.
• Knowledge of security procedures for handling, protecting, and distributing confidential data.
• Knowledge of Structured Query Language (SQL).
• Skill in computer systems, coding, programming, management reporting, data functions, and extraction.
• Skill in analyzing problems and devising effective solutions; complex problem solving.
• Skill in developing goals and objectives and develop procedures to monitor and evaluate process.
• Skill in advanced use of computer software, such as Word, Excel, PowerPoint, Tableau, and report/query.
• Skills in planning, scheduling and prioritizing work assignments.
• Skill in business program analysis.
• Skill in managing projects.
• Ability to gather, assemble, correlate, interpret and analyze data.
• Ability to plan, organize, schedule and monitor completion of assigned projects.
• Ability to prepare concise reports.
• Ability to implement and define data standards; to include writing and presentation of findings.
• Ability to develop and revise policies and procedures.
• Ability to communicate clear, concisely and effectively.
• Ability to work in a team-approach collaborative environment and provide guidance to others.
• Ability to construct complex SQL queries.
• Ability to perform detailed work accurately and in accordance with standards.
• Ability to communicate, coordinate and gain rapport with external and internal stakeholders.
• Ability to prepare and present comprehensive reports and recommendations in written and oral form.
• Graduation from an accredited four-year college or university with major course work in computer science, computer information systems, management information systems, public health, or a related field.
• Minimum 2 years’ Experience in data analysis, data modelling, and process design.
• Minimum 2 years’ experience in vital statistics, health statistics or closely related discipline.
• Master's Degree may be substituted for work experience on a year for year basis up to two years.

Responsibilities

• The DA III conducts continued analysis and research of vital statistics data to make recommendations on improving data quality, security and accuracy of vital statistics while following mandated policies and procedures as well as legislative guidance.
• Manages the planning, designing and development of technically advanced SQL code programming and report layout with data management team to ensure user data requests are properly translated for use in statistical modeling and graphic analysis reports and ensure security measures and protocol have been followed.
• Manages data extraction from TxEVER and other agency databases using advanced SQL code.
• Provides daily guidance that supports the organization of daily activities regarding data management team in daily functions; preparing reports, studies, and other deliverables containing analyses of vital statistics data related to births, deaths and fetal deaths by established goals and objectives for improving data quality, safeguarding vital record data and ensuring delivery timelines have been met.
• Provides training, development and implementation of research methods and analytical procedures for evaluating vital statistics data to data management team; applies advanced statistical methods to vital statistics data, coordinates and organizes project design, plans statistical analysis and/or reporting.
• Provides development of advanced scripts and code for computer based statistics applications (statistical modeling/graphic analysis) and documents processes and procedures for technical and non-technical TxEVER users.
• Serves as subject matter expert regarding VSS data integrity and performs quality assurance activities regarding VSS data.
• Works on continuous process improvement regarding analyzing VSS data for statistical use, identifying inconsistencies, identifying significant differences in data and preparing associated reports in order to advise and make data revisions.
• Implements a high level of data security, standards and maintains positive rapport with internal and external stakeholders.
• The DA III supports and assists DA V manager in overseeing a multidisciplinary data and reporting staff. This includes screening and interviewing candidates, assigning work, developing performance standards, making recommendations for performance evaluations and counseling.
• The DA III also recommends personnel or disciplinary actions and follows all requested leave approvals. Assists with staff development to ensure and encourage high standard of work output and team building.
• The DA III provides fulfillment of requests for vital statistics data from a variety of internal and external stakeholders such as the Office of Inspector General Medicaid Fraud Unit, Teachers Retirement System of Texas, Texas Secretary of State Office, Social Security Administration and HHSC Medicaid Eligibility per contractual agreement.
• Work involves using advanced and complex SQL queries to extract data regularly from the vital records registration database in flat file formats.
• The DA III provides consultation and assistance to internal vital statistics staff and other DSHS agencies in developing methods and strategies for effective reporting of vital statistics data and analyses.
• Provides testing and evaluation data of newly developed knowledge, methods, and techniques in vital statistics data collection and reporting.
• Trains data management team on these methods and techniques to assist with process improvement.
• Defines requirements for development/modification of section interface files and tests for accuracy, reliability, and validity; reviews and organizes workloads with reporting staff.
• Works to analyze data to ensure there are no data inconsistencies.
• Implements and defines data standards.
• Consults with the Vital Reporting & Registration Branch manager in vital statistics policy development and revision to determine impact on reporting capabilities and current/future research.
• Fulfills role as Vital Statistics Section Technical Liaison backfill for the TxEVER development team to ensure functionality meets section reporting standards.
• Performs other related duties, as assigned.
• Perform duties in the absence of the DA V Manager.
• DSHS employees are expected to support this mission either by actively participating and/or serving in a supporting role to meet the agency's obligation for disaster response and/or recovery or COOP activation.

Benefits

• DSHS offers insurance coverage and other benefits available through the State of Texas Group Benefits Plan administered by the Employee Retirement System of Texas (ERS).

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees