Data Modeler/Data Architect on GCP

Triade LLC; São Paulo; Teletrabalho; BRL 120.000 - 160.000; Tempo integral

Resumo da oferta

A leading company is seeking a Data Modeler/Data Architect to enhance their Enterprise Data Platform. This role focuses on building optimized data structures in Google BigQuery, requiring expertise in data modeling and collaboration with technical teams. The position is fully remote, offering a dynamic work environment for skilled professionals.

Qualificações

• Experience in data modeling and architecture on cloud platforms.
• Strong SQL skills with experience in BigQuery performance tuning.

Responsabilidades

• Design logical, conceptual, and physical data models for EDP’s curated layer in BigQuery.
• Collaborate with data engineers and analysts to implement models.

Conhecimentos

Data Modeling

SQL

Communication

Ferramentas

BigQuery

ETL

Looker

Tableau

Power BI

Descrição da oferta de emprego

Join to apply for the Data Modeler/Data Architect on GCP role at Triade LLC.

Get AI-powered advice on this job and more exclusive features.

Job Summary:

We are seeking an experienced Data Modeler to support the Enterprise Data Platform (EDP) initiative, focusing on building and optimizing curated data assets on Google BigQuery. This role requires expertise in data modeling, strong knowledge of retail data, and collaboration with data engineers, business analysts, and architects to create scalable and high-performing data structures.

Key Responsibilities:

• Data Modeling & Curated Layer Design: Design logical, conceptual, and physical data models for EDP’s curated layer in BigQuery. Develop fact and dimension tables, ensuring adherence to dimensional modeling best practices (Kimball methodology). Optimize data models for performance, scalability, and query efficiency. Work closely with data engineers to implement models in BigQuery (partitioning, clustering, views).
• Data Standardization & Governance: Define and maintain data definitions, relationships, and business rules. Ensure data integrity, consistency, and governance. Collaborate with Data Governance teams to align models with standards and policies.
• Collaboration with Business & Technical Teams: Engage with analysts and product teams to understand data needs. Partner with data engineers and architects to implement models in ETL/ELT pipelines. Support BI & analytics teams with optimized models for tools like Looker, Tableau, Power BI, AI/ML models, APIs.

Required Qualifications:

• Experience in data modeling and architecture on cloud platforms (BigQuery preferred).
• Expertise in dimensional modeling (Kimball), data vault, normalization/denormalization.
• Strong SQL skills, with experience in BigQuery performance tuning.
• Understanding of retail data models (sales, inventory, pricing, supply chain, customer analytics).
• Experience with data engineering teams on ETL/ELT pipelines.
• Knowledge of data governance, metadata management, and data cataloging.
• Excellent communication skills to translate business needs into data models.

Preferred Qualifications:

• Experience in retail or e-commerce data environments.
• Exposure to modern data architectures (lakehouse, event-driven processing).
• Familiarity with GCP ecosystem (Dataflow, Pub/Sub, Cloud Storage) and BigQuery security best practices.

This is a 100% remote position.

Additional Details:

• Seniority level: Not Applicable
• Employment type: Full-time
• Job function: Information Technology
• Industries: IT Services and IT Consulting