Data Architect

66degrees • Chicago, IL

3d

About The Position

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.

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 Pandas, Utilize orchestration frameworks like Airflow or Cloud Workflows, Create APIs by using GraphQL, Fast API, Django, or Flask

Nice To Haves

• 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, Postgres, and Oracle to Cloud SQL

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed