Geospatial Data Analyst

TX-HHSC-DSHS-DFPS•Austin, TX

1d•$6,378 - $8,582•Onsite

About The Position

The Geo-Spatial Analyst reports to the Manager of the Medicaid Data Management team within the Office of Data, Analytics, and Performance (DAP). The DA V designs and conducts advanced geospatial research and analysis projects, conducts provider network analysis activities, and ensures location data are accurately geocoded and/or configured for spatial analysis. The DA V performs advanced (senior level) data analysis work related to Medicaid and CHIP service utilization, eligibility, provider and drug data, as well as data submitted from the Medicaid Managed Care Organizations (MCOs) and the External Quality Review Organization to meet contract standards, among other sources. The DA V will help guide the integration of provider data from multiple sources to optimize its value for measuring program performance. Work involves providing direction in database administration operations and planning; providing for the efficient and effective storage, retrieval, customization, and archiving of data to ensure integrated database systems; planning, developing, and implementing database policies and procedures; and maintaining and verifying data integrity. Work will involve consulting with DAP data analysts concerning data models and efficient access to the data stored in the provider data system and with HHSC staff to understand business needs. Works under moderate supervision, with considerable latitude for the use of initiative and independent judgment.

Requirements

Bachelor's degree, equivalent, or higher degree in epidemiology, statistics, public health, data science, social or natural sciences, or other discipline which requires data management and analysis skills.
Four years’ experience with data acquisition, data collection, management, analyses, visualization and presentation of health and human services-related data and/or large datasets.
Four years’ experience in writing queries and using statistical software (e.g. SAS or SPSS)
Experience with collecting, managing, and analyzing geospatial data
Employment application will illustrate effective and accurate written communication skills.

Nice To Haves

utilizing ESRI ArcGIS products and tools within analysis workflows
the principles, practices, and techniques of computer databases, programming, and systems design
computer operations, systems, and procedures
computer database application systems
computer programming languages
data science best practices, particularly with Python data science libraries ArcPy, Pandas, NumPy and FuzzyWuzzy
data processing flowcharting techniques
database structures and theories
current database technologies
data analysis, evaluation, and testing techniques and protocols with an emphasis on online analytics processing
SQL Server spatial data types, functions, and indexing
Snowflake platform
explain complex technical information and provide training to individuals with a wide range of backgrounds and expertise
identify and define user task needs, to process information logically, to conduct short-range and long-range project planning studies
communicate effectively
train others
using ArcGIS software
using SQL Server Spatial Tools
scripting and automation with Python and SQL Server
the use of a computer and applicable software
complex problem solving and critical thinking

Responsibilities

Designs and conducts advanced geospatial research and analysis projects specific to Medicaid and CHIP. Gathers data from multiple sources and performs transformation or pre-analytic processing as required. Ensures location data is accurately geocoded and/or configured for spatial analysis. Types of analyses include spatial distribution of clients, Medicaid providers and licensed practitioners, assessing provider network adequacy, evaluating contract compliance, trend and anomaly detection and program change evaluation.
Develops methodologies and determines the most effective process to address a given provider or related data request (regular or ad hoc), construct a performance measure, or monitor various trends. Compiles and manipulates data using SQL, Python, or other languages from a variety of source formats, to support complex analyses. Cleans and prepares data to produce datasets required for data visualization or software products. Designs, develops, maintains and/or supports visualizations or web apps with ArcGIS software.
Engages with a variety of people across the agency to build strong relationships and to find creative solutions to leveraging Medicaid and CHIP provider and related data to complete analytic projects. Utilizes communication skills to gather the information necessary from customers to assess and address their needs. Explains analysis results in clear and non-scientific language as necessary to ensure that customers can leverage the information in decision-making. Coordinates with program subject matter experts and leadership to both ensure accuracy in how MCDA is approaching the analysis and to inform staff of findings in a timely manner. Trains and assists DAP and other HHSC staff in querying of the data and in data extraction for analysis and reporting.
Provides suggestions regarding systematic changes that will improve the efficiency and quality of Medicaid CHIP provider and related data. Assesses data quality by identifying any missing, erroneous, incongruent, or duplicate data. Coordinates with other internal groups within the Office of Data Analytics and Performance or other areas to identify issues, address data quality, and improve reporting. Consults and provides requirements for the improvement of data collection systems and the methods used to perform data analytics.