Snowflake Data Lake Support Technical Analyst

RTX; United States; Remote; USD 87,000 - 165,000; Full time

Benefits offered by this job

Compensation & benefits

Healthcare & retirement

Career development

Parental leave

Flexible schedules

Achievement awards

Educational assistance

Backup care

Job summary

RTX is seeking a Snowflake Data Lake Support Specialist to provide second-level support, triage escalations, and maintain data lake operations. This role focuses on SQL/PLSQL, ETL/ELT workflows with Matillion, and cross-team collaboration.

You will optimize Snowflake performance, design data models, ensure data quality, and document processes in Confluence while using Jira for tracking. This remote US-based role offers growth opportunities.

Qualifications

• Bachelor’s degree in CS/IT or related field; 5+ years of relevant experience.
• Strong SQL, PL/SQL, and ETL/ELT expertise.
• Hands-on with Matillion for ETL/ELT workflows.
• Experience with Git and version control.
• Familiar with Jira for task tracking and Confluence for docs.
• Knowledge of Snowflake performance tuning and data modelling.

Responsibilities

• Provide second-level support for the Snowflake Data Lake environment.
• Develop, test, and optimize SQL queries and PL/SQL scripts.
• Manage and enhance ETL/ELT workflows using Matillion.
• Translate business requirements into technical designs.
• Collaborate using Jira for project planning and tracking.
• Maintain documentation in Confluence and ensure data quality.

Skills

SQL

PL/SQL

ETL/ELT

Matillion

Git basics

Jira

Confluence

Python

Power BI

Snowflake

Education

Bachelor’s degree in Computer Science/Information Technology

Tools

Snowflake

Matillion

Job description

Snowflake Data Lake Support Technical Analyst

RemoteU.S. Citizen, U.S. Person, or Immigration Status Requirements:

U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract.Security Clearance Type:

None/Not RequiredSecurity Clearance Status:

Not RequiredAt RTX, the world's largest aerospace and defense company, 185,000 great minds are united by purpose and inspired to make a difference solving the world’s most complex problems. With our three market leading businesses, world-class operations and investments in research and development, we offer capabilities and opportunity no one else can. Together, we push the boundaries of known science and find new ways to connect and protect our world. Join us and help shape the future of aerospace and defense.

The following position is to join our RTX Enterprise Services team:

We are seeking a motivated and skilled professional to join our team as a Snowflake Data Lake Support Specialist. In this role, you will play a critical part in supporting and maintaining our Snowflake Data Lake. This position requires a self-starter with a solid technical background in SQL, ETL/ELT processes, and related tools, as well as a proactive approach to problem-solving and collaboration. You will act as the second level line of support for data lake operations to triage and resolve escalated issues as needed.

This role provides an excellent opportunity to work with cutting-edge data technologies, contribute to critical data initiatives, and grow your expertise in Snowflake, ETL/ELT, and related tools. If you are passionate about data and excited to be part of a collaborative, innovative team, we encourage you to apply.

What You Will Do:

Provide second-level support for the Snowflake Data Lake environment, troubleshooting issues escalated by First-level support as necessary.

Develop, test, and optimize SQL queries, stored procedures, and PL/SQL scripts to ensure efficient data processing.

Manage and enhance ETL/ELT workflows using Matillion, ensuring data pipelines are robust, scalable, and reliable.

Translate business requirements into clear technical designs and solutions that align with organizational goals.

Use Jira for case management, tracking issues, and applying story pointing for project planning and execution.

Maintain and enhance existing processes, or create new ones where gaps exist, ensuring documentation is comprehensive and stored in Confluence.

Collaborate with team members to design and implement data models and optimize Snowflake performance.

Support data integration efforts, ensuring seamless data flow across systems.

Provide operational support for Global Trade data, including data ingestion, transformation, and reporting.

Ensure proper documentation of processes, workflows, and troubleshooting guides for efficient knowledge sharing.

Monitor and maintain data quality and integrity within the data lake environment.

Adhere to best practices for data security, performance tuning, and disaster recovery.

Qualifications You Must Have

