Job ID: Tx-529HCBSDBA2E (910191112)
Business Objects Crystal ETL Developer with SQL, UML TFS and Government/healthcare experience
Location: Austin TX (HHSC)
Duration: 14+ months
Interview: In-person
Minimum Requirements:
Years Skills/Experience
6Experience developing reports in Business Objects Crystal and Web Intelligence environments.
6Experience performing Extract, Transform, Load (ETL) using ETL products.
6Experience using SQL
2Experience with UML, Use Cases, and Team Foundation Server (TFS)
DegreeGraduation from an accredited four-year college or university with major course work in computer science, computer information systems, or management information systems.
Preferences:
Years Skills/Experience
6 Excellent communication skills, written and oral, with people of all technical levels.
4 Experience working with Government agencies.
4 Knowledge of industry best practices and standards.
6 Ability to establish and maintain effective working relationships with peers, users, technical staff and management.
The Clinical Management for Behavioral Health Services (CMBHS) system is the information system utilized by Substance Use Disorder (SUD) providers, Youth empowerment Services (YES) providers, Local Behavioral Health Authorities (LBHAs) and Behavioral Health Services (BHS) program staff to plan, track, submit claims and report on services provided to clients. Additionally, CMBHS exchanges client information with other systems both internal and external to HHSC that support the delivery of services to clients.
The 83rd Legislature directed the Health and Human Services Commission (HHSC) to develop a home and community-based Services (HCBS) program for certain individuals diagnosed with a serious mental illness (SMI) whose complex needs may lead to repeated arrests, extended hospital stays or emergency department (ED) visits. As a result, the HCBS – Adult Mental health (AMH) department was created and currently administers this program. Program staff currently perform essential program functions manually, which are too labor intensive to scale and meet the increased demands of a statewide mental health program. Recently, CMBHS was modified to support Youth Empowerment Services (YES) Waiver business processes which are similar to the goals of this project. This project will leverage this already built functionality to automate the business processes and needs of both HCBS-AMH program staff and end users to provide efficient and scalable delivery of client services. This position will be responsible for database object creation, report design and SQL scripting necessary for supporting project reporting deliverables.
Other Special Requirements: All entities replying to this request must be able to attest — in writing — that they are complying with Executive Order RP 80, signed 12/03/2014. In addition, because of the nature of the information in the system that will be upgraded, all entities must sign a Data Use Agreement as a condition of employment. Face-to-face interview required.
529HCBSDBA2E_HHSC_Solicitation.docx