Medicaid Data Management Team Lead

TX-HHSC-DSHS-DFPS•Austin, TX

About The Position

Performs complex (journey-level) data analysis, data research, database management, and application development assignments for the Medicaid Data Management (MDM) team in Medicaid CHIP Data Analytics (MCDA) in the Office of Data, Analytics, and Performance (DAP) in support of the Medicaid & CHIP Services (MCS) program in order to detect data trends and anomalies, optimize health outcomes, provide MCS and HHSC executive management with information necessary to make data-informed management decisions, enhance MCS contract management, 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 MCDA team members in the use of compiled datasets. May supervise the work of others as the Team Lead. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.

Requirements

Knowledge of: The principles, practices, and techniques of computer databases, programming, and systems design;
Knowledge of: Computer operations, systems, and procedures;
Knowledge of: Project control and cost estimating techniques;
Knowledge of: Computer database application systems;
Knowledge of: Computer programming languages;
Knowledge of: Data processing flowcharting techniques;
Knowledge of: Database structures and theories;
Knowledge of: Current database technologies;
Knowledge of: Data analysis, evaluation, and testing techniques and protocols with an emphasis on online analytics processing.
Skilled in complex problem solving and critical thinking; and in the use of a computer and applicable software.
Ability to: Explain complex technical information and provide training to individuals with a wide range of backgrounds and expertise;
Ability to: Identify and define user task needs;
Ability to: Process information logically;
Ability to: conduct short-range and long-range project planning studies;
Ability to: communicate effectively;
Ability to: and to supervise the work of others.
Graduation from an accredited four-year college or university with major coursework in computer science, computer information systems, management information systems, or a related field. Experience may be substituted for education on a year for year basis.
Experience in writing SQL or PL/SQL code.
Experience in using Excel.
Experience in using selected software such as Snowflake, Oracle SQL Developer, Cognos, Tableau, Oracle Reports, ArcGIS, Python or Business Intelligence tools.
Experience in data extraction and report layout and design.
Experience in writing executive level reports – including white papers, graphical representation of data, synthesizing the data, interpretation of the data.

Responsibilities

Consults and coordinates with MCDA, DAP and MCS 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.
Consults and coordinates with MCDA, DAP and MCS staff in order to identify business needs related to Medicaid, CHIP and reference data in various HHS and other systems and transform research and reporting requirements into DA/DAP data systems. Acquires, extracts, cleans, transforms and loads needed datasets into DA/DAP database systems. Mentors DA staff in the use of data systems.
Prepares and reviews a variety of written, oral, and graphical deliverables containing analyses of MCS and other relevant data.
May supervise and direct the work of others.

Benefits

comprehensive benefits package includes 100% paid employee health insurance for full-time eligible employees
defined benefit pension plan
generous time off benefits
numerous opportunities for career advancement

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume