- Gurgaon, India +1 more
- Full-time · Mid
- 3–6 years
The Data Architect (Grade 4) is a foundational data engineering and data modeling specialist responsible for translating business requirements and data domain definitions into physical and logical schema designs, Snowflake data pipelines, and certified Data Product interfaces.
Locations (2)
- Gurgaon, India
- Bangalore
Responsibilities
- Design and maintain logical and physical data models for CSP data domains using ERwin, ER/Studio, or dbt semantic models.
- Develop star-schema, snowflake-schema, and normalized table structures in Snowflake optimized for query performance and data sharing.
- Author comprehensive source-to-target mapping specifications, documenting transformation logic, business rules, and data cleansing requirements.
- Partner with delivery engineers to design ingestion and transformation pipelines moving data from legacy Oracle databases (CRDB) to target Snowflake tables.
- Write and optimize complex SQL transformations, views, and stored procedures in Snowflake.