SQL Developer/Analyst

$63,000 - $120,000/Yr

Texas Health and Human Services - Austin, TX

Full-time - Mid Level

Onsite - Austin, TX

Social Assistance

About the position

The SQL Developer/Analyst (Systems Analyst V) is responsible for performing advanced functional and technical computer analysis work with minimal supervision. This role involves developing information systems and technology solutions to improve existing systems within the Health and Human Services Commission (HHSC). The Analyst will analyze user requirements, develop automated processes, and provide technical guidance while participating in complex information systems projects.

Responsibilities

• Perform advanced functional and technical computer analysis work with minimal supervision.
• Analyze user requirements and develop automated processes.
• Participate in complex information systems projects.
• Provide technical guidance to business areas.
• Extract data from Oracle databases using SQL and ETL technologies.
• Create reports for end users using Microsoft Office or other tools.
• Create and modify complex stored procedures using PL SQL.
• Create system documentation and status reports.
• Coordinate activities with customers and other IT functional areas.
• Provide 24/7 on-call support for job failures and technical issues.

Requirements

• Experience in SQL and PL SQL development.
• Proficiency in ETL technologies, specifically Informatica Powermart.
• Strong analytical and problem-solving skills.
• Ability to work independently and use initiative in job functions.
• Experience in technical documentation and reporting.

Nice-to-haves

• Familiarity with Financials Data Warehouse (FDW) processes and systems.
• Experience with MIMS (Materials and Inventory Management System).
• Knowledge of state statutes and legislative mandates related to IT.

Benefits

• Health insurance coverage.
• Retirement savings plan (401k).
• Paid holidays and vacation time.