Description

You will design, build, and maintain scalable Snowflake data pipelines within an ITAR-regulated environment.

Responsibilities

• Design and implement efficient data models in Snowflake to support compliance and performance requirements.
• Develop ETL processes using IICS Informatica Integration Cloud Services to extract, transform, and load data.
• Configure and optimize Snowflake features including clustering, materialized views, and automatic scaling.
• Ensure all data processing activities adhere to ITAR regulations through security controls and encryption.
• Monitor pipeline performance, identify bottlenecks, and optimize queries for efficiency.
• Validate data rules and provide troubleshooting support for data-related issues.
• Coordinate tasks and deliverables with offshore and onsite peer teams.

Required Skills

• 15+ years of professional experience in tool and business operations.
• Extensive hands-on experience with Snowflake, including data retention, clustering, materialized views, data shares, clones, and resource monitoring.
• Strong proficiency in Core SQL and ANSI-SQL for daily code optimization.
• Proven experience developing ETL processes using IICS Informatica Integration Cloud Services.
• Deep understanding of ITAR compliance requirements and regulations.
• Experience with Python, GitHub, ControlM, and Redwood orchestration.
• Practical knowledge of Matillion ELT and Snowflake environments.
• Bachelor's degree in Computer Science, Information Technology, or a related field.

Preferred Skills

• Snowflake certifications such as SnowPro or Snow Architect.

Key Skills

Education

Bachelor's degree