Data Architect Snowflake Medallion Architect - Orlando FL / Seattle WA / Burbank CA (Onsite)

Position:

Data Architect Snowflake Medallion Architect

Duration:

12+ months - contract

Location:

Orlando FL / Seattle WA / Burbank CA (Onsite)

JOB DESCRIPTION SKILLS NEEDED

: Snowflake architecture, Medallion Architect We 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 layers The role will drive endtoend data architecture governance and solution design ensuring scalable secure and businessaligned 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 costefficient Snowflakebased 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 starsnowflake 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 Businessready curated datasets Gold 4 Snowflake Platform Architecture Architect Snowflake solutions leveraging Virtual Warehouses RBAC data sharing Data governance and security features masking rowlevel 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 DBTbased 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 Core 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 Masters degree in Computer Science Data Engineering or related discipline Preferred Profile Proposal Positioning Experience designing domaindriven data products with medallion architecture Strong exposure to enterprise governance models and operating frameworks Proven leadership in multidomain multiteam delivery environments Role Variants for proposal structuring Senior Data Architect Snowflake DBT Lead Data Architect Enterprise Data Platform Principal Data Architect Solution Architect