Systems Analyst with Business Intelligence ETL exp for HHSC, Austin, Tx

Pedigo Staffing Services; Austin (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

Texas Health and Human Services Commission seeks a highly experienced Systems Analyst 3 for cloud data migration projects. The role emphasizes AWS DMS, Oracle to AWS migrations, and expertise in ETL/ELT, Python scripting, and cloud infrastructure design (VPCs, subnets, security groups).

Located in Austin, TX, with hybrid onsite/remote work and strict local-candidate requirements. Ideal candidates will have a strong track record in multi-year IT projects, data migration planning, and secure,

Qualifications

• 8 years, Required - Experience in IT, supporting the design, development, deployment, or delivery of technology solutions.
• 8 years, Required - Experience using AWS Database Migration Service (DMS) to migrate data from Oracle to AWS.
• 8 years, Required - Experience with batch and real-time data ingestion, including full loads, CDC, and streaming architectures.
• 8 years, Required - Experience with AWS cloud services, specifically designing and implementing infrastructure and networking (VPC, subnets, security groups, routing).
• 8 years, Required - Experience with core AWS services (EC2, RDS, S3, IAM, Lambda) and infrastructure-as-code tools (CloudFormation or Terraform).
• 8 years, Required - Experience with ETL/ELT processes and data integration methodologies in cloud migration projects.
• 8 years, Required - Experience with scripting and automation using Python, Bash, or PowerShell.
• 8 years, Required - Experience configuring and managing cloud network security, including VPNs, Direct Connect, and security groups.
• 8 years, Required - Experience with monitoring and logging tools (e.g., AWS CloudWatch, CloudTrail).
• 8 years, Required - Experience developing data migration and cutover plans, including rollback strategies and minimizing downtime.
• 8 years, Required - Excellent communication skills, both verbal and written, including documenting technical designs and migration runbooks.
• 8 years, Required - Experience with hybrid cloud/on-premises connectivity and legacy system modernization.
• 4 years, Preferred - AWS certification(s) such as AWS Certified Solutions Architect or AWS Certified Database – Specialty.
• 1 years, Preferred - Experience working in public sector or state government environments.

Responsibilities

• Analyze requirements and automate processing to improve current computer systems.
• Document technical designs and migration runbooks for data moves.
• Develop data migration strategies, cutover plans, and rollback procedures.

Skills

AWS DMS

Batch processing

CDC

Streaming

AWS cloud

EC2

RDS

S3

IAM

Lambda

Infrastructure as Code

CloudFormation

Terraform

ETL/ELT

Python

Bash

PowerShell

VPNs

Direct Connect

CloudWatch

CloudTrail

Tools

CloudWatch

CloudTrail

Terraform

CloudFormation

DMS

Job description

Systems Analyst with Business Intelligence ETL exp for HHSC, Austin, Tx

• Austin, TX

Title/Level: Systems Analyst 3

Agency: Texas Health and Human Services Commission

Location: 4601 W Gudalupe St Austin, TX 78751

Solicitation Reference Number: 529701756

Category: Applications/Software Development

Job Details:

Texas Health and Human Services Commission requires the services of 1 Systems Analyst 3, hereafter referred to as Candidate(s), who meets the general qualifications ofSystems Analyst 3, Applications/Software Developmentand the specifications outlined in this document for theTexas Health and Human Services Commission.

Required/Preferred:

• 8 years, Required - Experience in IT, supporting the design, development, deployment, or delivery of technology solutions.
• 8 years, Required - Experience using AWS Database Migration Service (DMS) to migrate data from Oracle to AWS.
• 8 years, Required - Experience with batch and real-time data ingestion, including full loads, Change Data Capture (CDC), and streaming architectures.
• 8 years, Required - Experience with AWS cloud services, specifically designing and implementing infrastructure and networking (VPC, subnets, security groups, routing).
• 8 years, Required - Experience with core AWS services (EC2, RDS, S3, IAM, Lambda) and infrastructure-as-code tools (CloudFormation or Terraform).
• 8 years, Required - Experience with ETL/ELT processes and data integration methodologies in cloud migration projects.
• 8 years, Required - Experience with scripting and automation using Python, Bash, or PowerShell.
• 8 years, Required - Experience configuring and managing cloud network security, including VPNs, Direct Connect, and security groups.
• 8 years, Required - Experience with monitoring and logging tools (e.g., AWS CloudWatch, CloudTrail).
• 8 years, Required - Experience developing data migration and cutover plans, including rollback strategies and minimizing downtime.
• 8 years, Required - Excellent communication skills, both verbal and written, including documenting technical designs and migration runbooks.
• 8 years, Required - Experience with hybrid cloud/on-premises connectivity and legacy system modernization.
• 4 years, Preferred - AWS certification(s) such as AWS Certified Solutions Architect or AWS Certified Database – Specialty.
• 1 years, Preferred - Experience working in public sector or state government environments.

All work products resulting from the project shall be considered "works made for hire" and are the property of the Texas Health and Human Services Commission and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law. Texas Health and Human Services Commission will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).

Understands business objectives and problems, identifies alternative solutions, performs studies and cost/benefit analysis of alternatives. Analyzes user requirements, procedures, and problems to automate processing or to improve existing computer system: Confers with personnel of organizational units involved to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be; summarized, and formats for reports. Writes detailed description of user needs, program functions, and steps required to develop or modify computer program. Reviews computer system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within existing system.

Seeking a Cloud Data Migration Engineer with hands-on experience migrating Oracle workloads to AWS using AWS DMS, supporting full-load, CDC, and real-time streaming data migration architectures. The ideal candidate will have strong expertise in AWS infrastructure and networking (VPCs, subnets, security groups, VPNs, Direct Connect), cloud-native services (EC2, RDS, S3, IAM, Lambda), and Infrastructure as Code using Terraform or CloudFormation. Experience with ETL/ELT processes, migration planning, cutover and rollback strategies, automation using Python/Bash/PowerShell, and monitoring through CloudWatch and CloudTrail is required. Strong communication skills and experience modernizing legacy on-premises systems in hybrid cloud environments are highly desirable.

Services shall be provided during normal business hours unless otherwise coordinated through the Agency. Normal business hours are Monday through Friday from 8:00 a.m. through 5:00 p.m., excluding Texas state holidays when the agency is closed.

The primary work location will be 4601 W. Guadalupe, Austin, Texas 78751.

Position will be 3 days remote with 2 days (Mon & Thurs) required to be onsite at the location listed above. Subject to change per the hiring team

Program will only allow candidates who are LOCAL TO THE AUSTIN AREA ONLY (Within 50-mile radius).

The worker may be required to work remotely at HHSC discretion, up to 100 percent of the time.

The worker may be required to work outside the normal business hours on weekends, evenings and holidays, as requested. Payment for work over 40 hours will be at the hourly rate quoted and must be coordinated and pre-approved through the Agency.