Job Title : Snowflake Administrator with DBT
Location : Remote
Experience Required : 5 7 Years (with minimum 4 years in DBT)
Job Summary :
We are seeking an experienced Snowflake Administrator with strong DBT expertise to join our data engineering team. The ideal candidate will be responsible for administering Snowflake environments, optimizing performance, ensuring data security, and developing DBT models to support business reporting and analytics.
Key Responsibilities :
- Administer and manage Snowflake data warehouse environments, including user management, roles, and permissions.
- Monitor and optimize Snowflake performance, query tuning, and resource usage.
- Implement data security best practices, including access control, data masking, and encryption.
- Develop, maintain, and optimize DBT models, transformations, and workflows.
- Manage and automate DBT project deployments, testing, and documentation.
- Collaborate with data engineers, analysts, and business stakeholders to design scalable and reliable data pipelines.
- Troubleshoot Snowflake and DBT issues, ensuring high availability and system reliability.
- Stay updated with the latest Snowflake and DBT features, recommending improvements for adoption.
Required Skills & Qualifications :
5 to 7 years of total experience in Data Engineering / Data Warehousing.4+ years of hands-on experience with DBT (developing models, testing, documentation, and deployment).Strong expertise in Snowflake administration, including roles, warehouses, resource monitors, and performance tuning.Proficiency in SQL and data modeling concepts.Experience with CI / CD pipelines for DBT (Git, DBT Cloud, or other orchestration tools).Familiarity with data governance, security, and compliance practices.Excellent problem-solving and communication skills.Ability to work independently in a remote, distributed team environment.Preferred Skills (Nice to Have) :
Experience with cloud platforms (AWS, Azure, or GCP).Knowledge of Python or other scripting languages for automation.Exposure to Airflow, Fivetran, or other ELT / ETL tools.Certification in Snowflake or DBT.(ref : hirist.tech)