At a Glance
- Tasks: Design and maintain scalable cloud data solutions using Snowflake for enterprise analytics.
- Company: Join Synechron, a leader in digital transformation within banking and financial services.
- Benefits: Enjoy hybrid work, flexible arrangements, and opportunities for professional growth.
- Other info: Diversity-focused workplace with mentoring and development programmes.
- Why this job: Make an impact with cutting-edge technology in a collaborative environment.
- Qualifications: 5-10 years of Snowflake experience and strong SQL skills required.
The predicted salary is between 60000 - 80000 € per year.
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 (e.g., 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.
- 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.
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.
Senior Snowflake Engineer in Glasgow employer: Synechron
Synechron is an exceptional employer that champions innovation and collaboration in the heart of Glasgow. With a strong commitment to employee growth through mentoring and development programmes, we foster a dynamic work culture that values diversity and inclusion. Our hybrid work model allows for flexibility while engaging in cutting-edge projects within the banking and financial services sector, making it a rewarding environment for skilled professionals seeking meaningful contributions.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Snowflake Engineer in Glasgow
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even just grab a coffee with someone who works at Synechron. Building relationships can open doors that a CV just can't.
✨Show Off Your Skills
When you get the chance to chat with potential employers, don’t hold back! Share your experiences with Snowflake, data modelling, and any cool projects you've worked on. Let them see your passion for tech and problem-solving.
✨Prepare for the Interview
Do your homework on Synechron and the role. Understand their values and how your skills align with their needs. Prepare some questions to show you're genuinely interested in the company and the position.
✨Apply Through Our Website
Don’t forget to apply directly through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about joining the team at Synechron.
We think you need these skills to ace Senior Snowflake Engineer in Glasgow
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Senior Snowflake Engineer role. Highlight your experience with Snowflake, SQL optimisation, and data modelling. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your background in banking or financial services makes you a great fit. Let us know what excites you about working with us at Synechron.
Showcase Your Projects:If you've worked on relevant projects, don't hold back! Include specific examples of data pipelines you've built or optimisations you've made. We love seeing real-world applications of your skills, so share those success stories with us.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, it shows us you're serious about joining our team at Synechron!
How to prepare for a job interview at Synechron
✨Know Your Snowflake Inside Out
Make sure you brush up on your Snowflake knowledge before the interview. Understand its architecture, features, and best practices for data modelling and performance optimisation. Being able to discuss specific use cases or challenges you've faced with Snowflake will show your expertise.
✨SQL Skills Are Key
Since advanced SQL and query optimisation are crucial for this role, practice writing and optimising SQL queries. Be prepared to demonstrate your skills during the interview, perhaps by solving a problem on the spot or discussing how you've improved query performance in past projects.
✨Showcase Your Automation Experience
Familiarity with tools like Apache Airflow is a big plus. Be ready to talk about any automation workflows you've implemented, especially those involving CI/CD pipelines. Highlight how these experiences have improved efficiency and reliability in your previous roles.
✨Collaboration Is Key
This role involves working with cross-functional teams, so be prepared to discuss your experience collaborating with data analysts, BI developers, and business stakeholders. Share examples of how you've successfully communicated technical concepts to non-technical team members to ensure everyone is on the same page.
