L3 Application Support Engineer (Locals Only - USC & GC)
Job Description
We are seeking an experienced Application Support Engineer (L3) to join our Run Support team. This role provides advanced technical expertise, incident resolution, and long-term application stability improvements. The L3 engineer acts as the final escalation point for critical issues, leads root cause analysis (RCA), and partners with Product and Development teams to ensure that defects (bugs) and feature requests (stories) are properly documented, prioritized, and delivered through Azure DevOps (ADO). This is a Run Support position that must also be able to troubleshoot data-platform workflows independently.
Key Responsibilities
Core Technical Skills (required):
• Snowflake: querying, monitoring query history, task scheduling, data validation
• SQL: strong ability to write, debug, and optimize queries
• Airflow: DAG dependencies, task retries, scheduling, manual triggers
• dbt: running models, understanding project structure, debugging transformation errors
• Fivetran: connector monitoring, log review, manual refreshes
• Python: read/modify scripts used in ETL jobs or Lambda functions
• AWS Lambda: review logs and execution results for event-based jobs
• ETL/ELT: strong understanding of ingestion and transformation flows
Representative support scenarios:
• Investigating Snowflake table/view refresh failures and reviewing logs
• Checking and re-running Airflow DAGs or dbt models
• Validating ingestion via Fivetran and confirming source loads with SQL
• Reviewing ETL/ELT job dependencies and manually triggering failed runs
• Identifying/resolving timing or sequencing issues in scheduled jobs
Additional Information
All your information will be kept confidential according to EEO guidelines.