Snowflake DBT Developer

Our client provides enterprise-class managed data center services. They have around 70 datacenters servicing 29 different markets, and we can't disclose their clients – but think about any significant industry player from hyperscalers, banks, healthcare and social media platforms, and they're likely in their CRM. We're looking for a talented, proactive Snowflake DBT Developer to join their team. You'll help create strategies and implementation plans for data transformation projects, lead their migration from T-SQL to DBT-powered Snowflake environments, and utilize AI to enhance these transformations. This position offers an exciting chance to drive their AI-powered data evolution.

Your responsibilities:

• Design and implement migration strategies to convert complex T-SQL procedures to DBT models in Snowflake.
• Create efficient data transformation workflows with DBT Core, applying modular programming principles.
• Develop optimized data models using Snowflake's Dynamic Tables and custom functions.
• Structure data using dimensional modeling concepts for better analytical performance.
• Integrate AI into transformation pipelines, focusing on pattern recognition and code automation.
• Build and test prototypes to validate approaches before full implementation.
• Document data lineage, transformation logic, and architectural decisions.
• Develop analytical dashboards in Sigma to demonstrate business value.
• Engage directly with stakeholders to gather requirements and provide updates.
• Explain technical concepts in business terms when discussing project status.

Requirements for this role:

• A minimum of 5 years of confirmed experience as a Snowflake DBT Developer, showcasing a proven ability to spearhead initiatives.
• Expert- level knowledge of T- SQL architecture, incorporating stored procedures, functions, and intricate view hierarchies.
• Strong expertise in adapting traditional SQL practices to DBT Core methodologies, ensuring effective implementation of models, macros, and tests.
• In-depth knowledge of dimensional data modeling, specifically in executing Fact and Dimension models within contemporary data warehouse settings.
• Practical experience with Snowflake' s advanced features, such as Dynamic Tables, User-Defined Functions, and micro-partitioning.
• Proven success in migrating enterprise databases from MSSQL Server to Snowflake, adeptly managing complex data types and optimizing for cloud efficiency.
• Experience integrating AI tools and frameworks to enhance data transformation workflows.
• Excellent project management abilities, capable of guiding initiatives from their inception to completion.
• Outstanding communication skills to effectively connect with both technical teams and business stakeholders.
• Strong analytical and problem-solving capabilities, with an emphasis on attention to detail.
• Superior verbal and written communication skills, enabling clear explanations of complex technical concepts to non-technical audiences.
• A demonstrated eagerness for continuous learning and staying updated with new data technologies and methodologies.

Bonus points for:

• A practical understanding of Snowflake' s AI features and applications for real- world business scenarios will be highly appreciated.
• Experience with visualization tools, particularly Sigma, is strongly preferred.
• Basic knowledge of software development principles and web application architecture.
• Familiarity with CI/CD pipelines for DBT deployments.
• Experience with version control systems and collaborative development processes.
• Skilled in leading data-centric workshops and requirements-gathering sessions.
• A proven history of self- directed learning and skill enhancement.

We offer the opportunity to work with modern data technologies and solve complex data challenges. This client prioritizes their people through investments in growth and development while encouraging decision-making and calculated risk-taking. Their culture thrives on open communication and diverse perspectives, creating a true community of professionals who work together effectively to solve complex challenges and deliver outstanding results. How good does this sound? Hopefully enough to fill out the form below to apply!