Sr Data Engineer - Burbank, United States - Tentek, Inc.

    Default job background
    Technology / Internet
    Description

    Sr Data Engineer (Onsite, W2 Only)

    Client location: Burbank, CA

    Work location: Onsite position in Burbank, CA

    Duration of Assignment: 12+ Months

    W2 Only Position

    JOB DESCRIPTION:

    The team is involved in various activities ranging from data acquisition and validation, designing and implementing ETL/ELT data pipelines, designing and implementing databases, and evolving our next generation data platform to fulfill the needs of our applications, data services, ad-hoc analytics and self-service/POC initiatives.

    Responsibilities

    The Data Engineering team is looking to fill a Senior Data Engineer responsible for designing and implementing ETL/ELT data pipelines, designing and implementing database schema/tables/views, and building batch processes leveraging Airflow for several projects.

    This Senior Data Engineer will be responsible for partnering with our Studios or Enterprise Technology team members in various activities around data requirements gathering, data validation scripting and review, developing and monitoring ETL/ELT data pipelines, designing and implementing database schema/tables/views, plus deployment across multiple environments such as DEV, QA/UAT and PROD.

    The role will leverage a multitude of technologies to fulfill the work including, but not limited to SQL, Python, Docker, Gitlab, Airflow, Snowflake, Looker and PostgreSQ.

    Qualifications:

    3+ years of experience with Python.

    4+ years of experience with SQL.

    3+ years of experience designing, building and maintaining ETL/ELT data pipelines.

    2+ years of experience with cloud based technologies, preferably AWS and S3.

    Experience using Apache Airflow, Snowflake and Databricks.

    2+ years leveraging, designing and building relational databases.

    2+ years of experience using Gitlab/Github.

    Preferred Qualifications:

    Experience with Tableau.

    Experience in streaming, media, or digital marketing domain3+ years experience in a Data Engineering role.

    2+ years of experience working on a cloud platform.

    2+ years of experience working with data lakes, data warehouses and application databases.

    Experience working with large datasets and big data technologies, preferably cloud-based, such as Snowflake, Databricks, or similar.

    Experience with SQL Query optimization based on runtime and cost.

    Participate in driving best practices around data engineering software development processes.

    Required Education:

    Bachelor degree in Computer Science, Mathematics.