RTX
RTX
RTX is a global aerospace and defense company developing technologies for connected, sustainable flight and advanced defense systems. Its businesses include Collins Aerospace, Pratt & Whitney, and Raytheon, spanning aviation, propulsion, aerospace systems, and missile-defense solutions. The company works on initiatives such as upgrading the F135 Engine Core and emphasizes engineering innovation, corporate responsibility, sustainability, and diversity, equity, and inclusion across its workforce.

Snowflake Data Lake Support Analyst - Texas Remote

Support and improve RTX’s Snowflake Data Lake operations for aerospace and defense data. Resolve SQL and PL/SQL issues, manage Matillion ETL/ELT workflows, strengthen integrations and data quality, and optimize Snowflake performance.

Description

  • Provide second-level support for the Snowflake Data Lake environment
  • Investigate and resolve issues escalated by first-level support
  • Build, test, and optimize SQL queries, stored procedures, and PL/SQL scripts
  • Manage and improve Matillion-based ETL/ELT workflows
  • Convert business needs into technical designs and practical solutions
  • Use Jira to manage cases, track issues, and support story-pointing activities
  • Improve existing processes and develop new ones to address identified gaps
  • Create process, workflow, and troubleshooting documentation in Confluence
  • Contribute to data model design and Snowflake performance improvements
  • Support system integrations and reliable data movement between platforms
  • Provide operational support for Global Trade data ingestion, transformation, and reporting
  • Monitor data quality and preserve data integrity
  • Apply established practices for data security, performance tuning, and disaster recovery

Requirements

  • Bachelor’s degree in Computer Science, Information Technology, or a related discipline plus 5+ years of experience in data engineering, data analytics, or a related technical position; equivalent experience may substitute for the degree
  • Intermediate to advanced working knowledge of SQL, stored procedures, and PL/SQL
  • Practical experience using Matillion for ETL/ELT development
  • Basic knowledge of Git and version control practices
  • Understanding of ETL/ELT concepts and experience designing and maintaining data pipelines
  • Ability to turn business and technical requirements into actionable technical designs
  • Experience with Jira for task management, case tracking, and Agile story pointing
  • Experience documenting processes and managing knowledge, preferably with Confluence
  • Strong analytical and problem-solving capabilities
  • Ability to independently diagnose and resolve technical issues
  • U.S. citizenship is required; only U.S. citizens may access information covered by the program or contract
  • Working knowledge of Python for scripting and automation is preferred
  • Familiarity with Global Trade data and related support applications is preferred
  • Hands-on Power BI experience is preferred
  • Experience with Snowflake capabilities such as virtual warehouses, data sharing, and performance tuning is preferred
  • Understanding of data governance principles and recommended practices is preferred

Benefits

  • Compensation package
  • Healthcare benefits
  • Wellness benefits
  • Retirement benefits
  • Work/life benefits
  • Parental leave, including paternal leave
  • Flexible work schedules
  • Achievement awards
  • Educational assistance
  • Child and adult backup care
  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Life insurance
  • Short-term disability
  • Long-term disability
  • 401(k) matching
  • Flexible spending accounts
  • Employee assistance program
  • Employee Scholar Program
  • Paid time off
  • Holidays
  • Annual short-term and/or long-term incentive compensation programs may be available

Related Jobs