Data Engineer - ETL/Google Cloud Platform

About the Role :We are looking for an experienced Data Engineer with strong expertise in Data Modeling to design and maintain enterprise data models supporting analytics and reporting. The ideal candidate will have hands-on experience in dimensional data modeling, SQL, business requirement gathering, and data analysis, along with exposure to modern cloud platforms such as Google Cloud Platform (GCP).Key Responsibilities :- Design and maintain Conceptual, Logical, and Physical Data Models (CDM, LDM, and PDM) based on business requirements.- Develop dimensional data models using Star and Snowflake schemas for enterprise reporting and analytics.- Perform data analysis, profiling, and business requirement gathering to identify entities, relationships, facts, and dimensions.- Prepare Source-to-Target Mapping (STTM) documents, including transformation logic and business rules.- Define data grain, KPIs, measures, hierarchies, and Slowly Changing Dimension (SCD) strategies.- Collaborate with Data Engineers, Business Analysts, and stakeholders to ensure accurate implementation of data models.- Support enterprise data warehouse design across Bronze, Silver, Conformed, and Gold layers.- Implement data quality validation and reconciliation rules.- Contribute to metadata management, data cataloging, business glossary, data dictionaries, lineage, and technical documentation.- Perform impact analysis for source system and data model changes.- Ensure adherence to enterprise data modeling standards and best practices.Required Skills :- Strong experience in Dimensional Data Modeling.- Expertise in SQL and Data Analysis.- Experience gathering and translating business requirements into technical data models.- Hands-on experience with data modeling tools such as ERwin, ER/Studio, or equivalent.- Strong understanding of Data Warehousing concepts.- Excellent analytical, problem-solving, and communication skills.Good to Have :- Experience with Google Cloud Platform (GCP).- Domain knowledge in Supply Chain or Finance.- Exposure to enterprise data governance and metadata management.Why Join Kadel Labs - Opportunity to work on enterprise-scale data engineering projects.- Collaborative and innovation-driven work environment.- Exposure to modern cloud and data technologies.- Continuous learning and career growth opportunities.- Flexible remote work environment. (ref:hirist.tech) .