Texas Health and Human Services ยท 4 months ago
CFO Data Alignment Systems Analyst VI
Austin, TX
Contract
Hybrid
Mid, Senior Level
$7,015/mo - $11,864/mo
3+ years expTexas Health and Human Services Commission (HHSC) is committed to creating a positive impact in the lives of fellow Texans. The CFO Data Alignment Systems Analyst VI will perform complex computer systems analysis work, identify technical requirements, develop and maintain software applications, and improve business productivity.
Health Care
Responsibilities
Responsible for coding, testing, and supporting highly complex ETL data warehouse applications to meet program area needs. Rigorous testing includes coordination with the technical support staff for integration testing to ensure quality products before distribution. Product support includes analyzing production problems as described by the customer, systems analyst, and/or program area support staff, problem solving to keep the program area applications operational and ongoing maintenance and enhancements to data warehouse. (20%)
Participates in system development activities (i.e.: analysis, design, develop, implement) to meet business needs if appropriate products or services cannot be more cost effectively purchased or identified. Analyzes business process requirements and prepares detailed structured data flow analysis diagrams, verification of procedures, and database entity relationship diagrams to satisfy new software demands. Develops and maintains functional and technical specifications via the preparation of detailed flowcharts, tables, reports and other descriptive materials necessary for coding, testing and documenting complex automated systems. Documents all system development activities in accordance with Agency Software Development Lifecycle and Project Management guidelines. Schedules work and assists supervisory personnel in assignment of tasks. (20%)
Evaluates existing and proposed computer applications to verify business requirements, system requirements, and equipment configurations are considered. Analyzes complex business processes, equipment, and techniques for applicability, reliability, efficiency, speed, cost, flexibility, and meeting customer needs. These duties include coordinating applications interfaces with other areas within the Department as well as between State Agencies with the coordination of management. (20%)
Monitor scheduled data loads and ETL jobs
Troubleshoot failed or slow data loads
Coordinate with ETL developers for issue resolution
Coordinate with ETL developers for ETL improvements/optimization
Monitor warehouse performance and query execution
Identify and resolve bottlenecks (e.g., long-running queries)
Recommend and implement warehouse scaling or clustering
Manage storage usage and retention policies
Archive or purge outdated/unnecessary data
Apply best practices for cost control
Respond to incidents, alerts, and service requests
Document and escalate issues as needed
Maintain knowledge base articles for common issues
Monitor daily/weekly/monthly ETL job runs
Investigate and resolve job failures or performance issues
Restart failed jobs and communicate status to stakeholders
Set up and maintain connections to source/target systems (databases, cloud apps, etc.)
Troubleshoot connectivity issues
Deploy new or updated mappings, workflows, and tasks
Validate and test changes in lower environments before promoting to production
Respond to tickets and service requests
Provide root cause analysis for recurring issues
Document solutions and update runbooks
Maintain up-to-date documentation for processes, runbooks, and troubleshooting guides
Provide regular status reports on incidents, job status, and platform health
Qualification
Required
Graduation from a college or university with major course work in Math, Science, or Computer Science related preferred
Must have at least three years of experience in systems analysis and design work or developing software
Proven experience as a Data Center Migration Consultant or in a similar role, with expertise in data center infrastructure and migration processes
Strong knowledge of on-premises data storage systems, virtualization, and networking technologies
Familiarity with data center architectures, data replication, and disaster recovery strategies
Excellent problem-solving and analytical skills, with the ability to develop effective migration plans and solutions
Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams
Ability to work independently and efficiently manage time and tasks to meet project deadlines
Experience with business intelligence and big data solutions
Experience in developing, deploying, and managing applications and data storage
Strong knowledge of data architecture principles and best practices
Proficiency in SQL and other database technologies
Strong communication skills, with the ability to explain complex technical concepts to a non-technical audience
Develop and maintain enterprise data models, data warehouses, and data lakes to support analytics and reporting
Experience with ETL tools, data integration platforms, and APIs
Experience in architecting and designing ETL pipelines using Informatica tools
Preferred
Experience With Snowflake
Experience with Azure
Benefits
100% paid employee health insurance for full-time eligible employees
Defined benefit pension plan
Generous time off benefits
Numerous opportunities for career advancement
Company
Texas Health and Human Services
Texas Health and Human Services is an agency that focuses on improving health, safety and well-being.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Dr. Napoleon Broughton
Chief Executive Officer: Life Enhancement Solutions
John F. Palermo
CTO Strategic Analyst VI
Recent News
Help Net Security
2025-04-09
Fort Worth Star-Telegram
2024-04-01
Company data provided by crunchbase