Senior Snowflake Engineer at Synechron, Glasgow, £Contract Rate

About Synechron:

Synechron is a leading digital transformation consulting firm dedicated to delivering innovative technology solutions within banking, financial services, and insurance. We thrive on engineering excellence, collaboration, and a passion for cutting-edge technologies.

Job Location: Glasgow (Hybrid - 3 days in the office)

We are looking for a skilled Snowflake Engineer to design, build, and maintain scalable cloud data solutions that support enterprise analytics and reporting. The role focuses on data migration, data modelling, automation, and performance optimisation within the Snowflake Cloud Data Platform.

Key Responsibilities

• Design, develop, and maintain data pipelines and data models in Snowflake to support analytics and reporting needs.
• Lead or support migration of Legacy data platforms (eg, Oracle) to Snowflake, ensuring data accuracy and business logic integrity.
• Convert and optimise SQL queries for Snowflake, improving performance and scalability.
• Design and implement dimensional data models (Star/Snowflake schemas) including Fact and Dimension tables.
• Develop and manage Snowflake Tasks, Streams, and stored procedures for automated data ingestion and transformations.
• Perform source-to-target data validation and reconciliation, including record counts, aggregates, and key business metrics.
• Implement and maintain INT-layer and semantic data models to standardise enterprise data for consistent reporting.
• Automate workflows using tools such as Apache Airflow and Git-based CI/CD pipelines, ensuring reliable and repeatable deployments.
• Support UAT and business validation using Snowflake features such as Zero-Copy Cloning for rapid environment provisioning.
• Collaborate with cross-functional teams, including data analysts, BI developers, and business stakeholders, to deliver trusted data solutions.
• Produce technical documentation, test cases, reconciliation reports, and audit artefacts to support governance and compliance.
• Provide BAU support, including incident resolution, performance tuning, and ongoing enhancements.

Required Skills & Experience

• Strong 5-10 years of hands-on experience with Snowflake Cloud Data Warehouse
• Advanced SQL and query optimisation skills
• Experience with data modelling (dimensional modelling, star schema)
• Familiarity with Apache Airflow or similar orchestration tools
• Experience with Python for data engineering tasks
• Knowledge of CI/CD and Git-based version control
• Understanding of data quality, reconciliation, and validation practices
• Experience in banking or financial services is an advantage

Diversity Statement

Synechron are proud to be an equal opportunity employer. Our Diversity, Equity, and Inclusion (DEI) initiative Same Difference' is committed to fostering an inclusive culture - promoting equality, diversity and an environment that is respectful to all. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We offer flexible workplace arrangements, mentoring, internal mobility, learning and development programmes to support our global workforce. Empowerment and collaboration are at the core of how we operate.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant's gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.