Job/Position Description * This position can telework 100% from anywhere in Texas consistent with HHS telework policies. Candidates local to Austin preferred.* The Systems Analyst reports to Application Manager within Health and Specialty Care Systems (HSCS) unit of Information Technology (IT) department for Health and Human Service Commissions (HHSC). This position applies their expertise and technical skills in creating, developing, and maintaining database structures, database tuning, stored procedures, SQL Server packages and support for existing and new Electronic Health Record (EHR) applications. This position is within the software development and support team and requires development of application business logic with stored procedures and support applications. The analyst will also perform analytical, and database administrations work for information systems and technologies to support Electronic Health Record (EHR) systems and applications for the State Hospitals (SHand#146;s) and State Supported Living Centers (SSLCs). The analyst will support multiple third-party applications (Cernerand#146;s Millennium, Netsmartand#146;s myAvatar, in house developed MATS, and IRIS DSS, among others). Work involves gathering and analyzing requirements, design and implementation, and on-going maintenance of existing systems and processes. Analyst will work with other HSCS application support staff as well as other HHSC teams to develop and support information systems. The analyst may interact with staff from vendors, other agencies and outside entities as required to provide continued support, obtain required work products, or for consultation. Work is performed in an Agile environment and creativity is encouraged.Essential Job FunctionsParticipates in database design sessions for new initiatives and for enhancements to ensure requirements are met. Writes, Tests and Tunes complex database stored procedures. Create database tables, indexes, and other database objects on SQL Server and SSIS (25%)Extracts data from Cerner Millennium or myAvatar application databases using existing tools. Builds data mappings, tasks and workflows using Informatica Tools to load data to the data warehouse databases. Documents, designs, validates, and implements reporting methodologies for multiple areas of specialization using selected HHSC methodology and tools. (25%)Investigates and identifies corrective solutions to production problems / issues. Consults with IT teams on software/hardware justifications and purchases. Supports in troubleshooting and solving complex problems related to EHR system software and hardware incidents and problem calls, and in the processing of service requests and tasks. (20%)May provide on-call application support as part of the support team based on team rosters. Provides technical expertise to aid in decision making and problem resolution for EHR applications. (10%).Performs quality assurance tasks to ensure accuracy of fixes provided to resolve issues. Documents processes and procedures for technical and non-technical users. (10%)Performs other duties as assigned and required to maintain unit operations. Promotes and demonstrates appropriate respect for cultural diversity among coworkers and all work-related contacts (10%).Registrations, Licensure Requirements or CertificationsKnowledge Skills AbilitiesInitial Screening CriteriaRequired:and#149;Bachelorand#146;s degree or higher in a technology related field is preferred. May substitute direct work experience on a year-f profile.cfm?szOrderID=608298 Copy the URL in the preceding sentence to an Internet Explorer browser to apply to the job directly through the Texas Health and Human Services Career Portal.
database-design Agile database-tuning Analytical skills Creativity Quality Assurance (QA) Information Systems Systems Analyst Microsoft SQL Server Application Support Analyst Software Developer stored-procedures