Data Build Tool Developer

Summary

Join a leading provider of enterprise-class managed data center services as a Snowflake DBT Developer. You will play a key role in migrating their data infrastructure from T-SQL to Snowflake, leveraging DBT and AI to optimize data transformations. This position offers the opportunity to work with cutting-edge technologies, drive data-driven decision making, and contribute to a collaborative and innovative team.

Requirements

• 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

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

Preferred Qualifications

• 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