Seargin

Careers At Seargin

Break into the IT industry without coding or tech skills and join teams working on international projects.

Data Enginner - GCP BQ Layer

Seargin is a dynamic multinational tech company operating in 50 countries. At Seargin, we drive innovation and create projects that shape the future and greatly enhance the quality of life. You will find our solutions in the space industry, supporting scientists in the development of cancer drugs, and implementing innovative technological solutions for industrial clients worldwide. These are just some of the areas in which we operate.

Position:

Data Enginner – GCP BQ Layer

Location:

Remote

Country:

European Union

Form of employment:

B2B

Experience level:

Junior/Mid/Senior

Responsibilities:

  • Schema Management

    Create and map schemas from Vertica to BigQuery for seamless data integration

  • Data Transfer

    Perform one-time data transfers between systems to ensure data consistency

  • Schema and Query Mapping

    Map schemas and queries from BigQuery to the MI Layer for efficient data retrieval.

  • Query Optimization

    Optimize queries for fetching data from the Machine Learning (ML) layer to enhance performance

  • Environment Promotion

    Manage environment promotion across Development, Certification, and Production stages for smooth application deployment

What we offer

Requirements:

  • Migration Expertise

    Proficient in migrating data and applications from Vertica to BigQuery while ensuring seamless functionality

  • Materialized Views Development

    Design and develop materialized views and derived tables on GCP to enhance performance and optimize query execution

  • SQL Optimization

    Optimize Vertica SQL queries for efficient execution in the BigQuery environment, maximizing resource utilization

  • Experience Level Requirement

    Possess a minimum of 5 years of experience in Vertica and BigQuery SQL to handle complex data migration tasks effectively

  • Airflow DAG Development

    Mandatory expertise in developing Airflow Directed Acyclic Graphs (DAGs) using Python for orchestrating data workflows in Google Cloud Composer and integrating with BigQuery SQL queries

Apply & join the team




    Ready to elevate your business? Let’s start the conversation.

    Reach out to learn more