Data Modeler/Data Architect on GCP
Data Modeler/Data Architect on GCP
Posted on :
23-05-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
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 an ability to collaborate 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 EDPs 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 in a cloud-native environment.
- Work closely with data engineers to translate models into efficient BigQuery implementations (partitioning clustering materialized views).
- Data Standardization & Governance
- Define and maintain data definitions relationships and business rules for curated assets.
- Ensure data integrity consistency and governance across datasets.
- Work with Data Governance teams to align models with enterprise data standards and metadata management policies.
- Collaboration with Business & Technical Teams
- Engage with business analysts and product teams to understand data needs ensuring models align with business requirements.
- Partner with data engineers and architects to implement best practices for data ingestion and transformation.
- Support BI & analytics teams by ensuring curated models are optimized for downstream consumption (e.g. Looker Tableau Power BI AI/ML models APIs).
Required Qualifications:
- Experience in data modeling and architecture in cloud data platforms (BigQuery preferred).
- Expertise in dimensional modeling (Kimball) data vault and normalization/denormalization techniques.
- Strong SQL skills with hands-on experience in BigQuery performance tuning (partitioning clustering query optimization).
- Understanding of retail data models (e.g. sales inventory pricing supply chain customer analytics).
- Experience working with data engineering teams to implement models in ETL/ELT pipelines.
- Familiarity with data governance metadata management and data cataloging.
- Excellent communication skills and ability to translate business needs into structured data models.
Preferred Qualifications:
- Prior experience working in retail or e-commerce data environments.
- Exposure to modern data architectures (data lakehouse event-driven data processing).
- Familiarity with GCP ecosystem (Dataflow Pub/Sub Cloud Storage) and BigQuery security best practices.
This is a 100% remote position.
Employment Type
Full Time
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
