Remote Snowflake Data Lake Support Specialist

RTX Corporate; Austin (TX); Remote; USD 87,000 - 165,000; Full time

Benefits offered by this job

Parental leave

Flexible work schedules

Educational assistance

401(k) match

Job summary

RTX Corporate is seeking a Snowflake Data Lake Support Specialist to maintain and optimize the Snowflake Data Lake in a remote US-based role. You will provide second-level data lake support, develop and tune SQL/PLSQL, and manage ETL/ELT processes with Matillion.

You will translate business needs into technical designs, track work in Jira, and document procedures in Confluence while ensuring data quality, security, and robust data integration across systems.

Qualifications

• Bachelor’s degree required or equivalent experience.
• Strong SQL/PLSQL with ETL/ELT experience.
• Hands-on Matillion experience for ETL/ELT processes.
• Experience with Jira for Agile workflows and case management.
• Familiarity with Confluence for documentation.
• Solid problem-solving and communication skills.

Responsibilities

• Provide second-level support for the Snowflake Data Lake environment.
• Develop, test, and optimize SQL queries and PL/SQL scripts.
• Manage ETL/ELT workflows using Matillion.
• Translate business requirements into technical designs.
• Use Jira to track cases and plan work with story points.
• Maintain documentation in Confluence and ensure knowledge sharing.
• Collaborate to optimize Snowflake performance and data models.
• Support data integration and Global Trade data ingestion.
• Ensure data quality and security best practices.

Skills

SQL

PL/SQL

Matillion

Jira

Confluence

Git basics

ETL/ELT design

Data modeling

Snowflake knowledge

Education

Bachelor’s degree in Computer Science, Information Technology, or a related field

Tools

Matillion

Confluence

GitHub Actions

Snowflake

Git

Power BI

Job description

RTX Corporate is seeking a Snowflake Data Lake Support Specialist to maintain and optimize the Snowflake Data Lake in a remote US-based role. You will provide second-level data lake support, develop and tune SQL/PLSQL, and manage ETL/ELT processes with Matillion.

You will translate business needs into technical designs, track work in Jira, and document procedures in Confluence while ensuring data quality, security, and robust data integration across systems.