Data Operations Consultant (Snowflake)
Vivanti Consulting
About the job
Your Career, Accelerated
You’ve got the skills. The curiosity. The hunger to grow, try new things and make a real impact. We’re a growing global tech consultancy. Some of the world’s biggest businesses turn to us to help bring their data, AI, cloud and digital solutions to life.
We’re the home base for talented technologists who want more and are looking to take their career to the next level by having more learning, more variety, more support and more chances to do meaningful work. If that sounds like the kind of place you’d thrive in, keep reading.
Life at Vivanti
Our people are the lifeblood of our business. At our core - we want people who are deeply curious about technology, willing to have a go and have a voice to solve our customer's most complex business problems.
We value breadth at Vivanti - we know that no business is the same. We believe the best technologists have a few deep skills, but love to explore new tools. This means, regardless of what curveballs get thrown at us, we'll always be able to solve the problem.
We also love to have fun - even our senior folks are techies at heart and we want to have a great time as we go on this journey together.
What You’ll Do
- Observability: Monitor Snowflake queries, warehouses, tasks, loads, and account health; detect and resolve operational issues.
- FinOps: Monitor credit consumption, storage, and warehouse costs; optimize sizing, auto-suspend, and resource monitors.
- User Management: Manage Snowflake users, roles, onboarding, offboarding, and role-based access controls.
- Privilege Access Management: Review grants, privileged roles, access policies, and audit logs to enforce least privilege.
- Platform Maintenance: Maintain Snowflake account settings, integrations, and operational health checks.
- Service Desk Management: Triage incidents and service requests; investigate query, access, and platform issues.
- Enhancements: Deliver improvements to Snowflake configuration, automation, and operational processes.
- Business Continuity Planning: Support backup, retention, Time Travel, Fail-safe, and recovery procedures.
- Deployment Services: Support controlled releases of Snowflake objects, roles, scripts, and configurations via CI/CD.
- Data Load Fixes: Troubleshoot Snowpipe, COPY, stages, file formats, connectivity, and scheduled loading failures.
- Transformations/Data Model Support: Provide first-line triage for failed tasks, SQL errors, and schema changes.
- Functional Data Questions: Investigate initial data availability and quality issues; coordinate with data owners.
- Project Support: Assist engineering teams with Snowflake environments, integrations, and migrations.
- Documentation: Maintain runbooks, access procedures, operational guides, and knowledge base articles.
What We Are Looking For
- 5+ years of experience in data platform administration, operations, or production support, including Snowflake.
- Hands-on Snowflake administration: RBAC, virtual warehouses, query history, performance tuning, and cost controls.
- Experience with Snowflake data loading, stages, tasks, Snowpipe, and cloud services such as AWS or Azure.
- Familiarity with ITSM, Jira, SQL, CI/CD, and monitoring or automation tools.
- Strong troubleshooting, documentation, communication, and stakeholder management skills.