About the job
Overview of 66degrees
66degrees is a leading consulting and professional services company specializing in developing AI-focused, data-led solutions leveraging the latest advancements in cloud technology. With our unmatched engineering capabilities and vast industry experience, we help the world's leading brands transform their business challenges into opportunities and shape the future of work.
At 66degrees, we believe in embracing the challenge and winning together. These values not only guide us in achieving our goals as a company but also for our people. We are dedicated to creating a significant impact for our employees by fostering a culture that sparks innovation and supports professional and personal growth along the way.
Overview of Role
As a Data Architect with 66degrees, you are responsible for assisting customers in their Google Cloud journey through the design and implementation of a data strategy. The Data Architect should be comfortable translating business and technical requirements into scalable and cost-effective database solutions.
Responsibilities
- Facilitate, guide, and influence the client and teams towards an effective architectural pattern and becoming an interface between business leadership, technology leadership and the delivery teams.
- Designing of solution architecture on Google Cloud and Azure
- Architect and deploy data warehouses and data lakes on GCP and Azure, utilizing services like BigQuery, Azure Synapse Analytics, and Databricks.
- Implementation of Proof of Concept (POC) and Minimal Viable Product (MVP) workloads.
- Design a data platform that accounts for the implementation of:
- Database objects
- Data
- Data Pipelines
- Orchestration
- Users and Security
- Migration of workloads
- Perform migration activities including:
- Translation of DDL, Stored Procedures, and Queries into BigQuery and Cloud SQL supported (Postgres and MySQL) syntax
- Executing data transfers using native Google Cloud and 3rd party tools
- Setup and configuration of relative Google Cloud components through Infrastructure as Code (IaC)
- Engage with customer teams as a Google Cloud expert to provide:
- Education Workshops
- Architectural Recommendations
- Technology reviews and recommendations
Qualifications
- 5 years of overall database management and IT experience.
- Experience in defining the technical architecture on Google Cloud involving Cloud Storage, BigQuery, Dataproc, Dataflow, and Cloud Functions and Azure data services (Azure Synapse Analytics, Azure Data Factory, Azure Data Lake Storage, etc.).
- 2+ years of Google Cloud and Azure experience
- Experience in designing data models in BigQuery
- Advanced SQL skills, including the ability to:
- Write, tune, and interpret SQL queries
- Tool specific experience in the RDBMS listed above is ideal
- Experience in utilizing SQL Frameworks like dbt or Dataform
- Advanced programming skills, preferably in Python, including the ability to:
- Utilize data processing frameworks like Spark, Beam, or Pandas
- Utilize orchestration frameworks like Airflow or Cloud Workflows
- Create APIs by using GraphQL, Fast API, Django, or Flask
- Google Cloud and Azure certifications are preferred
- Proven experience in migrating databases like Teradata to BigQuery
- Proven experience in migration databases like mySQL, Postgres, and Oracle to Cloud SQL
66degrees is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to actual or perceived race, color, religion, sex, gender, gender identity, national origin, age, weight, height, marital status, sexual orientation, veteran status, disability status or other legally protected class.