Overview
Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - 12 Month(s)
Skills
Access Control
Apache Airflow
Apache Kafka
Cloud Computing
Bash
Computer Networking
Continuous Delivery
Cost Control
Data Architecture
Data Engineering
Data Governance
Data Masking
Data Warehouse
Database
Database Administration
Documentation
Extract
Transform
Load
GitLab
GitHub
Google Cloud
Google Cloud Platform
HIPAA
ELT
RBAC
Snow Flake Schema
Terraform
Tableau
Query Optimization
Python
Meta-data Management
Regulatory Compliance
SQL
Scripting
Orchestration
Virtual Private Cloud
Performance Tuning
Continuous Integration
Job Details
Job Summary:
We are seeking a skilled and experienced Snowflake and BigQuery DBA/Admin to manage and optimize our cloud data platforms. The ideal candidate will be responsible for maintaining the health, security, and performance of both Snowflake and Google BigQuery environments. This role will play a key part in supporting cross-cloud data initiatives, ensuring efficient data access, cost optimization, and reliability.
Key Responsibilities:
Snowflake Administration:
- Configure, monitor, and manage Snowflake environments including warehouses, databases, roles, and permissions.
- Optimize Snowflake performance, query tuning, and resource usage.
- Implement best practices around security (RBAC, data masking, encryption).
- Monitor credit usage and implement cost control measures.
- Support integration with tools like dbt, Airflow, Fivetran, Tableau, etc.
BigQuery Administration:
- Manage datasets, tables, partitions, and access control in BigQuery.
- Optimize BigQuery SQL queries for performance and cost efficiency.
- Monitor and manage BigQuery job execution, scheduling, and logging.
- Implement IAM and VPC-SC for secure data access in Google Cloud Platform.
- Collaborate with Google Cloud Platform and data engineering teams for optimal architecture and integration.
Cross-Platform Responsibilities:
- Support ETL/ELT processes between Snowflake and BigQuery or from other cloud/on-prem sources.
- Maintain and monitor pipelines using orchestration tools like Apache Airflow or Cloud Composer.
- Participate in data architecture discussions and help define best practices for hybrid data environments.
- Manage data lifecycle policies and backup strategies across platforms.
- Produce documentation for infrastructure, access policies, and operational procedures.
Required Qualifications:
- Bachelor's degree in Computer Science, Information Systems, or related field.
- 3+ years of hands-on experience in Snowflake administration.
- 2+ years of experience with BigQuery administration and Google Cloud Platform data tools.
- Strong SQL skills and experience with cloud-native data warehouse design.
- Familiarity with scripting languages (Python, Bash, etc.) and automation frameworks.
- Experience with access control, encryption, and audit logging in cloud environments.
- Proficient in monitoring, troubleshooting, and performance tuning.
Preferred Qualifications:
- SnowPro Core Certification and/or Google Cloud Data Engineer Certification.
- Experience with CI/CD for data infrastructure (e.g., dbt, Terraform, GitLab/GitHub Actions).
- Understanding of data governance, compliance (GDPR, HIPAA), and metadata management.
- Experience with real-time data ingestion tools (Kafka, Pub/Sub) is a plus.
- Familiarity with multi-cloud environments and cloud networking concepts.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.