Key Facts

Remote From:

Anywhere

Fixed term

English

Hard Skills

Other Skills

•
Communication
•
Problem Solving

Roles & Responsibilities

Professional Cloud Architect Certification
Professional Data Engineer Certification
Professional Cloud Developer Certification
Professional Machine Learning Engineer

Requirements:

Design, develop, and optimize BigQuery-based data pipelines, including writing complex SQL, data modeling, partitions, and clustering.
Ingest data into BigQuery from Cloud Storage, Pub/Sub, and external sources, and export data to external destinations.
Collaborate with data engineers, data scientists, and stakeholders to implement end-to-end analytics solutions, ensuring security, governance, and cost efficiency.
Monitor and troubleshoot BigQuery jobs and pipelines; optimize performance and automate workflows using tools like Cloud Composer or Cloud Data Fusion.

COMERIT

About COMERIT

Comerit: Your Data Transformation Partner 🌐At Comerit, data isn't just information – it's potential waiting to be unleashed. As a prominent data transformation and advanced analytics consulting firm headquartered in Folsom, California, we thrive on converting data into actionable insights that drive informed decisions. With a legacy of 25 years of SAP expertise, we understand the intricacies of data and its pivotal role in business success. Our mission is to empower enterprises by providing continuous data insights for superior outcomes.Our comprehensive range of services is designed to cater to your diverse needs:Intelligent Analytics: Transform data into wisdom. Our Intelligent Analytics service empowers you with deeper insights, facilitating informed decisions that steer your business towards excellence.Data Enablement: Your data holds immense potential. We specialize in harnessing this potential, enabling your business to grow, adapt, and prosper.SAP Enterprise Transformation: Unlock SAP's true potential with us. Our SAP S/4HANA Cloud innovation propels your business forward, optimizing operations and enhancing efficiency.Innovative Cloud Technologies: Stay ahead of the curve with our pioneering cloud solutions. Our cutting-edge cloud data warehousing solutions ensure scalability and competitive advantage.With Comerit, you gain more than just a service provider – you gain a partner dedicated to your success. Our cross-discipline teams ensure breakthroughs through data-driven strategies and advanced technology solutions. We integrate your corporate goals with best-in-class capabilities, driving business and technology advancement hand in hand.Empower your business with Comerit. Unlock the true value of your data, leverage 24/7 support, and transform your vision into reality. From insights to action, we're here to make your data work for you. Explore the possibilities – let's connect. 🤝

Company type: SME

Founded: 2018

Company size: 51 - 200

Website LinkedIn See all jobs →

Job description

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.