Closed listing
Senior BigQuery Engineer (Local to Quebec)
- Montreal, QC, Canada
Contract
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Contract
- Closing date
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Job Title: Senior BigQuery Engineer (Local to Quebec)
Job Location: Montreal, QC (3 days/week onsite)
Job Duration: Long Term
Our Challenge
We are seeking a Senior BigQuery Engineer to design, build, and optimize scalable data solutions on Google Cloud Platform. This role will develop reliable data warehouses, ETL/ELT pipelines, and analytics platforms using BigQuery and related GCP services. The ideal candidate is a strong technical contributor who can collaborate with cross-functional teams, solve complex data challenges, and mentor other engineers.
Responsibilities:
- Design and implement scalable data warehouses, data marts, and analytics solutions using BigQuery.
- Develop, maintain, and optimize complex SQL queries, views, stored procedures, and data models.
- Build and manage batch and real-time ETL/ELT pipelines using GCP services.
- Improve BigQuery performance and control costs through partitioning, clustering, materialized views, and workload optimization.
- Implement data quality checks, monitoring, alerting, and pipeline reliability standards.
- Apply data security, governance, access control, and compliance best practices.
- Collaborate with stakeholders, participate in technical design and code reviews, troubleshoot production issues, and mentor junior engineers.
Skills:
- Bachelor’s degree in Computer Science, Engineering, Information Technology, or a related field.
- 7+ years of experience in data engineering or a related discipline.
- 4+ years of hands-on experience with Google BigQuery.
- Advanced SQL skills, including query optimization, analytical functions, and data transformation.
- Strong knowledge of data warehousing, dimensional modeling, and large-scale data processing.
- Proficiency in Python, Java, Scala, or another programming language.
- Experience with GCP services such as BigQuery, Cloud Storage, Dataflow, Pub/Sub, Cloud Composer, Dataproc, IAM, and Cloud Monitoring.
More about this job
Responsibilities
Design, build, and optimize BigQuery data warehouses, data marts, analytics solutions, and batch or real-time ETL/ELT pipelines using GCP services. Improve performance, cost efficiency, data quality, security, and reliability while collaborating with stakeholders, troubleshooting production issues, and mentoring junior engineers.
Requirements
Requires a bachelor’s degree in Computer Science, Engineering, Information Technology, or a related field, along with at least seven years of data engineering experience and four years of hands-on BigQuery experience. Candidates should have advanced SQL skills, strong data warehousing and dimensional modeling knowledge, programming proficiency, and experience with relevant GCP services.
Skills
- Google BigQuery
- SQL
- Data Warehousing
- ETL/ELT Pipelines
- Google Cloud Platform
- Python
- Java
- Scala
- Dimensional Modeling
- Cloud Storage
- Dataflow
- Pub/Sub
- Cloud Composer
- Dataproc
- IAM
- Cloud Monitoring
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Engineering
Keywords
- Google BigQuery
- Google Cloud Platform
- SQL
- Python
- Java
- Scala
- Data Warehousing
- Data Marts
- Analytics Platforms
- ETL/ELT
- Batch Processing
- Real-Time Data Processing
- Query Optimization
- Partitioning
- Clustering
- Materialized Views
- Dimensional Modeling
- Data Quality
- Data Governance
- Data Security
- Access Control
- Cloud Storage
- Dataflow
- Pub/Sub
- Cloud Composer
- Dataproc
- IAM
- Cloud Monitoring
- Pipeline Reliability
- Cost Optimization