Data Engineer

Ivish Networks LLC
  • Mountain View, CA
  • $50–$55 Per Hour
  • Full-time
  • Instant Apply
1 day ago

Job Description

Role : GCP Data engineer

Location : Concord, CA (Hybrid)

 

Job Description

What You'll Do (Responsibilities):

● Architect & Design: Design and implement robust, scalable, and cost-effective data solutions on Google Cloud, serving as the target architecture for migrated workloads.

● Develop Reusable Frameworks & Accelerators: Design, build, and maintain reusable frameworks, templates, and code libraries to standardize and accelerate data engineering work. This includes creating boilerplate pipeline structures, generic data validation modules, and automated deployment patterns that other engineers will leverage.

● Migrate & Modernize: Lead the hands-on migration of data and processes from on-premise systems like Teradata and Hadoop to Google Cloud services, with a primary focus on BigQuery, Google Cloud Storage (GCS), Dataflow, and Dataproc.

● ETL/ELT Transformation: Analyze, deconstruct, and translate complex legacy ETL logic from tools like Informatica and Teradata BTEQ/Stored Procedures into modern, cloud-native pipelines, leveraging the frameworks/tooling you help create.

● Pipeline Development: Build and automate new data pipelines for batch and streaming data using Python, SQL, and GCP's core services, ensuring all new development contributes to and benefits from our shared engineering frameworks.

● Performance & Cost Optimization: Proactively optimize BigQuery performance through effective partitioning, clustering, and query tuning.

● Data Validation & Governance: Develop and implement rigorous data validation frameworks to ensure data integrity and accuracy post-migration. Collaborate with governance teams to apply data security, lineage, and cataloging using tools like Google Cloud Data Catalog and Dataplex.

● Collaboration & Mentorship: Work closely with on-premise data experts, business analysts, and other engineers to understand requirements, ensure a smooth transition, and act as a subject matter expert and mentor for GCP and internal framework best practices.

Numbers & Facts

LocationMountain View, CA
Job TypeFull-time
Salary$50–$55 Per Hour
Company Size1 - 10
HeadquartersPlano, TX, US
Websitehttps://ivishnetworks.com/

Qualifications

Required Qualifications (Must-Haves):

● Professional Experience: 5+ years of professional experience in a data engineering role, with a proven track record of building and maintaining large-scale data systems.

● Framework Design & Development: Demonstrable experience designing, building, and promoting the adoption of reusable data engineering frameworks such as Ingestion, Transformation, Validation etc

● On-Premise Data Warehouse/Big Data Expertise: Deep, hands-on experience with at least one of the following on-premise ecosystems:

○ Teradata: Strong understanding of the Teradata architecture, utilities (BTEQ, TPT, FastLoad/MultiLoad), and advanced SQL/Stored Procedure development.

○ Hadoop: Experience with the Hadoop ecosystem (HDFS, YARN, Hive) and hands-on proficiency with PySpark for large-scale data processing.

○ Enterprise ETL: Demonstrable experience designing and building complex workflows in an enterprise ETL tool like Informatica PowerCenter.

● Google Cloud Platform (GCP) Proficiency: Demonstrable hands-on experience designing, building, and operating solutions with a comprehensive set of GCP data services, including:

○ Core Data Processing & Warehousing: Google BigQuery (including data modeling, performance tuning, cost management), Google Cloud Storage (GCS), Cloud Dataflow, and Cloud Dataproc.

○ Orchestration & Event-Driven Architecture: Cloud Composer (Managed Airflow) for complex workflow orchestration, and Pub/Sub and Cloud Functions for building streaming and event-driven data pipelines.

○ Data Governance & Management: Practical experience using Dataplex for unified data management, security, and governance across data lakes and warehouses.

● Core Engineering & Migration Skills:

○ Expert-level proficiency in SQL, including complex joins, window functions, and performance tuning across different database engines.

○ Strong programming skills in Python, applying software engineering best practices.

○ Hands-on experience with Google's migration assessment tools (e.g., BigQuery Migration Service, Database Migration Service) to analyze on-premise workloads and accelerate migration.

○ Deep understanding of data warehousing concepts, ETL/ELT patterns, data modeling, and database design. Preferred Qualifications (Nice-to-Haves):

● Proven Migration Experience: Direct, hands-on experience successfully completing at least one large-scale on-premise (Teradata, Hadoop, etc.) to Google Cloud Platform.

 

● Certifications: A Google Cloud Professional Data Engineer certification is a plus.

Skills

  • Analysis Skillsunmatched
  • Apache Hadoopunmatched
  • BTEQunmatched
  • Best Practicesunmatched
  • Business Analysisunmatched
  • Cataloguingunmatched
  • Cloud Computingunmatched
  • Cloud Storageunmatched
  • Cost Controlunmatched
  • Data Managementunmatched
  • Data Migrationunmatched
  • Data Qualityunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • GCP (Good Clinical Practices)unmatched
  • Informaticaunmatched
  • Information/Data Security (InfoSec)unmatched
  • Machine Toolunmatched
  • Mentoringunmatched
  • NCR Teradataunmatched
  • Performance Tuning/Optimizationunmatched
  • Python Programming/Scripting Languageunmatched
  • SQL (Structured Query Language)unmatched
  • Stored Proceduresunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder