Data Architect

Summary

Join 66degrees as a Data Architect and assist clients in their Google Cloud journey by designing and implementing data strategies. Translate business and technical needs into scalable, cost-effective database solutions. Guide clients and teams toward effective architectural patterns, acting as an interface between business and technology leadership. Design solutions on Google Cloud, implement POCs and MVPs, and create data platforms encompassing databases, data pipelines, orchestration, users, security, and workload migration. Perform data migration activities, including translating code and executing data transfers. Serve as a Google Cloud expert, providing education, architectural recommendations, and technology reviews. This role requires significant experience in database management, Google Cloud technologies, and data modeling.

Requirements

• 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 PandasUtilize orchestration frameworks like Airflow or Cloud WorkflowsCreate APIs by using GraphQL, Fast API, Django, or Flask

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 objectsDataData PipelinesOrchestrationUsers 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) syntaxExecuting data transfers using native Google Cloud and 3rd party toolsSetup and configuration of relative Google Cloud components through Infrastructure as Code (IaC)
• Engage with customer teams as a Google Cloud expert to provide:Education WorkshopsArchitectural RecommendationsTechnology reviews and recommendations

Preferred Qualifications

• Google Cloud Professional Architect and or Data Engineer Certification is preferred
• Experience with the healthcare industry specifically creating FHIR stores
• Experience with Heathcare API and Heathcare Data Engine
• Proven experience in migrating databases like Teradata to BigQuery
• Proven experience in migration databases like mySQL, Postgres, and Oracle to Cloud SQL