Careers

Snowflake Data Engineer

  • K-tek Resourcing Llc
  • Canada Blvd, Glendale, CA 91208, USA
  • Nov 09, 2020
[Information Technology]

Job Description

Purpose:

  • The Senior Data Engineer will design, build, and deliver highly visible and innovative reporting solutions. This role will model and ELT (Extract/Load/Transform) data into a cloud repository (Snowflake) for report consumption.
  • This position works with domain experts to architect, design and build data models and semantic layers based on business rules.

Essential Activities:

  • Migrate data and tools (modernize) from on premise to Cloud technologies
  • Design and create data models/semantic layers
  • Design, develop, automate, monitor and maintain ELT/ETL applications using preferred tools and techniques
  • Performance tune ELT/ETL to manage high volume batch data transfer to and from internal and external system locations
  • Recommend solutions and lead team through the process
  • Interact with cross-functional teams, project managers and agile teams to estimate development efforts and ensure complete delivery of solutions and accurate requirement fulfillment
  • Influence the business and leadership on processes and procedures that will drive value within the business and across the technical landscape
  • Communicate effectively and efficiently both written and verbally

Requirements:

  • Bachelor's Degree (BA/BS/BFA) or Equivalent
  • 7-10 years related work experience
  • Experience with AWS technologies with, preferably, Snowflake, Teradata, Sql Server, DB2 as the backend
  • Extensive experience with delivery using ETL/ELT tools and techniques (i.e., Informatica, DataStage, SSIS, Talen, Airflow, Fivetran etc)
  • Expert understanding of data warehouse and master data management approaches, ELT industry standards and best practices
  • Experience building Data Vault and/or Star Schema models
  • Experience with BI reporting tools a plus such as Tableau, Cognos, Microstrategy or Looker
  • Possess strong communication skills and the ability to work with technical teams and business teams

- provided by Dice
Associated topics: data analyst, data engineer, data integrity, data manager, data management, data scientist, data warehousing, database, mongo database, sybase