Dept of State Health Services
Health Informatics Spec I
Dept of State Health Services, Austin, Texas, us, 78716
Job Description:Under the direction of the RLHO Information Systems (RIS) Manager, the CMIS Reporting Specialist performs routine data management and extraction duties for the DSHS case management and case investigation system (CMIS), myInsight. The RIS group is responsible for project management and execution, ensuring information security and coordination with IT teams and the RLHO Analytics group to ensure maintenance and optimization of TxS2, CMIS, and Qualtrics. The RIS group is part of the Analytics and Information Management Unit within the RLHO Division. Our mission is to analyze and transform public health information that empowers stakeholders to make data-driven decisions and improve outcomes.
Essential Job Functions:Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.
The Reporting Specialist is responsible for:
•Serving as a subject matter expert on the configuration of the CMIS reporting database.
•Writing SQL queries to extract data and creating custom reports beyond standard system offerings.
•Using knowledge of CMIS database configuration to create data dictionaries and report descriptions for end users.
•Identifying, documenting, and defining reporting needs for DSHS RLHO and Central Office Programs.
•Maintaining and distributing data files to the designated destination for access by stakeholders to meet grant, state, and federal reporting requirements, and for general analysis to inform and advance public health practices.
•Interfacing with regional staff, ITPHA and the Analytics Group on reporting requirements, data requests and user-acceptable testing.
•Designing electronic reporting mechanisms, such as automated reports and visualizations for public health purposes.
•Participating in meetings and working groups to discuss data extraction and storage, data policies and procedures, and retention.
Knowledge Skills Abilities:•Knowledge of SQL and database management systems for data extraction and reporting.•Knowledge of metadata standards, data dictionaries, systems design, and report documentation.•Skill in developing electronic reports from databases.•Skill in using SAS, SQL, R, Business Objects, or other software packages.•Skill in complex problem-solving and critical-thinking skills.•Ability to manage, manipulate, and analyze complex databases for public health reporting.•Ability to ensure the confidentiality, security, and integrity of health data.
Registration or Licensure Requirements:
Initial Selection Criteria:Graduation from an accredited four-year college or university with major coursework in informatics, computer science, database management, information systems management, or a related field.
Experience with computer software packages including SQL, SAS, R.
Preferred selection criteria:
Experience in health informatics or clinical data management.
Additional Information:Requisition # 619413
This is a temporary position and expected to last up to July 31, 2026. Upon hire, the selected candidate will be required to sign a Temporary Employment Agreement indicating awareness that the employment status of the position is temporary.
Applicants who meet initial screening criteria will be required to take a skills test. Applicants who pass the skills test will be offered an interview.
Must be legally authorized to work in the U.S. without sponsorship.
Agency salary policy, budget and candidate's qualifications will dictate the final salary offer.
MOS Code:Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to: 70D, 230X, 41AX. All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information see the Texas State Auditor's Military Crosswalk at http://www.hr.sao.state.tx.us/Compensation/JobDescriptions.aspx.
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
Essential Job Functions:Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.
The Reporting Specialist is responsible for:
•Serving as a subject matter expert on the configuration of the CMIS reporting database.
•Writing SQL queries to extract data and creating custom reports beyond standard system offerings.
•Using knowledge of CMIS database configuration to create data dictionaries and report descriptions for end users.
•Identifying, documenting, and defining reporting needs for DSHS RLHO and Central Office Programs.
•Maintaining and distributing data files to the designated destination for access by stakeholders to meet grant, state, and federal reporting requirements, and for general analysis to inform and advance public health practices.
•Interfacing with regional staff, ITPHA and the Analytics Group on reporting requirements, data requests and user-acceptable testing.
•Designing electronic reporting mechanisms, such as automated reports and visualizations for public health purposes.
•Participating in meetings and working groups to discuss data extraction and storage, data policies and procedures, and retention.
Knowledge Skills Abilities:•Knowledge of SQL and database management systems for data extraction and reporting.•Knowledge of metadata standards, data dictionaries, systems design, and report documentation.•Skill in developing electronic reports from databases.•Skill in using SAS, SQL, R, Business Objects, or other software packages.•Skill in complex problem-solving and critical-thinking skills.•Ability to manage, manipulate, and analyze complex databases for public health reporting.•Ability to ensure the confidentiality, security, and integrity of health data.
Registration or Licensure Requirements:
Initial Selection Criteria:Graduation from an accredited four-year college or university with major coursework in informatics, computer science, database management, information systems management, or a related field.
Experience with computer software packages including SQL, SAS, R.
Preferred selection criteria:
Experience in health informatics or clinical data management.
Additional Information:Requisition # 619413
This is a temporary position and expected to last up to July 31, 2026. Upon hire, the selected candidate will be required to sign a Temporary Employment Agreement indicating awareness that the employment status of the position is temporary.
Applicants who meet initial screening criteria will be required to take a skills test. Applicants who pass the skills test will be offered an interview.
Must be legally authorized to work in the U.S. without sponsorship.
Agency salary policy, budget and candidate's qualifications will dictate the final salary offer.
MOS Code:Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to: 70D, 230X, 41AX. All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information see the Texas State Auditor's Military Crosswalk at http://www.hr.sao.state.tx.us/Compensation/JobDescriptions.aspx.
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