Senior Snowflake & Data Modeling Engineer

Hays
31 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Tech stack

Airflow
Automation of Tests
Unit Testing
Continuous Integration
Data Architecture
Data Governance
Data Structures
Data Vault Modeling
Data Warehousing
Python
SQL Databases
Data Logging
Snowflake
GIT
Software Version Control

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...

Apply for this position