Snowflake & SQL Server Developer in London

Snowflake & SQL Server Developer in London

London Full-Time 46800 - 55000 £ / year (est.) Hybrid
N

At a Glance

  • Tasks: Support and enhance data platforms using Snowflake and SQL Server.
  • Company: Dynamic tech company based in London with a hybrid work model.
  • Benefits: Competitive pay, flexible working, and opportunities for professional growth.
  • Other info: Exciting role with potential for long-term career development.
  • Why this job: Join a team driving data innovation and optimisation in a collaborative environment.
  • Qualifications: Hands-on experience with Snowflake, SQL Server, and ETL processes required.

The predicted salary is between 46800 - 55000 £ per year.

We are looking for a Snowflake & SQL Server Developer to support and enhance our data platforms. The role involves maintaining existing systems, ensuring governance and compliance, and driving data migration and optimization initiatives across Snowflake, SQL Server, and related technologies.

Key Responsibilities

  • Database Management & Support
    • Administer and maintain Snowflake and SQL Server environments.
    • Handle incident, problem, and change management processes.
    • Monitor daily data operations and movements across Oracle, SQL Server, Snowflake, and Kafka.
    • Manage deployments, DR events, and RTL support.
  • Development & Optimization
    • Build and support ETL processes using SQL Server, SSIS, and Snowflake.
    • Optimize database and server performance.
    • Implement table partitioning, archiving, and purging frameworks.
    • Develop and maintain file loading and automation frameworks.
    • Minimize Azure SQL DB dependencies by migrating data into Snowflake.
  • Migration & Integration
    • Support ODS/Oracle to Snowflake migration (via ODI).
    • Manage CRM and DR data migrations to Snowflake.
    • Maintain and migrate legacy SSIS jobs; support server decommissioning.
    • Support third-party integrations across multiple tools.
  • Governance & Security
    • Implement and monitor user access frameworks, roles, and permissions.
    • Manage data protection, compliance, and auditing procedures.
    • Prepare and maintain configuration and documentation standards.
  • Monitoring & Reporting
    • Develop observability solutions using Datadog dashboards.
    • Monitor storage usage, costs, and optimization opportunities.
    • Produce daily health reports and database monitoring alerts.

Required Skills & Experience

  • Strong hands-on knowledge of Snowflake and SQL Server (including SSIS).
  • Experience in ETL, data migration, and performance optimization.
  • Familiarity with Oracle, Kafka, ODI, and Azure SQL DB.
  • Proven ability in incident, problem, and change management.
  • Good understanding of data governance, security, and auditing frameworks.
  • Exposure to monitoring and observability tools (e.g., Datadog).

Snowflake & SQL Server Developer in London employer: N Consulting Ltd

As a Remote Java Developer with Microservices at our Edinburgh-based company, you will thrive in a dynamic and inclusive work culture that prioritises innovation and collaboration. We offer competitive benefits, including flexible working arrangements and opportunities for professional development, ensuring you can grow your skills while contributing to impactful projects. Join us to be part of a forward-thinking team that values your expertise and fosters a supportive environment for career advancement.

N

Contact Details:

N Consulting Ltd Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Snowflake & SQL Server Developer in London

✨Tap into Local Tech Meetups

Get yourself to local tech meetups or database management conferences. It's a really great way to meet industry professionals and potentially uncover unadvertised full-time roles. When chatting with people, mention your skills and interests in database management; you never know who might be looking for someone just like you!

✨Contribute to Open Source Projects

Diving into open-source projects can not only sharpen your database skills but also get you noticed by employers. Many companies look for candidates who actively contribute to projects – it shows initiative and a real passion for the field. Plus, it's a perfect excuse to connect with other developers and expand your professional network.

✨Utilise Professional Bodies

Sign up for professional bodies related to database management, like the British Computer Society. They often host events and networking opportunities that can lead directly to job openings in the full-time market. Plus, it adds a nice touch to your professional profile!

✨Showcase Your Skills in a Public Portfolio

As you’re on the hunt for that full-time role, make sure to have a public portfolio that displays your best database projects. This can easily set you apart from the competition. And when you apply for roles, definitely mention it – it shows employers you mean business and are proud of your work!

We think you need these skills to ace Snowflake & SQL Server Developer in London

Snowflake
SQL Server
SSIS
ETL Processes
Data Migration
Performance Optimization
Oracle

Some tips for your application 🫡

Show off your database skills:When applying for a full-time role in database management, it’s super important to highlight your skills with specific database technologies like SQL, NoSQL, or any relevant data visualisation tools. We want to see how you've used these tools in real projects, so don't shy away from detailing your hands-on experience!

Tailor your CV for data:Make sure your CV is structured clearly, focusing on your previous experience in database management. Use specific metrics to demonstrate your impact, like how you improved data retrieval times or reduced errors. This isn't just about what you've done; it’s about what you’ve achieved with your skills!

Craft a compelling cover letter:In your cover letter, share what excites you about database management and how you can contribute to N Consulting Ltd. Mention any relevant projects where you tackled challenges or implemented new solutions. Let us know why you want to join our team and how your passion aligns with our goals.

Document your projects:If you've worked on interesting database projects—maybe during your studies or in previous roles—be sure to include those in your application. If you can, link to a portfolio or GitHub repo where we can see examples of your work. Having a tangible showcase of your skills will really make your application stand out!

How to prepare for a job interview at N Consulting Ltd

✨Brush Up on Database Tools

Make sure you're well-versed with popular database management systems like MySQL, PostgreSQL, or MongoDB. Incorporating real-world examples of how you've used these tools in past projects will show that you can put theory into practice, which is something N Consulting Ltd will definitely appreciate.

✨Know Your SQL Inside Out

Get ready for some technical questions focused on SQL queries and database design. We should anticipate coding challenges where you might need to optimise queries or design a database schema on the spot. Practising these problems will build our confidence to impress in the interview.

✨Demonstrate Problem-Solving Skills

Besides just technical know-how, be prepared to answer scenario-based questions that test your critical thinking and problem-solving abilities. Think about how you would approach data integrity issues or handle performance bottlenecks — N Consulting Ltd will want to see your analytical side!

✨Show Your Collaboration Spirit

Since this is a full-time role, it's crucial to highlight how you've collaborated with cross-functional teams or contributed to team projects in the past. Emphasising our interpersonal skills will demonstrate that you’re not just a tech wizard, but also a team player who fits well with N Consulting Ltd's culture.