Data Engineer

🔹 Systems Analyst 3 / Data Engineer(Local Austin-area)

📍 Location: Austin, TX (Hybrid – 3 Days Onsite)

🏢 Client: Texas Health and Human Services Commission (HHSC)

⏳ Duration: Long-Term Contract

🎯 Interview: In-Person Only

⚠️ Local Austin-area candidates only (within 50 miles)

🔹 Required Experience:

✅ 8 years of Informatica PowerCenter and/or Informatica IICS

✅ 8 years of ETL/Data Integration development

✅ Strong Snowflake SQL development and optimization

✅ Oracle and SQL Server experience

✅ Data Warehouse and Dimensional Modeling expertise

✅ Tableau reporting and analytics experience

✅ Strong Systems Analysis and requirements gathering skills

✅ Technical documentation, Visio, Erwin, and MS Office Suite

✅ Agile/Scrum environment experience

🔹Preferred Skills:

⭐ Python

⭐ REST/SOAP APIs

⭐ GitHub Actions / CI-CD

⭐ JIRA

⭐ MuleSoft

⭐ Java / JavaScript

⭐ Snowflake Cortex / Informatica Claire

⭐ Healthcare, PHI/PII, or HHS experience

🔹 Key Responsibilities:

• Design and develop enterprise ETL workflows using Informatica

• Build and optimize complex Snowflake SQL solutions

• Integrate data from Oracle, SQL Server, Excel, Access, PDF, and external sources

• Create source-to-target mappings and technical specifications

• Support Tableau reporting and analytics environments

• Participate in Agile ceremonies and sprint activities

• Develop validation, reconciliation, and data quality frameworks

• Collaborate with architects, business stakeholders, and engineering teams