City
Lyndhurst

State
NJ

Job Type
Contract Full-Time

Job Description

BCTG’s direct client is looking for a Sr Data Engineer with DBT and Snowflake experience. You will responsible for using DBT to extract data from SAP and Manhattan Associates platforms, transforming, data modeling, and then building in Snowflake.

  • Assist in the design and implementation of Snowflake-based analytics solution (data lake and data warehouse)
  • This includes Data and analytics requirements definition, source data analysis and profiling, the logical and physical design of the data lake and data warehouse as well as the design of data integration and publication pipelines
  • Analyze the current analytics environment and make recommendations for appropriate data warehouse modernization and migration to the cloud
  • Develop Snowflake deployment and usage best practices

SKILLS

  • Experience designing and developing data integration solutions using ETL tools such as DBT
  • Hands-on experience in the implementation of cloud data warehouses using Snowflake.
  • Understanding of data architecture design, data modeling, and physical database design and tuning
  • Domain Knowledge with Manhattan OMNI-Channel POS and SAP strongly desired
  • Domain Knowledge with MAO, SCI, Cognos, SAP Analytics Cloud (nice to have)
  • Proficiency in SQL and database table design – able to write structured and efficient queries on large data sets
  • Experience in a role performing data warehouse and analytics solution design and development using a variety of techniques
  • Ability to understand data pipelines and modern ways of automating data using cloud-based and on-premise technologies

Apply With