SQL Developer/Analyst

Job/Position DescriptionThe SQL Developer/Analyst (Systems Analyst V) performs senior-level advanced functional and technical computer analysis work. Work is performed with minimal supervision and considerable latitude for the use of initiative and independent judgment and some delegated authority in carrying out the job functions and the mission of HHSC to improve existing systems. The Analyst performs highly technical duties involving the development of information systems and technology solutions.Duties include: Analysis of user requirements, planning, and development of automated processes. Participates in complex information systems projects. Provides technical guidance to business areas. Extracts data from Oracle databases using a combination of SQL and ETL (Extract, Transfer, and Load) technologies. Uses Microsoft Office or other tools to create reports for end users. Creates and/or modifies complex stored procedures using PL SQL. Creates system documentation and status reports. Keeps professional skills updated and consistent with information technology trends. Coordinates activities with customers and other internal and external Information Technology (IT) functional areas. Provides 24/7 on call support in response to job failures and other technical issues on a rotating basis and may be called as needed for SME (subject matter expert) issues. The Analyst works as required with all IT Technical Teams, customers, other IT functional areas, and other state agencies and federal oversight entities. This position is for U.S. Citizens or residents only.Essential Job FunctionsAttends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.Monitors, maintains, and provides support for Financials Data Warehouse (FDW) processes, systems and interfaces - including but not limited to Admin Apps Provider Payment Systems, CAPPS Financial imports and interfaces, custom Financial and HR tables and views. Supports MIMS (Materials and Inventory Management System) interfaces and provides backup support for Lawson application. Assists in setting up and monitoring batch schedules for aforementioned processes, systems and interfaces. Writes, debugs, and maintains highly complex PL SQL Stored Procedures and shell scripts. Creates, debugs, and maintains Informatica Powermart ETLand146;s (Extract, Transform, Load). (40%)Produces technical analysis and solutions for FDW systems that ensure consistency with HHSC IT standards, State of Texas ERP standards, and existing HHSC strategies and projects in accordance with established standards, policies and procedures. Participates in application design sessions. Develops technical analyses and produces expected deliverables by established due dates. Coordinates technical solutions that meet immediate needs and provide for HHSC agencyand146;s long-term goals. (20%)Produces documentation that ensures consistency with HHSC IT standards and State of Texas ERP standards. Develops work plans and coordinates with Health and Human Services (HHSC) enterprise organization to produce technical solutions and work products in accordance with state statutes and legislative mandates. Develops technical documentation for internal IT staff or external customers. Coordinates development and/or review of functional documentation for customers as it relates to a technical solution developed. (20%)Undertakes knowledge transfer to colleagues of Financials Data Warehouse technical analysis/ development skills. https://jobshrportal.hhsc.state.tx.us/ENG/CareerPortal/job_profile.cfm?szOrderID613908 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.