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.