Remote Snowflake Data Lake Support Pro

Pratt & Whitney; United States; Remote; USD 87,000 - 165,000; Full time

Benefits offered by this job

Parental leave

Flexible work schedules

Educational assistance

Child/adult backup care

Career development

Job summary

RTX seeks a Snowflake Data Lake Support Specialist to join our team and help maintain the Snowflake Data Lake remotely. You will provide second-level support, develop and optimize SQL queries, and manage ETL/ELT workflows using Matillion to ensure robust, scalable data pipelines.

You will translate business requirements into technical designs, track work with Jira, and document processes in Confluence while collaborating with teammates to strengthen data quality and Snowflake performance.

Qualifications

• Bachelor's degree or equivalent with 5+ years in data engineering/analytics.
• Strong SQL/PLSQL with Matillion ETL/ELT experience.
• Familiarity with Git and version control basics.
• Ability to translate requirements into technical designs and document in Confluence.

Responsibilities

• Provide second-level Snowflake Data Lake support and triage escalations.
• Develop, test, and optimize SQL queries and PL/SQL scripts.
• Manage ETL/ELT workflows using Matillion for robust pipelines.
• Design data models and collaborate on Snowflake performance improvements.
• Use Jira for case management and story pointing; document workflows in Confluence.
• Ensure data quality, security, and disaster recovery practices.

Skills

SQL

PL/SQL

ETL/ELT

Matillion

Git

GitHub Actions

Jira

Confluence

Data modeling

Problem solving

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

Power BI

GitHub Actions

Matillion

Job description

RTX seeks a Snowflake Data Lake Support Specialist to join our team and help maintain the Snowflake Data Lake remotely. You will provide second-level support, develop and optimize SQL queries, and manage ETL/ELT workflows using Matillion to ensure robust, scalable data pipelines.

You will translate business requirements into technical designs, track work with Jira, and document processes in Confluence while collaborating with teammates to strengthen data quality and Snowflake performance.