Data Warehouse Architect

Databricks Data Warehouse Architect About the role: One of the largest companies in the world in the Gaming industry is seeking a hands-on Data Architect with DataWarehouse Engineer expertise in Databricks (DBX) and AWS-native data services to spearhead the design and implementation of a new data warehouse instance for a major product line. This role will involve building from the ground up—architecting scalable pipelines, optimizing lakehouse performance, and integrating seamlessly with diverse real-time and batch data sources across AWS.
The ideal candidate is passionate about data architecture , thrives in fast-moving environments, and has a proven track record of setting up high-performance lakehouse platforms on Databricks with a strong foundation in data warehousing principles .
Key Responsibilities: Design and deploy a new Databricks Lakehouse instance tailored to the client’s product-level data needs.
Architect and implement robust data ingestion pipelines using Spark (PySpark/Scala) and Delta Lake.
Integrate AWS-native services (S3, Glue, Athena, Redshift, Lambda) with Databricks for optimized performance and scalability.
Define data models, optimize query performance, and establish warehouse governance best practices.
Collaborate cross-functionally with product teams, data scientists, and DevOps to streamline data workflows.
Maintain CI/CD, preferably DBX for data pipelines using GitOps and Infrastructure-as-Code.
Monitor data jobs and resolve performance bottlenecks or failures across environments.
Required Skills & Experience: Databricks / Lakehouse Architecture End-to-end setup of Databricks workspaces and Unity Catalog
Expertise in Delta Lake internals , file compaction, and schema enforcement
Advanced PySpark/SQL skills for ETL and transformations

AWS Native Integration Deep experience with AWS Glue , S3 , Redshift Spectrum , Lambda , and Athena
IAM and VPC configuration knowledge for secure cloud integrations
Data Warehousing & Modeling Strong grasp of modern dimensional modeling (star/snowflake schemas)
Experience setting up lakehouse design patterns for mixed workloads
Automation & DevOps Familiarity with CI/CD for data engineering using tools like DBX, Terraform, GitHub Actions, or Azure DevOps
Proficient in monitoring tools like CloudWatch, Datadog, or New Relic for data pipelines
Bonus/Nice to Have: Experience supporting gaming or real-time analytics workloads
Familiarity with Airflow , Kafka , or EventBridge
Exposure to data privacy and compliance practices (GDPR, CCPA)
Other Details: Location : Latin America (LATAM) region - Remote, USA - Remote
Length : 1+ Year
Client : Gaming giant