18 Nov
|
Blumetra Solutions
|
Hyderabad
18 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 recent 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
• Strong 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 (Hyderabad)
🏢 Blumetra Solutions
📍 Hyderabad