Snowflake Database Developer

About Us

Paragon Customer Communications (PCC) is a leader in customer communication solutions, serving top brands across Retail, Banking, Insurance, and Government sectors in the UK and Europe. With 13 operating sites in the UK and a distributed, collaborative team, we deliver secure, scalable, and innovative platforms that drive meaningful connections between our clients and their customers.

Our data mart and warehouse platform, primarily built on Snowflake, integrates data from multiple systems and platforms to enable insightful reporting and analytics. As we continue to evolve, we are looking to build a strong development team to enhance and optimize our data operations.

Role Overview

We are seeking a Snowflake Data Warehouse Developer to play a pivotal role in designing, implementing, and optimizing our Snowflake-based data warehouse. You will work on developing robust data models, optimizing performance, automating data pipelines, and ensuring best practices for data management. This role requires strong SQL expertise, experience in data warehousing concepts, and a deep understanding of Snowflake’s capabilities.

Must also work closely with all technical areas of the business as well as client facing teams and ensure that all solution and proposition deliveries are being fit for purpose, designed in-line with the overall company’s technology strategy in mind, and delivered on time and budget, satisfying client requirements and the market need.

Key Responsibilities

• Design, develop, and optimize Snowflake data warehouse solutions.
• Implement best practices for data modelling , schema design , and performance tuning .
• Develop and maintain efficient ETL / ELT pipelines using SQL and scripting tools.
• Optimize query performance and manage clustering, partitioning, and indexing strategies.
• Integrate Snowflake with multiple data sources including Oracle, SQL Server, and MySQL .
• Automate data workflows, implement data governance strategies, and ensure data quality.
• Work closely with analysts, engineers, and business stakeholders to define data requirements.
• Leverage Snowflake-specific features such as streams, tasks, stored procedures, and materialized views.
• Ensure data security, access controls, and compliance with organizational policies.
• Document technical solutions, data processes, and architectural decisions.
• Optimize and enhance existing ETL processes and explore new tools for efficiency improvements.
• Troubleshoot and resolve data quality and performance issues.

Key Skills & Experience

Desirable Skills