Data Architect

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
• 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.
• 2+ years of Google Cloud 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 Professional Architect and or Data Engineer Certification is preferred
• Experience with the healthcare industry specifically creating FHIR stores is a plus
• Experience with Heathcare API and Heathcare Data Engine is a plus
• Proven experience in migrating databases like Teradata to BigQuery
• Proven experience in migration databases like mySQL