Senior Snowflake Platform Engineer

This is going to be a long-term project on a fully remote basis, however the Client is willing to consider only candidates in the Philippines (first priority) and also European countries and India!

The main responsibility will be implementing data pipelines in Snowflake and they need to be a promising Senior.

1. Snowflake SQL at an advanced level: RBAC, roles and grants, secure views, masking and row access policies, and administration of databases, schemas and warehouses.
2. Stored procedures and UDFs in Snowflake, both Python (Snowpark) and SQL: owner's vs. caller's rights, error handling, input validation and safe dynamic SQL.
3. dbt on Snowflake: models, macros, Jinja, tags and custom materializations, with a dbt project deployed and run natively in Snowflake (EXECUTE DBT PROJECT).
4. CI/CD with GitLab: pipelines, protected branches, merge request workflow with reviews and tests, promotion across DEV / UAT / PRD, and keyless authentication (workload identity federation / OIDC).
5. Python for automation, CI scripts and unit tests (pytest), with REST API integrations (e.g. GitLab, Jira).
6. Streamlit in Snowflake or other Snowflake-native apps (e.g. Snowflake App Runtime) for self-service portals and admin tools.
7. Snowflake data sharing: organizational listings, the Internal Marketplace, data products and secure shares.
8. Platform automation: tasks, streams and dynamic tables, plus monitoring of cost, usage and data quality from ACCOUNT_USAGE.
9. Data governance and security: least-privilege access, access request and approval flows, audit trails, and compliance with internal policies.
10. Nice to have: experience with Snowflake Openflow (Apache NiFi based) or similar data integration and ingestion tools, as well as Cortex AI (agents, AI functions).