Advanced SQL, data modeling skills - designing Dimensional Layer, 3NF, denormalized views & semantic layer, Expertise in GCP services
Role & Responsibilities
- Design and implement robust semantic layers for data systems on Google Cloud Platform (GCP)
- Develop and maintain complex data models, including dimensional models, 3NF structures, and denormalized views
- Write and optimize advanced SQL queries for data extraction, transformation, and analysis
- Utilize GCP services to create scalable and efficient data architectures
- Collaborate with cross-functional teams to translate business requirements(specified in mapping sheets or Legacy
Datastage jobs) into effective data models
- Implement and maintain data warehouses and data lakes on GCP
- Design and optimize ETL/ELT processes for large-scale data integration
- Ensure data quality, consistency, and integrity across all data models and semantic layers
- Develop and maintain documentation for data models, semantic layers, and data flows
- Participate in code reviews and implement best practices for data modeling and database design
- Optimize database performance and query execution on GCP
- Provide technical guidance and mentorship to junior team members
- Stay updated with the latest trends and advancements in data modeling, GCP services, and big data technologies
- Collaborate with data scientists and analysts to enable efficient data access and analysis
- Implement data governance and security measures within the semantic layer and data model
Skills:- Data modeling, Dimensional modeling and Google Cloud Platform (GCP)