Data Architect Snowflake Medallion Architect - Orlando FL / Seattle WA / Burbank CA (Onsite)
Position: Data Architect Snowflake Medallion ArchitectDuration: 12+ months – contractLocation: Orlando FL / Seattle WA / Burbank CA (Onsite)Job DescriptionSKILLS NEEDED : Snowflake architecture, Medallion ArchitectWe are seeking an experienced Data Architect to lead the design and implementation of enterprisescale 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 businessaligned data products across domainsKey Responsibilities1 Enterprise Data ArchitectureDefine and implement endtoend data architecture strategy aligned to business objectivesDesign scalable secure and costefficient Snowflakebased 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 starsnowflake 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 SilverBusinessready curated datasets Gold4 Snowflake Platform ArchitectureArchitect Snowflake solutions leveragingVirtual Warehouses RBAC data sharingData governance and security features masking rowlevel 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 DBTbased 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 ExperienceCore 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 Masters degree in Computer Science Data Engineering or related disciplinePreferred Profile Proposal PositioningExperience designing domaindriven data products with medallion architectureStrong exposure to enterprise governance models and operating frameworksProven leadership in multidomain multiteam delivery environmentsRole Variants for proposal structuringSenior Data Architect Snowflake DBTLead Data Architect Enterprise Data PlatformPrincipal Data Architect Solution Architect