Senior Data Engineer - Snowflake & Python Automation

Our client is a forward-thinking retail organisation leveraging data engineering to drive business decisions and analytics at scale. They're building a modern data infrastructure using industry-leading technologies including Snowflake, DBT, and cloud platforms. The company focuses on innovation, technical excellence, and collaborative problem-solving in retail operations data analytics.

• 8-10 years of experience in data engineering roles
• Deep understanding of Snowflake RBAC structure including roles, grants, and privileges
• Strong proficiency in Python for automation and data processing
• Advanced SQL and PL/SQL skills including query optimisation
• Hands-on experience with DBT for data transformation workflows
• Knowledge of AWS or Azure cloud platforms and data services
• Experience implementing ETL/ELT processes and data pipeline development
• Understanding of data modelling techniques including Data Vault methodology
• Familiarity with Git version control for configuration management
• Experience with data governance, quality assurance, and security compliance
• Ability to mentor team members and lead technical discussions
• Strong collaboration skills across technical and business teams
• Problem-solving mindset focused on continuous improvement

• Design and build scalable data pipelines using Snowflake, Python, and DBT
• Lead migration and automation of RBAC roles using configuration-driven approaches
• Collaborate with data architects, product managers, and data scientists on analytics solutions
• Mentor junior engineers and lead technical discussions
• Extract and analyse RBAC roles and metadata from Snowflake environments
• Develop Python scripts to automate role extraction, transformation, validation, and deployment
• Build, optimise, and maintain ETL pipelines ensuring data quality
• Monitor and troubleshoot production data pipelines for performance and reliability
• Write and optimise SQL and PL/SQL queries
• Implement Data Vault models in Snowflake supporting large-scale analytics and BI
• Engage with business stakeholders to translate requirements into technical solutions
• Implement data governance and quality assurance processes
• Work with AWS/Azure and DBT to maintain scalable cloud data solutions
• Identify opportunities to improve data systems, processes, and tools for efficiency