Snowflake Engineer / Architect

About the role

We are looking for a Snowflake Engineer / Architect to join our fast‑paced consulting team. You will design, build, and deploy Data Cloud solutions, applying best‑practice methodologies for our government and enterprise clients.

Key responsibilities

• Participate in agile project teams, delivering Snowflake‑based data solutions and ensuring high‑quality deliverables.
• Design, develop, and operate large‑scale data lake systems on Microsoft Azure, integrating Snowflake innovations and open‑source tools.
• Provide Snowflake subject‑matter expertise, including resource monitors, RBAC, virtual warehouses, query tuning, zero‑copy clone, and time‑travel features.
• Collaborate with project managers to create detailed plans, anticipate roadblocks, and keep projects on track.

Required profile

• Proven experience assessing, designing, and deploying Snowflake ecosystems and large‑scale data‑intensive systems.
• Hands‑on expertise with Snowflake data modeling, ELT (Snowpipe), Azure Data Factory, Apache NiFi, and DBT.
• Experience in data migration to Snowflake, building data pipelines for batch and streaming workloads, and establishing data‑quality processes.
• Background in Microsoft Azure, Python, Java, C++, and SQL, with knowledge of cloud IaaS/PaaS, micro‑services, containers, DevSecOps, and ML/AI.

Required skills

• Snowflake (resource monitors, RBAC, virtual warehouses, query tuning, zero‑copy clone, time travel)
• Azure Data Factory, Apache NiFi, Snowpipe, DBT
• Data modeling, ELT/ETL design, data migration
• Python, Java, C++, SQL
• Microsoft Azure cloud services
• Data governance, data lake, data warehouse concepts