Role: BigQuery Database Administrator
Location: Boston, MA (Onsite)
Job Type: Contract
Duration: 6 months contract,
Job Summary:
We are seeking a skilled Python BigQuery DBA to manage, optimize, and maintain our BigQuery data warehouse environment. The ideal candidate will have strong experience in database administration, performance tuning, and automation using Python, with a deep understanding of Google Cloud Platform (GCP), particularly BigQuery.
Key Responsibilities:
- Administer and maintain BigQuery datasets, tables, and views.
- Design and implement efficient data models and schemas for analytics and reporting.
- Optimize BigQuery SQL queries and manage costs associated with data processing.
- Develop and maintain Python scripts for data processing, automation, and database management.
- Monitor performance, troubleshoot issues, and implement best practices for data security and access control.
- Collaborate with data engineers, analysts, and business stakeholders to support data needs.
- Create and maintain documentation related to data architecture, processes, and workflows.
- Implement backup, recovery, and data archival strategies.
Required Skills & Qualifications:
- 3–6 years of experience as a Database Administrator, with at least 2+ years of experience in BigQuery.
- Proficiency in writing complex SQL queries and query optimization in BigQuery.
- Strong hands-on experience in Python for scripting, automation, and data processing.
- Deep understanding of database design, indexing, and data partitioning strategies.
- Experience with GCP services including IAM, Cloud Storage, Dataflow, and Pub/Sub is a plus.
- Knowledge of ETL/ELT tools and frameworks (e.g., Apache Airflow, dbt) is a plus.
- Familiarity with CI/CD pipelines and version control tools like Git.
- Strong analytical and problem-solving skills.
- Excellent communication and documentation skills.
Preferred Qualifications:
- GCP Professional Data Engineer or similar certification.
- Experience working in Agile/Scrum environments.
- Exposure to data governance, compliance, and data quality frameworks.
Education:
- Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
Job Type: Contract
Pay: $50.00 - $65.00 per hour
Work Location: In person
Report job
