Software Engineer

Description As a GCP Data Engineer, you will be instrumental in modernizing our data infrastructure by building robust, automated ETL/ELT pipelines and leveraging Google Cloud Platform's powerful suite of big data tools. Collaborating closely with Enterprise Architects, you will spearhead the migration from legacy Hadoop/CDP systems to BigQuery. Your daily focus will involve architecting historical and incremental data loads, orchestrating tasks with Apache Airflow, and creating scalable, data-driven solutions that empower the organization with clean, accessible, and organized data.

Responsibilities

• Pipeline Development: Develop and maintain efficient ETL/ELT pipelines, implementing and automating tasks using Apache Airflow.
• Data Architecture: Architect historical and incremental data loads, continuously evaluating and refining the data architecture to ensure optimal performance.
• Data Warehousing: Support, organize, and optimize data within Google BigQuery data warehouses.
• System Migration: Work alongside Enterprise Architects to lead and deliver the migration of data from legacy Hadoop/Cloudera Data Platform (CDP) systems to BigQuery.
• Enterprise Solutions: Design and build end-to-end, GCP data-driven solutions for enterprise data warehouses and data lakes.

Must Have:

• Certification: Professional GCP Data Engineer Certification or equivalent. 
• Development Experience: 2+ years of coding experience in Java/Python and Infrastructure as Code using Terraform.
• GCP Expertise: 2+ years of experience working in GCP-based Big Data deployments (both Batch and Real-Time), specifically leveraging BigQuery, Bigtable, Google Cloud Storage, Pub/Sub, Data Fusion, Dataflow, Dataproc, and Airflow.
• Data Design: Proven history of designing and delivering comprehensive data lake and data warehousing solutions.
• Data Processing: Strong hands-on experience in extracting, loading, transforming (ETL/ELT), cleaning, and validating data, as well as designing pipelines and architectures for data processing.
• Database Skills: Proficiency in at least one SQL language.
• Big Data Tools: Practical experience working with Spark services.
• Methodologies: Experience working within Agile and Lean methodologies.

Good to Have (Preferred):

• Data Visualization: Experience using visualization tools such as Qlik or Looker Studio.
• Migration Experience: Proven experience in migrating legacy systems (preferably Big Data Cloudera Data Platform) into GCP technologies.
• Large-Scale Systems: Experience working with either a MapReduce or an MPP (Massively Parallel Processing) system at any size or scale.