Bachelor’s degree in Computer Science, Information Technology, or a related field, with 5+ years of experience in data engineering, data analytics, or a related technical role or equivalent experience in lieu of a degree.

Intermediate to strong knowledge of SQL, stored procedures, and PL/SQL with hands‑on experience with Matillion for ETL/ELT processes.

Basic understanding of Git and version control principles (use of GitHub Actions is a plus but not critical).

Solid understanding of ETL/ELT principles, with experience designing and maintaining data pipelines.

Ability to translate business and technical requirements into actionable technical designs with experience using Jira for managing tasks, tracking cases, and applying story pointing for Agile workflows and experience with process documentation and knowledge management tools, preferably Confluence.

Strong analytical and problem-solving skills, with the ability to troubleshoot and resolve technical issues independently.

Qualifications We Prefer

Working knowledge of Python for scripting and automation purposes.

Familiarity with handling Global Trade data and supporting applications.

Hands on experience with Power BI.

Experience with Snowflake-specific features such as virtual warehouses, data sharing, and performance tuning.

Understanding of data governance principles and best practices.

What We Offer

Whether you’re just starting out on your career journey or are an experienced professional, we offer a robust total rewards package with compensation; healthcare, wellness, retirement and work/life benefits; career development and recognition programs. Some of the benefits we offer include parental (including paternal) leave, flexible work schedules, achievement awards, educational assistance and child/adult backup care.

• compensation
• healthcare, wellness, retirement and work/life benefits
• career development and recognition programs
• parental (including paternal) leave
• flexible work schedules
• achievement awards
• educational assistance
• child/adult backup care

Work Location: Remote

Remote: Employees who are working in Remote roles will work primarily offsite (from home). If you live within a reasonable commute of an RTX site with other colleagues you interact with, your manager will discuss whether there is a degree of onsite presence associated with this role.

As part of our commitment to maintaining a secure hiring process, candidates may be asked to attend select steps of the interview process in-person at one of our office locations, regardless of whether the role is designated as on-site, hybrid or remote.

The salary range for this role is 86,800 USD - 165,200 USD. The salary range provided is a good faith estimate representative of all experience levels. RTX considers several factors when extending an offer, including but not limited to, the role, function and associated responsibilities, a candidate’s work experience, location, education/training, and key skills.Hired applicants may be eligible for benefits, including but not limited to, medical, dental, vision, life insurance, short-term disability, long-term disability, 401(k) match, flexible spending accounts, flexible work schedules, employee assistance program, Employee Scholar Program, parental leave, paid time off, and holidays. Specific benefits are dependent upon the specific business unit as well as whether or not the position is covered by a collective-bargaining agreement.Hired applicants may be eligible for annual short-term and/or long-term incentive compensation programs depending on the level of the position and whether or not it is covered by a collective-bargaining agreement. Payments under these annual programs are not guaranteed and are dependent upon a variety of factors including, but not limited to, individual performance, business unit performance, and/or the company’s performance.This role is a U.S.-based role. If the successful candidate resides in a U.S. territory, the appropriate pay structure and benefits will apply.RTX anticipates the application window closing approximately 40 days from the date the notice was posted. However, factors such as candidate flow and business necessity may require RTX to shorten or extend the application window.RTX is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any other applicable state or federal protected class. RTX provides affirmative action in employment for qualified Individuals with a Disability and Protected Veterans in compliance with Section 503 of the Rehabilitation Act and the Vietnam Era Veterans’ Readjustment Assistance Act.

Privacy Policy and Terms:

Click on this link to read the Policy and Terms

Meet the team

RTX

RTX is the world's largest aerospace and defense company with 185,000 employees united by purpose to solve the world's most complex problems. The company operates three market-leading businesses including Collins Aerospace and Pratt & Whitney, which design and manufacture advanced aerospace systems, aircraft engines, and auxiliary power systems. RTX invests heavily in research and development to offer capabilities in intelligent solutions, avionics, chemical compliance, and military engine sustainment. The company pushes the boundaries of known science to connect and protect the world through world-class operations and technologically advanced defense solutions.