Data Engineer (contract)

In this role, you will play a hands-on part in driving the architecture, design, and implementation of Snowflake for our client.

As a Jobot consultant, you will receive the following benefits:
75% of your low deductible healthcare premium will be covered by Jobot with 25% covered for your dependents
access to a 401(k)
40 hours of PTO

Qualifications:

Expertise in Snowflake concepts like setting up resource monitors, RBAC controls, virtual warehouse, query performance tuning, Zero copy clone, time travel and understand how to use these features

Expertise in Snowflake data modeling, ELT using snowpipe, implementing stored procedures and standard DWH and ETL concepts

Proven track record of successfully building data driven solutions using integration, big-data processing and database and storage technologies


Experience in architecting data pipelines and solutions for both streaming and batch integrations using tools/frameworks like Glue ETL, Lambda, Google Cloud DataFlow, Azure Data Factory, Spark, Spark Streaming, etc

Experience in Data Migration to Snowflake cloud data warehouse

Experience in developing DBT models to transform data into useful, actionable information

Expertise in designing ETL frameworks with several years of hands on experience in implementing several aspects of data pipelines including ingestion, transformation, data quality checks, monitoring, alerts, notifications etc

Understanding of enterprise data management concepts (Data Governance, Data Engineering, Data Science, Data Lake, Data Warehouse, Data Sharing, Data Applications)

Hands-on expertise with SQL and SQL analytics

Must Have Skills: DBT, Snowflake, SQL, Python

Nice to Have Skills: Airflow, AWS Data analytics services, Scala, PySpark, Great Expectations