Data Architect Snowflake Medallion Architecture

Mandatory Skills :

Data Architecture, Snowflake Good to

Have Skills :

IICS - IDMC

Role Overview We are seeking an experienced Data Architect to lead the design and implementation of enterprise scale data platforms on Snowflake with strong expertise in data modeling and medallion architecture Bronze Silver Gold layers The role will drive endtoend data architecture governance and solution design ensuring scalable secure and business aligned data products across domains Key Responsibilities 1 Enterprise Data Architecture Define and implement endtoend data architecture strategy aligned to business objectives Design scalable secure and cost-efficient Snowflake based architectures AI upskillion Status Meeting Establish reference architecture standards and best practices for data platforms 2 Data Modeling Semantic Layer Lead design of enterprise data models conceptual logical physical Define dimensional models star snowflake schema conformed dimensions and KPIs Build and govern semantic layers for analytics BI and AI consumption 3 Medallion Architecture Ownership Architect and define Bronze Silver and Gold layers for multiple data domains Design data transformation frameworks STTM and reusable data products Establish standards for Data ingestion Bronze Data cleansing harmonization Silver Business ready curated datasets Gold 4 Snowflake Platform Architecture Architect Snowflake solutions leveraging Virtual Warehouses RBAC data sharing Data governance and security features masking row level access AI upskillion Status Meeting Define performance scalability and cost optimization strategies 5 Data Engineering ETLELT Strategy Mandatory Tools Define architecture for scalable ETLELT pipelines using IICS and DBT mandatory Establish DBT based transformation frameworks across Bronze Silver Gold layers Design integration patterns using Informatica Intelligent Cloud Services IICS for ingestion and orchestration Drive standardization of Reusable pipelines Data transformation templates Deployment and CICD practices 6 Data Governance Security Quality Design and implement Enterprise data governance frameworks Access control and approval workflows RBAC policies Data Anae Line ERR Meeting Data lineage metadata management and data quality controls Data Anae Line ERR Meeting Ensure compliance with data security and privacy standards 7 Stakeholder Engagement Leadership Conduct architecture workshops requirement discovery and solution design sessions AI upskillion Status Meeting Translate business requirements into technical architecture and implementation roadmap Provide technical leadership and governance across multiple teams Mentor data engineers and modelers drive architectural reviews and standards Required Skills Experience 10-15 years in Data Engineering Data Architecture Proven experience designing largescale enterprise data platforms Strong expertise in Snowflake architecture and ecosystem Data modeling dimensional semantic design Medallion architecture implementation Mandatory Technical Skills Strong handson expertise in Snowflake architecture performance tuning security IICS Informatica Intelligent Cloud Services Data integration orchestration DBT Data Build Tool Transformation across medallion layers Proficiency in SQL and advanced data transformations Cloud platforms AWS Azure Google Cloud Platform Nice to Have Experience in enterprise data marketplace data product architecture Exposure to AIML enablement and Snowflake Cortex integrations Data Anae Line ERR Meeting Metadata catalog tools Alation Collibra Experience in largescale migration and modernization programs AI upskillion Status Meeting Educational Qualification Bachelors or Master s degree in Computer Science Data Engineering or related discipline Preferred Profile Proposal Positioning Experience designing domain driven data products with medallion architecture Strong exposure to enterprise governance models and operating frameworks Proven leadership in multidomain multiteam delivery environments We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, citizenship status, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable law.