N Consulting Global
Snowflake Consultant
London
Posted about 17 hours ago
How your CV stacks up
1Upload CV
2Analyse CV
3Improve CV
Upload your CV to see how well it fits this job role
?%
Role: Snowflake Consultant
Location: London
Permanent Role
Work Mode: Remote with occasional office visit
Key Responsibilities
- Design and implement Snowflake data warehouse and cloud data platform solutions.
- Develop scalable data models, schemas, tables, views, stored procedures, and SQL queries.
- Perform data migration from legacy/on-premise platforms to Snowflake.
- Develop and optimise ETL/ELT pipelines for ingestion and transformation.
- Work with large datasets and optimise Snowflake performance and query execution.
- Implement Snowflake security, including RBAC, roles, privileges, masking and data access policies.
- Configure and manage Snowflake warehouses, databases, schemas and resource utilisation.
- Implement Snowflake Streams, Tasks, Snowpipe and Dynamic Tables where appropriate.
- Integrate Snowflake with cloud services and data integration platforms.
- Work with AWS/Azure/GCP data services and cloud storage.
- Develop data solutions using SQL and Python.
- Monitor and troubleshoot data pipelines, performance and data quality issues.
- Support data governance, metadata management and compliance requirements.
- Collaborate with Data Architects, Data Engineers, BI Developers and business stakeholders.
- Provide technical documentation and support knowledge transfer to development teams.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Mandatory Skills
- Strong hands-on experience with Snowflake.
- Excellent SQL skills.
- Strong understanding of cloud data warehousing and data lake architectures.
- Experience in ETL/ELT development and data migration.
- Experience with Snowflake performance tuning and optimisation.
- Strong knowledge of Snowflake security and RBAC.
- Experience with Snowflake Streams, Tasks, Snowpipe and Dynamic Tables.
- Good understanding of data modelling, including dimensional modelling.
- Experience with Python for data engineering/automation.
- Experience with at least one major cloud platform: AWS, Azure or GCP.
- Experience with data integration tools such as Azure Data Factory, Informatica, Matillion, Talend or similar.
- Strong understanding of data quality, governance and lineage.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Desirable Skills
- Experience with dbt and modern ELT frameworks.
- Experience with Apache Airflow or similar orchestration tools.
- Knowledge of Kafka or other real-time data ingestion technologies.
- Experience with Power BI, Tableau or other BI platforms.
- Knowledge of CI/CD and DevOps practices for data platforms.
- Snowflake certifications would be advantageous.
Trusted by 25,000+ job seekers
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Snowflake
SQL
Python
ETL/ELT
Data Modeling
Cloud Data Warehousing
RBAC
Snowpipe
AWS
Azure
GCP
Data Migration
Performance Tuning
Data Governance
dbt
Apache Airflow
Location