Data Engineer (Snowflake)

Key Responsibilities

Design, build, and operate end-to-end data pipelines (ingestion → transformation → serving) on Databricks and/or Snowflake, following medallion/layered architecture patterns

Configure and administer workspaces/accounts - compute policies, resource sizing, environment setup, and access hierarchy - per the SDP reference architecture

Implement data governance controls: catalogue and schema design, RBAC, row/column-level security, data masking, and lineage tracking

Set up CI/CD and infrastructure-as-code for pipeline deployment and environment promotion (dev → test → prod)

Configure monitoring, telemetry, and audit logging to meet SDP's central observability and security posture requirements

Support UAT, integration testing, and parallel-run validation during migration and go-live

Produce handover documentation (runbooks, access lists, escalation procedures) for agency operations teams

Work directly with GovTech's SDP Central Team, agency stakeholders, and Principal (Databricks/Snowflake) solution architects throughout delivery

Required Technical Skills - Snowflake

Virtual warehouse sizing, scaling, and cost/performance tuning

Snow pipe and Snow pipe Streaming for continuous ingestion

Snow park (Python/Scala) for in-warehouse data engineering

Role-based access control (RBAC), secure data sharing, and object tagging for governance

Query profiling and performance optimization (clustering keys, materialized views, caching)

Time Travel, zero-copy cloning, and Snowflake's native data protection features

Minimum 5 years of hands-on experience in Data Engineering, Data Platform Engineering, or related disciplines.

Minimum 3 years of hands-on experience with Snowflakes involving data pipeline

Required Technical Skills - Common

Strong SQL and Python (PySpark or general-purpose) for data engineering

Data modeling - dimensional design, star/snowflake schemas, semantic layers

CI/CD pipelines (e.g., Azure DevOps, GitHub Actions, GitLab CI) for data engineering workflows

Infrastructure-as-code (Terraform preferred) for provisioning cloud data platform resources

Hands-on experience on at least one hyper scaler - AWS, Azure, or Google Cloud

Understanding of data security and compliance frameworks applicable to government/public-sector environments

Preferred Qualifications

Databricks Certified Data Engineer Associate/Professional

Snow Pro Core, or Snow Pro Advanced: Data Engineer

Prior experience delivering on a government or regulated-sector data platform, or exposure to compliance frameworks such as IM8 is an add o n

Experience working as part of a System Integrator (SI) delivery team alongside a platform Principal is an add on