Contract role
Data Architect Snowflake Medallion Architecture
Location Tampa FL Onsite
Role Overview
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
1015 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 GCP
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
To apply for this job email your details to neha.chaudhary@compunnel.com