GCP Consultant

Job Overview

We are seeking a skilled BigQuery Data Engineer to join our team at Qualysoft. This is an exciting opportunity to work with cutting-edge technologies and contribute to scalable data solutions.

Key Responsibilities

• Design, optimize, and maintain scalable data solutions using Google Cloud Platform, with a strong focus on BigQuery.
• Analyze and improve BigQuery query performance, ensuring efficient execution and reduced processing costs.
• Implement best practices for BigQuery architecture, including partitioning, clustering, table design, and data lifecycle management.
• Develop and optimize complex SQL queries for analytical and reporting workloads.
• Monitor query performance, troubleshoot bottlenecks, and provide performance tuning recommendations.
• Collaborate with Data Engineers, Analysts, and business stakeholders to understand data requirements and deliver scalable solutions.
• Design and maintain ETL/ELT pipelines using GCP services such as Dataflow, Pub/Sub, and Google Cloud Storage.
• Create automation scripts using Python or similar programming languages for reporting, monitoring, and optimization tasks.
• Manage and optimize BigQuery costs by analyzing usage patterns and implementing cost-efficient strategies.
• Utilize GCP monitoring and logging tools to track system health, resource utilization, and query performance.
• Define and document best practices, standards, and optimization guidelines for BigQuery and GCP environments.
• Support data modeling activities for analytical and business intelligence solutions.
• Stay updated with new GCP and BigQuery features, industry trends, and cloud optimization techniques.

Required Qualifications

• Strong hands-on experience with Google Cloud Platform (GCP), especially BigQuery.
• In-depth understanding of BigQuery architecture, storage, partitioning, clustering, materialized views, and query optimization techniques.
• Advanced SQL knowledge with proven experience writing and optimizing complex queries.
• Experience analyzing query execution plans and identifying performance bottlenecks.
• Solid understanding of BigQuery pricing models, cost optimization strategies, and resource management.
• Experience designing and implementing ETL/ELT pipelines in cloud environments.
• Knowledge of GCP services

About Qualysoft

Qualysoft is a 25-year-old software engineering company established in Vienna, Austria, with an active presence in Romania since 2007. We deliver end-to-end IT consulting services, including team augmentation, dedicated teams, and custom software development. Our global presence spans multiple countries, and we have an international team of 500+ software engineers. We are a Microsoft Cloud Certified Partner and have strategic partnerships with industry leaders.