About the Role
Regulatory Specialty Data and Analytics (RSDA) provides analysis, data visualization, and reporting to support Health and Human Services Commission (HHSC) agencies and stakeholders. This role performs complex data collection, research, reporting, and analysis to monitor, evaluate, and increase efficiencies. Responsibilities include gathering requirements, report design and implementation, and maintaining existing reports. The analyst will develop back-end tables and logic, create programming logic, and evaluate/modify existing programs. They will review work products, interact with agency staff, and prepare documentation. The position also involves participating in system design meetings, producing technical reports, identifying alternatives and recommendations, and outlining solutions for data quality monitoring and implementation.
Responsibilities
- 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 to support complex analyses.
- Maintains security protocols for confidential data as it relates to accessing, handling, protecting, and distributing.
- Oversees the RSDA technical activities to ensure FCL reporting requirements are met.
- Monitors and ensures data quality, loading data into databases from a variety of sources, as well as formatting and automating data feeds.
- 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 the accuracy of data included in reports.
- 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, and anomalies, inconsistencies, and redundancies in the content, structure, and relationships within the 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 stats of projects and initiatives.
- Utilizes strong communication skills to explain CCL/FCL data processes and data management to negotiate information and resources needed to ensure successful initiatives.
- Determines the scope, purpose, timeline, and expected outcomes of assignments.
- Helps develop cost estimates and budgets for technical FCL initiatives.
- Coordinates with Program Subject Matter Experts (SME’s) to ensure accuracy of reporting tools, workflows, reporting procedures and to improve data quality.
- Provides guidance related to the selection and use of preferred data management and analytic tools; defines, develops, and implements data and reporting standards.
- Provides guidance and direction to other areas needing technical expertise.
- Mentors team members.
Requirements
- Graduation from an accredited four-year college or university with major coursework in data science, business analytics, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field.
- Experience in data analysis, compilation, and reporting work.
- Experience with Oracle, SQL Developer, Toad, Tableau, or other database development tools.
- Experience with data and applications related to development of Child or Foster Care program reports and visualizations is preferred.
- Candidate must also pass fingerprint and criminal background check.
- Applicants selected for hire may be required to pass background and other due diligence checks.
Skills
- Knowledge of statistics and analyzing data sets; running queries, report writing, and presenting findings; and record keeping, including security procedures for handling, protecting, and distributing confidential data.
- Understanding of and demonstrated skill in relational databases, data processing practices, and theory.
- Knowledge of or strong aptitude to learn CCL and FCL data
- Skill in researching and troubleshooting data issues and solving complex problems.
- Skill in report development and automation.
- Skill in complex analytic work, identifying trends and concerns, and recommending opportunities for improvement as well as areas of excellence.
- Skill in using software such as SQL, SQL*Plus, PL/SQL, Tableau, Excel, TOAD, Oracle, SQL Developer, Business Intelligence tools, Python, R, and/or SAS.
- Ability to work hours as needed to meet defined deadlines and support the agency’s mission-critical reporting requirements.
- Ability to present information to a variety of audiences verbally and in writing and to communicate clearly, concisely, and effectively.
- Ability to exercise independent judgment and show initiative.
- Ability to analyze, consolidate, and interpret complex data, procedures, and systems and to write or revise program code or prepare reports as required.
- Comprehension of data solutions, reporting methodologies, math, and statistical report design.
- Ability to creatively solve complex data problems, apply new technology, and perform detailed work accurately under stressful conditions while managing multiple projects and tight deadlines.
Location
- AUSTIN
Work Type
- Eligible for Telework
- Full time
Experience Level
- Senior level
Education Level
- Graduation from an accredited four-year college or university with major coursework in data science, business analytics, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field.
Salary/Compensations
- $6,377.50 - $8,581.66 Monthly
Benefits
- 100% paid employee health insurance for full-time eligible employees
- A defined benefit pension plan
- Generous time off benefits
- Numerous opportunities for career advancement
About the Company
- Join the Texas Health and Human Services Commission (HHSC) and be part of a team committed to creating a positive impact in the lives of fellow Texans.
- At HHSC, your contributions matter, and we support you at each stage of your life and work journey.
Equal Opportunity
- In compliance with the Americans with Disabilities Act (ADA), HHSC and DSHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability.
- HHSC uses E-Verify.
