Data Warehouse Architect

Há 4 horas

São Paulo, Estado de São Paulo, Brasil AVM Consulting Inc Tempo inteiro
Databricks Data Warehouse ArchitectAbout 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

  • Data Warehouse Architect

    1 semana atrás

    São Paulo, São Paulo, Brasil AVM Consulting Inc Tempo inteiro US$80.000 - US$120.000 por ano

    Databricks Data Warehouse ArchitectAbout the role:One of the largest companies in the world in the Gaming industry is seeking a hands-onData Architect with DataWarehouse Engineerexpertise inDatabricks (DBX)andAWS-native data servicesto spearhead the design and implementation of a new data warehouse instance for a major product line. This role will involve...

  • Data Architect

    2 semanas atrás

    São Paulo, São Paulo, Brasil Cadastra Tempo inteiro R$90.000 - R$120.000 por ano

    Descrição da EmpresaA Cadastra é uma empresa global que combina serviços de marketing digital, consultoria e tecnologia. Há mais de 20 anos, ajudamos clientes a transformar e expandir seus negócios. Apoiamos marcas a alcançar excelência em operações digitais como Paid Search, SEO, mídia programática, redes sociais, e-commerce, CRM, Data Science,...

  • AWS Data Engineer

    Há 4 horas

    São Paulo, São Paulo, Estado de São Paulo, Brasil Decision group Tempo inteiro

    Nível Acadêmico: Ensino Superior Completo Turno/Horas -- Áreas de Atuação Profissional: TI - Projetos Descrição: Project Description We are looking for an experienced AWS data engineer, who will join the team responsible for the second phase of data warehouse cloud migration project. The initial 'lift-and-shift' of an on-premise MS SQL data warehouse...

  • Data Architect Specialist

    1 semana atrás

    São Paulo, São Paulo, Brasil CADASTRA Tempo inteiro R$90.000 - R$120.000 por ano

    Quer fazer a diferença na nova economia e transformar pessoas e negócios para prosperarem? Vem pra CadastraComo Data Architect Specialist em Google Cloud Platform (GCP) para liderar o desenho e a evolução de nossas arquiteturas de dados. Esse papel é estratégico, com foco em definir padrões, garantir governança e viabilizar soluções escaláveis que...

  • Staff Data Architect

    Há 17 horas

    São Paulo, São Paulo, Brasil Blip Tempo inteiro R$4.000 - R$12.000 por ano

    Why this Role ExistsAt Blip, architecture is more than design, it's the backbone of scalability and trust. Our data ecosystem powers billions of daily interactions, and we're evolving it to support next-generation AI and decision systems.We're seeking a Staff Data Architect to shape our enterprise-wide data architecture, defining blueprints and bringing them...

  • Cloud Architect

    Há 4 horas

    São Paulo, Estado de São Paulo, Brasil Tata Consultancy Services Tempo inteiro

    Come to one of the biggest IT Services companies in the world!! Here you can transform your career! Why to join TCS? Here at TCS we believe that people make the difference, that's why we live a culture of unlimited learning full of opportunities for improvement and mutual development. The ideal scenario to expand ideas through the right tools, contributing...

  • Data Analyst

    Há 3 horas

    São Paulo, São Paulo, Estado de São Paulo, Brasil JP & F Consultoria Tempo inteiro

    ETL, PL/SQL, Python, SCRUM, BI, Database Triggers, Database Views, Conhecimento em PL/SQL, Conhecimento metodologia Scrum, Modelagem, Conhecer o framework de desenvolvimento DBT, Algum conhecimento em linguagem de programação Python, Computação em nuvem, Cloud data warehouse e ferramentas de BI. FORMAÇÃO: Superior Completo HORÁRIO: Comercial...

  • Cyber Security Architect

    Há 3 horas

    São Paulo, Estado de São Paulo, Brasil GeorgiaTEK Systems Inc. Tempo inteiro

    Cyber Security Architect Work Model: Hybrid (2–3 days per week onsite in Alphaville – Barueri, São PauloContract Type: Full-Time Employment We are seeking a Cyber Security Architect with solid technical expertise and a strategic mindset. This role combines advanced security architecture design with hands-on implementation of modern security practices....

  • Solutions Architect

    Há 19 horas

    São Paulo, São Paulo, Brasil 60d1bb47-e6df-4ceb-992a-b8d65646aa31 Tempo inteiro US$120.000 - US$180.000 por ano

    Join us as a Solutions Architect (Snowflake) and build scalable apps that make an impact. You'll explore new tech, work with the latest tools, and thrive in a fast-moving Agile team.About the ClientA U.S.-based education services provider offering online and campus-based post-secondary education, primarily serving military personnel, veterans, and public...

  • Senior Data Engineer

    1 semana atrás

    São Paulo, São Paulo, Brasil Astro Sirens LLC Tempo inteiro R$80.000 - R$120.000 por ano

    Astro Sirens is an IT staffing agency based in Austin, Texas. We help connect talented professionals from around the world with U.S. companies, giving them exciting opportunities to work on a variety of projects for top clients.Responsibilities - Design, develop, and maintain scalable ETL/ELT pipelines for structured and unstructured data. - Architect and...