Data Architect Snowflake Medallion Architecture
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Galent, is seeking the following. Apply via Dice today!Mandatory Skills : Data Architecture, SnowflakeGood to Have Skills : IICS - IDMCRole OverviewWe 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 layersThe role will drive endtoend data architecture governance and solution design ensuring scalable secure and business aligned data products across domainsKey Responsibilities1 Enterprise Data ArchitectureDefine and implement endtoend data architecture strategy aligned to business objectivesDesign scalable secure and cost-efficient Snowflake based architectures AI upskillion Status MeetingEstablish reference architecture standards and best practices for data platforms2 Data Modeling Semantic LayerLead design of enterprise data models conceptual logical physicalDefine dimensional models star snowflake schema conformed dimensions and KPIsBuild and govern semantic layers for analytics BI and AI consumption3 Medallion Architecture OwnershipArchitect and define Bronze Silver and Gold layers for multiple data domainsDesign data transformation frameworks STTM and reusable data productsEstablish standards forData ingestion BronzeData cleansing harmonization SilverBusiness ready curated datasets Gold4 Snowflake Platform ArchitectureArchitect Snowflake solutions leveragingVirtual Warehouses RBAC data sharingData governance and security features masking row level access AI upskillion Status MeetingDefine performance scalability and cost optimization strategies5 Data Engineering ETLELT Strategy Mandatory ToolsDefine architecture for scalable ETLELT pipelines using IICS and DBT mandatoryEstablish DBT based transformation frameworks across Bronze Silver Gold layersDesign integration patterns using Informatica Intelligent Cloud Services IICS for ingestion and orchestrationDrive standardization ofReusable pipelinesData transformation templatesDeployment and CICD practices6 Data Governance Security QualityDesign and implementEnterprise data governance frameworksAccess control and approval workflows RBAC policies Data Anae Line ERR MeetingData lineage metadata management and data quality controls Data Anae Line ERR MeetingEnsure compliance with data security and privacy standards7 Stakeholder Engagement LeadershipConduct architecture workshops requirement discovery and solution design sessions AI upskillion Status MeetingTranslate business requirements into technical architecture and implementation roadmapProvide technical leadership and governance across multiple teamsMentor data engineers and modelers drive architectural reviews and standardsRequired Skills Experience10-15 years in Data Engineering Data ArchitectureProven experience designing largescale enterprise data platformsStrong expertise inSnowflake architecture and ecosystemData modeling dimensional semantic designMedallion architecture implementationMandatory Technical SkillsStrong handson expertise inSnowflake architecture performance tuning securityIICS Informatica Intelligent Cloud Services Data integration orchestrationDBT Data Build Tool Transformation across medallion layersProficiency inSQL and advanced data transformationsCloud platforms AWS Azure Google Cloud PlatformNice to HaveExperience in enterprise data marketplace data product architectureExposure toAIML enablement and Snowflake Cortex integrations Data Anae Line ERR MeetingMetadata catalog tools Alation CollibraExperience in largescale migration and modernization programs AI upskillion Status MeetingEducational QualificationBachelors or Master s degree in Computer Science Data Engineering or related disciplinePreferred Profile Proposal PositioningExperience designing domain driven data products with medallion architectureStrong exposure to enterprise governance models and operating frameworksProven leadership in multidomain multiteam delivery environmentsWe 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.