19 Nov
|
Blumetra Solutions
|
Hyderabad
19 Nov
Blumetra Solutions
Hyderabad
Position: Snowflake Platform Engineer – Security, Auditing & Alerting
Experience: 6–8 years
Location: Hyderabad
Employment type: Full time
Work timings: 3:00 PM to 12:00 AM IST (8 productive hours a day)
Job Summary
We are looking for a Snowflake Platform Engineer with 6–8 years of experience to support a US-based retail customer's data platform: Snowflake, Fivetran, PopSink, Windmill, Prefect, Azure DevOps and Azure services. The role owns single sign-on (SSO), SCIM, access control, auditing and alerting across these platforms. Most of the work is hands-on Snowflake, SQL, dbt and Python, combined with guiding the customer's administrators and coordinating with vendors.
Key responsibilities
- Prepare step-by-step implementation guides from vendor documentation for SSO, SCIM, access control, auditing and alerting, and walk the customer's administrators through them until implemented.
- Land application audit and event data in Snowflake using native or managed connectors (PopSink, Fivetran) where available, and Python or dlt only where none exists.
- Write SQL, maintained as dbt views in Git, over the event and audit tables in Snowflake to detect what needs attention.
- Configure scheduled summary notifications by priority (for example P1 every 15 minutes, P2 every 30 minutes, P3 and information hourly) through the team's YAML-based notification framework, raising ServiceNow incidents by email.
- Set up and validate auditing in Snowflake (ACCOUNT_USAGE views) and the equivalent features in other platforms.
- Automate SSO certificate and SCIM token expiry notifications from data in Snowflake, and automate renewals where the platform supports it.
- Extend the same SSO, access, auditing and alerting standards to Azure services (Blob Storage, Service Bus, Functions), SharePoint and new Snowflake applications as they are onboarded.
- Support Snowflake and dbt CI/CD using Azure DevOps repositories, boards and pipelines.
- Prepare technical designs, and review new applications built on Snowflake for access control, auditing and alerting.
- Coordinate with SaaS vendors on limitations, roadmaps and support, and flag dependencies and customer asks before committing dates.
- For each task, share a short plan with dates up front (requirements, research, implementation, production), then report against it daily.
- Test and capture evidence before sign-off.
Required Skills And Qualifications
- Robust Snowflake: SQL, roles and access control, tasks, stored procedures, ACCOUNT_USAGE views, alerts and notification integrations.
- dbt for Snowflake models and views, maintained in Git.
- Strong Python for integrations: REST APIs, JSON, pagination, incremental loads and error handling.
- ELT tools such as Fivetran or dlt.
- Understanding of SSO (SAML / OIDC), SCIM and role-based access, enough to guide administrators.
- Azure DevOps: Git repositories, boards and CI/CD pipelines.
- Good communication, and confidence walking customers and vendors through technical steps.
Good to have
- Windmill, Prefect or Airflow orchestration.
- PowerShell, Azure Automation and Microsoft Graph API.
- ServiceNow integrations and Fivetran administration.
- Azure Blob Storage, Service Bus and Functions.
- Snowflake hybrid tables, Snowflake Native Apps or Streamlit in Snowflake.
- SnowPro certification.
Education
- Bachelor's degree in Computer Science, Information Technology, or a related discipline.
Ideal candidate profile
- Independently researches a platform, plans the work with dates, prepares the steps and sees them through to sign-off.
- Practical implementation experience, not just theoretical knowledge.
- Comfortable with customer-facing calls and the 3:00 PM to 12:00 AM IST shift.
Skills: snowflake,python,sql
📌 Snowflake Platform Engineer – Security, Auditing & Alerting (Hyderabad)
🏢 Blumetra Solutions
📍 Hyderabad