Snowflake Application Support Engineer (L3) - Charlotte, NC or Remote (EST) - 6 Months CTH - W2

Overview

Remote
$60 - $70
Contract - W2
Contract - Independent
Contract - 6 Month(s)

Skills

Snowflake
Data Engineer
SQL
DBT
Fivetran
Airflow
Analytics Engineer
T-SQL
Snowflake SQL
Python
Root cause Analysis

Job Details

Snowflake Application Support Engineer (L3)

Charlotte, NC or Remote (EST)

6 Months Contract with Option To Hire

Need a Snowflake Data Engineer who worked as a support engineer level 3 and worked on FiveTran, DBT, Airflow and has good SQL query skills on SQL Server and Snowflake.

Rewriting SSIS Process to replicate SQL Server DB transactional data into Axiom

L3 guy will look into Axiom or Snowflake based issues

The L3 person is a Hybrid of AE & DE

Analytics engineers (AE) - ELT, DBT, Basic SQL, T-SQL, Snowflake SQL

Data Engineer (DE) - Data Ingestion, SQL, Python, Airflow

Some of the Current Issues: Night time job runs, Missing data, Data not refreshing correctly, Table is blank

- RCA (Root Cause Analysis), Look at Source data, Troubleshooting

Ideal Rock Star candidate:

1. Automation, Next steps within Fivetran, Connector monitoring, DBT Core vs DBT Cloud, Architectural

2. Data Volume increases, 6 hour refresh time - how to cut it down to 3 hour refresh

3. Look into why did the issue happen, how to prevent from happening again

Technical Must Haves:

1. Application Support role Experience doing support, RCA (Root Cause Analysis), Problem solving, why tables are empty, follow through incident, look at logs, errors, what can you make sure the issue does not happen again

2. Snowflake, DBT, Fivetran, Airflow - DBT Transformations/Refresh, Fivetran connectors, Monitoring

3. SQL queries. Will do a video interview with SQL questions and record the response for managers review

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.