Data Engineer - ETL/Google Cloud Platform
First seen by Alion on Jul 23, 2026.
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.
Skills
Data Engineering, ETL, Big Data, Cloud Computing, Data Modeling, NoSQL, Google Cloud Platform