Systems Analyst 3/ ETL

Crox Consulting - Austin, TX

Full-time - Mid Level

Remote - Austin, TX

Merchant Wholesalers, Durable Goods

About the position

The Systems Analyst 3 will support the development of infrastructure and data acquisition automation, manage ETL administration, and facilitate agile development processes. This role requires expertise in data warehousing, ETL pipeline development, and cloud integration, primarily focusing on Informatica IICS and SQL.

Responsibilities

• Administer ETL with a focus on data warehousing and BI solutions.
• Manage Informatica IICS setup, upgrades, and maintenance.
• Use Python and shell scripting for task automation.
• Resolve production issues, optimize SQL scripts, and perform integration testing.
• Collaborate in an agile team using JIRA, manage multiple priorities.

Requirements

• 8+ years in ETL administration, Informatica IICS, CI/CD (GitHub, Jenkins), SQL, Python, and cloud ecosystems.
• Proficiency in data quality, relational databases (Oracle, SQL Server, Snowflake), Linux/Unix, and technical writing.
• Bachelor's in Computer Science or equivalent preferred.

Nice-to-haves

• Experience in healthcare, HHS data, and familiarity with security principles and Azure.