Systems Analyst V

Job Description :

Under the supervision of the Performance Monitoring and Analytics Manager or designee, the System Analyst V performs highly complex (senior-level) systems analyses related to data collection, reporting, data quality and database management activities to monitor, evaluate and support efforts to increase efficiencies for Provider Investigations (PI) and Child Care Licensing (CCL), within the Health and Human Services Commission (HHSC).

As part of the RSDR team, this position will provide technical expertise to promote data-driven decision making and problem resolution through strategic guidance for PI and CCL leadership.

This position will participate in data system design meetings for agency initiatives to ensure the agency's ability to report applicable data.

The Analyst will provide customers with technical solutions to support reporting and analytic initiatives. This position participates in the selection of data management tools and the development of standards, usage guidelines and procedures for those tools, as well as recommendations for appropriate changes to internal policies and procedures.

This position will produce concise, comprehensive technical reports presenting findings, identify alternatives, recommendations for process improvement, and to outline solutions to monitor and implement data quality.

This position has considerable latitude for use of initiative and independent judgment. Essential Job Functions :

Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.

Infrastructure Support : Oversees, plans, directs and monitors key technical functions relating to the day-to-day activities of the RSDR team.

Oversees the development and implementation of databases, data collection systems and other strategies to optimize statistical efficiency and quality.

Compiles, queries and loads data using SQL and other query languages into databases from a variety of source formats to support complex analyses.

Maintains security protocols for confidential data as it relates to accessing, handling, protecting and distributing. Oversees the evaluation of RSDR technical activities to ensure Program reporting requirements are met. 30%

Data Quality / Integrity / Management : Monitors and ensures data quality, loading data into databases from a variety of sources, as well as formatting and automating data feeds, to be used as input for on-going and ad-hoc reporting, performance dashboards and other reports.

Develops scripts or code to extract, compile and present data or models using computer programming languages such as SQL.

Cleans and prepares data, as necessary, to produce data required for Tableau and other data visualization software. Extracts data from multiple sources for multiple report products.

Ensures accuracy of data included in reports 30%

Identify and Implement Improvements for Data Quality, Integrity and Management : Establishes and updates data quality metrics and recommends and implements improvements to data quality with processes.

Ensures data integrity by identifying, establishing and updating data quality metrics and recommends and implements improvements to data quality associated with processes.

Ensures data integrity by identifying gaps, errors, anomalies, inconsistencies, and redundancies in the content, structure, and relationships within data.

Provides suggestions for systematic changes that will improve the collection of data and align data infrastructure with business needs.

Provides routine updates on the status of projects and initiatives. 30%

Coordination : Customer service focused. Utilizes strong communication skills to explain RSDR, PI and CCL data processes and data management to negotiate information and resources needed to ensure successful Program initiatives.

Determines the scope, purpose, timeline and expected outcomes of assignments. Acts as a liaison to HHSC Information Technology, DAP, PI, CCL and other areas to ensure resources are aligned with RSDR and DAP department priorities.

Helps develop cost estimates and budgets for RSDR initiatives. Coordinates with Program subject matter experts to ensure accuracy of reporting tools, workflows, reporting procedures and to improve data quality.

Provides guidance and direction to other areas needing technical expertise. Mentors team members. 10%.

Knowledge Skills Abilities :

List the knowledge, skills, and abilities critical to performance in this position :

Knowledge of, and experience with, technical solutions and development for planning, reporting, analysis and implementation.

Knowledge of data quality and integrity processes.

Knowledge of the principles, practices and techniques of database and application design, development and structure.

Knowledge of relational databases.

Knowledge of data processing practices and theories.

Knowledge of System Development Life Cycle.

Knowledge of and experience with SQL and other query languages.

Knowledge of and experience with reporting and visualization tools.

Knowledge of and experience with database management tools.

Knowledge of and experience with programming and scripting languages (e.g. C++, .net, HTML, VBScript, Active Server Pages (ASP) and Java Script).

Knowledge of, or strong aptitude to learn, PI, CCL and data for other areas within HHS.

Skill in using Extract, Transform and Load tools.

Skill in researching and troubleshooting data issues and solving complex problems.

Skill in project management and process.

Ability to create and code databases.

Ability to analyze systems, procedures and problems to develop solutions.

Ability to perform detailed work accurately.

Ability to learn and apply new technology.

Ability to demonstrate strong written and verbal communication skills.

Ability to craft and maintain concise technical documentation and reports, and to make oral presentations to a variety of both technical and non -technical audiences.

Ability to work both independently and in a team environment.

Ability to be flexible and creative with data demands.

Ability to exercise independent judgment and show initiative.

Ability to plan, organize and conduct data analytic projects.

Ability to develop and interpret data charts, map, and tables.

Ability to prioritize and meet tight deadlines.

Experience extracting, organizing, quality checking and managing datasets.