Snowflake ETL Architect / Systems Analyst

Nexiva • Austin, TX

1d • $80 • Hybrid

About The Position

Texas HHSC is looking for a strong Systems Analyst / Data Engineer local to Austin, TX for a long-term in-person/hybrid opportunity. Candidates must have 8+ years of experience with Informatica Power Center/IICS, Snowflake SQL, ETL automation, data integration, and enterprise data warehouse projects. Strong experience with Tableau, Oracle, SQL Server, Agile, Python, and healthcare/PII data environments is highly preferred. Position requires onsite work 3 days a week (Tue, Wed & Fri) in Austin, TX, and only local Texas candidates within a 50-mile radius will be considered.

Requirements

• 8+ years of experience with Informatica Power Center/IICS, Snowflake SQL, ETL automation, data integration, and enterprise data warehouse projects.
• 8 years of experience developing mappings and workflows to automate ETL processes using Informatica Power Center or IICS.
• 8 years of experience acquiring and integrating data from multiple data sources/technologies using Informatica Power Center or IICS for use by a Tableau data visualization object. Data source techs should include Oracle, SQL Server, Excel, Access and Adobe PDF.
• 8 years of experience designing and developing complex Snowflake SQL scripts that are fast and efficient.
• 8 years of strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project.
• 8 years of technical writing and diagraming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.
• 8 years of experience in planning and delivering software platforms used across multiple products and organizational units.
• 8 years of proven ability to write well designed, testable, efficient code by using best software development practices.

Nice To Haves

• Strong experience with Tableau, Oracle, SQL Server, Agile, Python, and healthcare/PII data environments.
• Excellent oral and written communication skills.
• Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.
• Experience on an agile sprint team.
• Understanding of security principles and how they apply to healthcare data.
• Experience with state of the art software components for a performance metrics data visualization or business intelligence environment.
• Bachelor's degree in Computer Science, Information Systems, or Business or equivalent experience.
• Prior experience in the Healthcare Industry.
• Prior experience with an HHS agency.
• Prior experience working with PII or PHI data.
• Experience designing and developing scripts using Python.
• Experience with JIRA software.
• Functional knowledge or hands on design experience with Web Services (REST, SOAP, etc.).
• Experience designing and developing code using Java and JavaScript.
• Experience developing CI/CD pipelines with GitHub and Git Actions.
• Experience as a Mulesoft developer.
• Experience developing using AI tools such as Snowflake Cortex and Intelligence, and/or Informatica Claire.

Responsibilities

• Developing mappings and workflows to automate ETL processes using Informatica Power Center or IICS.
• Acquiring and integrating data from multiple data sources/technologies using Informatica Power Center or IICS for use by a Tableau data visualization object.
• Designing and developing complex Snowflake SQL scripts that are fast and efficient.
• Acting as a system analyst for a data analytics, performance management system, or data warehousing project.
• Planning and delivering software platforms used across multiple products and organizational units.
• Writing well designed, testable, efficient code by using best software development practices.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree