Data Engineer - GE
Summary
Designs and maintains enterprise data models for analytics and reporting using dimensional modeling, SQL, and cloud platforms like GCP.
About Kadel Labs
Kadel Labs is a deep-tech IT services company delivering high-quality technology solutions since 2017. We specialize in Digital Transformation, Data Engineering, Cloud, AI/ML, and Enterprise Applications, helping global enterprises build scalable and innovative solutions. Kadel Labs is a CMMI Level 3 and ISO 27001:2022 certified organization committed to engineering excellence and customer success.
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.