Implement and manage data modelling techniques, including OLTP, OLAP, and Data Vault 2.0 methodologies.
Write optimised SQL queries for data extraction, transformation, and loading.
Utilise Python for advanced data processing, automation tasks, and system integration.
Be an advisor with your In-depth knowledge of Snowflake architecture, features, and best practices.
Develop and maintain complex data pipelines and ETL processes in Snowflake.
Collaborate with data architects, analysts, and stakeholders to design optimal and scalable data solutions.
Automate DBT Jobs & build CI/CD pipelines using Azure DevOps for seamless deployment of data solutions.
Ensure data quality, integrity, and compliance throughout the data lifecycle.
Troubleshoot, optimize, and enhance existing data processes and queries for performance improvements.
Document data models, processes, and workflows clearly for future reference and knowledge sharing.
Build Data tests, Unit tests and mock data frameworks
Good to have AWS and Streamlit knowledge