Comerit

Google Cloud Certified Professionals

United States full-time Mid Salary not listed
full-time Mid level Technology & IT Curated
Sign in to apply Free account — we bring you straight back to this role.

About the role

This is a remote position.

Comerit is searching for Google Cloud Certified Professionals! As the market is growing in the Google Cloud space, so are the number of projects for Comerit that are Google Cloud Platform based. Specifically as we specialize in Data Transformation and Analytics, we would also prefer consultants with (GCP) BigQuery experience.

Although your GCP BigQuery experience may vary depending on the specific role and responsibilities assigned. However, here are some aspects of your BigQuery experience that may be relevant:

Querying and Analysis: Writing SQL-like queries to extract insights from large datasets stored in BigQuery. This involves understanding the data schema, performing complex aggregations, joins, and transformations, and optimizing queries for performance.

Data Loading and Extraction: Importing data from various sources into BigQuery, including files from Cloud Storage, streaming data from Pub/Sub, or data transfer from external systems. Similarly, exporting data from BigQuery to external destinations.

Data Transformation: Performing data preprocessing and transformation tasks using BigQuery's powerful SQL capabilities. This may involve data cleaning, normalization, denormalization, and creating derived tables or views.

Data Modeling and Schema Design: Designing and maintaining logical data models and schemas within BigQuery. This includes defining tables, partitions, and clustering strategies to optimize data storage and query performance.

Performance Optimization: Analyzing query execution plans, identifying bottlenecks, and optimizing query performance through techniques like partition pruning, caching, and query tuning.

Integration and Automation: Collaborating with other GCP services, such as Cloud Storage, Pub/Sub, Dataflow, or Data Studio, to build end-to-end data pipelines or integrate BigQuery with other systems. Automating job execution using scheduling tools or workflow frameworks like Cloud Composer or Cloud Data Fusion.

Monitoring and Troubleshooting: Monitoring the performance and health of BigQuery jobs, identifying and resolving issues related to data ingestion, query performance, or data consistency. Utilizing monitoring tools, logging, and error handling mechanisms.

Security and Compliance: Implementing appropriate security measures to protect sensitive data within BigQuery, adhering to data governance policies and compliance regulations. Managing access controls, data encryption, and auditing.

Documentation and Collaboration: Maintaining documentation, including data dictionaries, process flows, and technical specifications. Collaborating with cross-functional teams, including data engineers, data scientists, and business stakeholders, to understand requirements and deliver solutions.

Continuous Improvement: Staying up-to-date with the latest features and enhancements in BigQuery and related GCP services. Actively exploring opportunities to optimize data processing pipelines, enhance performance, and reduce costs.

If you are a Google Cloud Certified Professional, please apply and register.
Requirements

Any one of the following Google Cloud Platform Certifications:
Professional Cloud Architect Certification

Professional Data Engineer Certification

Professional Cloud Developer Certification

Professional Cloud Network Engineer Certification

Professional Cloud Security Engineer Certification

Professional Collaboration Engineer Certification

Professional Cloud DevOps Engineer

Google Cloud Certified Fellow: Hybrid Multi-Cloud

Professional Machine Learning Engineer

Originally posted on Himalayas

Interview prep

Walk in with sharper answers.

Use this as a quick practice sheet before you speak with the employer.

Mid
Technology & IT API integration Data Analysis MySQL Remote Collaboration SQL Mid level

Likely questions

  1. Tell us about work you have done that is close to the Google Cloud Certified Professionals role.
  2. How would you approach your first 30 days at Comerit?
  3. Which of API integration, Data Analysis and MySQL have you used recently, and what did it help you achieve?
  4. Describe a time you solved a problem without waiting to be told exactly what to do.
  5. How do you handle busy days, changing priorities, or pressure at work?

Prepare before the call

  • A recent example that proves your experience with API integration, Data Analysis and MySQL.
  • One short story with a problem, your action, and the result.
  • Two examples that show the strengths listed on your CV.
  • A clear reason why this role and company interest you.
  • Your availability, preferred work style, and salary expectations.

Ask them

  • What would success look like in the first 90 days?
  • What are the main problems this hire should help solve?
  • How does the team give feedback and measure good work?
  • What does a normal working week look like for this role?
Practice line

I am interested in the Google Cloud Certified Professionals role because I can bring practical experience in API integration, Data Analysis and MySQL, learn the team quickly, and contribute to the outcomes Comerit needs from this hire.

Related jobs.

More roles from this company or category.