Snowflake Solution Architect - CoCo Data
Job Title: Snowflake Solution Architect - CoCo DataType of Engagement: FTE / Contract RoleLocation: Austin, TX (Hybrid)ResponsibilitiesDefine end-to-end data architecture covering data ingestion, transformation, storage, processing, analytics, and data consumption.Design and implement modern cloud data warehouse / data lakehouse architectures using Snowflake.Work with CoCo Data and Snowflake to design, integrate, and optimize enterprise data solutions.Define architecture and integration patterns between CoCo Data, Snowflake, cloud platforms, data pipelines, and downstream analytical applications.Design data ingestion and ELT/ETL solutions using technologies such as Snowpipe, Snowpipe Streaming, Streams, Tasks, Dynamic Tables, dbt, and cloud-native services.Develop enterprise data models, including dimensional modeling, analytical models, and scalable data structures.Provide architecture guidance for Snowflake security, RBAC, data governance, data masking, encryption, and access controls.Design integration solutions between Snowflake, CoCo Data, databases, APIs, data lakes, BI platforms, and enterprise applications.Lead data platform modernization and migration initiatives involving Snowflake and CoCo Data.Optimize Snowflake workloads for performance, scalability, availability, and cost efficiency.Collaborate with Data Engineers, Data Scientists, BI teams, Cloud Engineers, and business stakeholders to translate requirements into technical architecture.Establish architecture standards, reusable design patterns, data governance practices, and implementation best practices.Conduct architecture reviews, proof-of-concepts, technology evaluations, and technical design sessions.Qualifications8+ years of experience in Data Architecture, Solution Architecture, Data Engineering, or related fields.Required SkillsStrong enterprise-level experience with Snowflake architecture and implementation.Hands-on or strong working experience with CoCo Data.Experience integrating CoCo Data with Snowflake and enterprise data ecosystems.Strong understanding of modern data architecture, data warehousing, data lake/lakehouse, and ELT/ETL patterns.Strong SQL and data modeling experience.Experience with Snowflake Snowpipe, Streams, Tasks, Dynamic Tables, Snowpark, Time Travel, Zero-Copy Cloning, and Secure Data Sharing.Experience with AWS, Azure, or GCP cloud platforms.Strong understanding of data security, governance, metadata management, and access control.Experience with Snowflake performance tuning and cost optimization.Experience designing enterprise data integration and data pipeline architectures.Strong communication skills with the ability to work with technical and business stakeholders.Preferred SkillsPython / PySparkdbtApache SparkKafka / streaming technologiesAirflow or other orchestration toolsAWS / Azure / GCP data services