JOBSEARCHER

Data Architect – Snowflake and Azure

Job Summary: We are seeking a Senior Data Architect with extensive enterprise data architecture experience and deep, hands-on Snowflake expertise to lead the design of scalable, secure, and high-performing cloud data platforms. The ideal candidate will have personally owned architecture decisions, platform blueprints, data models, integration patterns, governance standards, and technology roadmaps. Experience must extend beyond ETL development to include end-to-end platform architecture and Snowflake design ownership.
Key Responsibilities: Own enterprise data architecture from business requirements and current-state assessment through target-state design and implementation oversight. Design Snowflake platforms covering ingestion, storage, transformation, data modeling, security, data sharing, and analytics consumption. Define Snowflake database and schema structures, virtual warehouse strategies, workload isolation, and environment standards. Lead Snowflake performance and cost optimization through query analysis, warehouse sizing, clustering strategies, and resource monitoring. Establish architecture patterns for batch, incremental, CDC, and near-real-time data integration using Matillion and Azure services. Design data warehouse, data lake, and lakehouse solutions across Snowflake, Azure, and Microsoft Fabric. Define conceptual, logical, and physical data models, including dimensional models and shared enterprise data definitions. Embed governance, data quality, lineage, classification, masking, role-based access controls, and privacy requirements into platform designs. Produce architecture diagrams, solution blueprints, architecture decision records, and high- and low-level design documents. Lead architecture reviews, evaluate technology options, and explain trade-offs involving scalability, reliability, security, cost, and maintainability. Partner with business stakeholders, Enterprise Architecture, engineering, infrastructure, application teams, and vendors. Define platform roadmaps and provide technical oversight and mentoring throughout delivery. Support architectures for advanced analytics, AI/ML, MCP, and Generative AI use cases.