Lead Data Engineer (Informatica/ETL/Snowflake)-Long Term Contract

Lead Data Engineer (Snowflake / Informatica / ETL) – Long-Term Contract

Location: Austin, TX (Hybrid)

A Texas-based organization is seeking a Lead Data Engineer to provide technical leadership for a large-scale enterprise data integration and analytics environment. This hands-on role will lead Agile development efforts while designing, developing, and supporting complex data integration, ETL, and data warehouse solutions.

The ideal candidate will bring deep expertise in Snowflake, Informatica PowerCenter/IICS, SQL development, and enterprise data engineering while serving as a technical leader for a collaborative Agile team.

Important Requirements

• Long-term contract opportunity
• Hybrid role located in Austin, Texas
• Candidates must be local to the Austin area
• Must be authorized to work in the United States without sponsorship
• W2 only
• No C2C or third-party vendors

Key Responsibilities

• Provide technical leadership for an Agile data engineering team
• Design, develop, and support enterprise data integration and analytics solutions
• Develop complex Snowflake SQL scripts, data transformations, views, and reporting structures
• Build and maintain ETL workflows using Informatica PowerCenter and/or IICS
• Acquire and integrate data from multiple internal and external sources
• Collaborate with architects, engineers, and business stakeholders on data acquisition and integration strategies
• Develop automated testing and validation processes to ensure data quality and integrity
• Participate in requirements gathering, solution design, sprint planning, and other Agile ceremonies
• Create and maintain technical specifications, documentation, process flows, and diagrams
• Analyze changing business requirements and recommend enhancements to existing data platforms

Required Qualifications

• 8+ years of experience developing ETL solutions using Informatica PowerCenter and/or IICS
• 8+ years of experience integrating data from multiple sources including Oracle, SQL Server, Excel, Access, and other structured and unstructured sources
• 8+ years of experience developing complex Snowflake SQL solutions
• Experience serving as a technical lead or senior contributor on data engineering, analytics, or data warehouse projects
• Strong analytical, troubleshooting, and problem-solving skills
• Experience with data modeling, technical documentation, and enterprise software delivery
• Proven ability to develop scalable, maintainable, and high-performing data solutions

Preferred Qualifications

• Experience working on Agile development teams
• Experience with Python development and automation
• Experience with JIRA
• Knowledge of REST and SOAP web services
• Experience with Java, JavaScript, MuleSoft, GitHub Actions, and CI/CD pipelines
• Experience using AI-enabled technologies such as Snowflake Cortex, Snowflake Intelligence, or Informatica Claire
• Experience working with healthcare, regulated, PII, or PHI data environments
• Bachelor''s degree in Computer Science, Information Systems, Business, or a related field