Note: The job is a remote job and is open to candidates in USA. RTX is an aerospace and defense company with an Enterprise Services team. The Snowflake Data Lake Support Technical Analyst supports and maintains the Snowflake Data Lake as a second-level operations resource, troubleshooting escalated issues and managing data workflows. The role also focuses on SQL development, ETL/ELT pipelines, data integration, data quality, documentation, and Snowflake performance optimization.
Responsibilities
- 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
Skills
- U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract
- 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
- 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
Benefits
- Healthcare benefits, including medical, dental, and vision coverage
- Life insurance
- Short-term disability coverage
- Long-term disability coverage
- 401(k) match
- Flexible spending accounts
- Flexible work schedules
- Employee assistance program
- Employee Scholar Program
- Parental (including paternal) leave
- Paid time off
- Holidays
- Achievement awards
- Educational assistance
- Child/adult backup care
- Career development and recognition programs
- Remote work, primarily offsite from home
- 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.
Company Overview