1. 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 in a cloud-native environment.
- Work closely with data engineers to translate models into efficient BigQuery implementations (partitioning, clustering, materialized views).
2. 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.
3. 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).