Senior Snowflake & Data Modeling Engineer
Role details
Job location
Tech stack
Requirements
Bewaar Senior Snowflake & Data Modeling Engineer ZZP | Snowflake Data Engineer | Data Modeling | Hybrid We're looking for a senior data engineer with deep experience in modern data warehousing and data modeling. You'll play a key role in designing, maintaining, and improving our Snowflake environment, dbt models, and related infrastructure that together form the analytical and reporting backbone of our organization. What you'll do * Design and maintain high-quality Data Vault-based models in Snowflake, serving as the foundation for downstream reporting. * Apply a solid understanding of data architecture and warehouse design principles, using Kimball and Inmon as reference frameworks. * Build robust dbt transformations, incorporating testing, documentation, and clear lineage. * Implement data quality and unit testing within dbt to ensure model reliability and prevent regressions. * Write and maintain custom dbt macros and Python scripts to improve automation, consistency, and maintainability. * Collaborate closely with business and technical stakeholders to translate domain knowledge into scalable data structures. * Contribute to CI/CD best practices, ensuring reproducible and validated deployments. * Foster a culture of technical craftsmanship, knowledge sharing, and long-term maintainability. Required skills * Strong, hands-on experience with Snowflake, dbt, and Git-based version control. * Proficiency in SQL and Python, including the ability to write dbt macros and automation scripts. * Experience with CI/CD pipelines and Airflow for orchestrating and validating data workflows, including observability through metrics, logging, and alerting. * Deep understanding of data modeling concepts, including Data Vault, Kimball, and Inmon approaches. * Experience implementing dbt testing (contract, data, and unit tests) to guarantee accuracy and integrity. * Awareness of data governance and management principles (e.g. DA...