Systems Analyst 3 – Data Integration ETL Analytics 26-06253

Systems Analyst 3 Data Integration / ETL / Analytics

Location - Austin TX (Hybrid: 3 Days Onsite Tues/Wed/Fri)
Duration: 12 Months

Position Overview

The client is seeking an experienced Systems Analyst / Data Engineering professional to support the continued development of a Data Integration Hub within the Performance Management & Analytics System (PMAS) environment.

This role focuses heavily on:

• ETL development using Informatica Power Center / IICS
• Advanced Snowflake SQL
• Data integration and dimensional modeling
• Agile-based data engineering initiatives
• Healthcare analytics and performance management systems

The consultant will collaborate closely with architects data engineers and business stakeholders to design build test and support scalable analytics solutions.

Core Responsibilities

• Build and maintain ETL mappings/workflows using Informatica Power Center or IICS
• Develop advanced Snowflake SQL scripts views and materialized views
• Integrate data from:
  • Oracle
  • SQL Server
  • Excel
  • Access
  • Adobe PDF
• Support data warehouse and dimensional model development
• Participate in Agile sprint ceremonies
• Create epics user stories and technical documentation
• Perform integration load and stress testing
• Develop automation for validation and verification
• Collaborate on data acquisition and architecture strategies
• Support deployments and ongoing operational enhancements
• Produce mockups and technical specifications

Required Skills & Experience

Must-Have (8 Years)

• Informatica Power Center or IICS ETL development
• Data integration from multiple source systems
• Snowflake SQL development
• Systems analysis for analytics/data warehousing projects
• Technical documentation and diagramming (Visio Erwin)
• Software platform delivery across enterprise systems
• Writing efficient testable code

Preferred Skills

Strongly Preferred

• Agile/Scrum experience
• Healthcare/HHS experience
• Experience with PHI/PII data
• Python scripting
• JIRA
• REST/SOAP web services
• Java / JavaScript
• GitHub Actions / CI-CD pipelines
• MuleSoft
• AI tools such as:
  • Snowflake Cortex
  • Informatica Claire

For more details reach at