Snowflake dbt Developer

Job Description

ABOUT VICTAULIC

Victaulic, headquartered in Easton, Pennsylvania, is the global leader in mechanical pipe joining solutions, delivering advanced technologies and engineering services to address complex piping challenges faced by engineers, site owners and contractors. Since 1919, our innovative solutions have improved construction productivity and reduced risks, ensuring projects are completed safely, on time, and within budget. With over 6,000 employees spanning 50+ locations worldwide, our teams are dedicated to delivering advanced technologies and engineering expertise that address real-world challenges across a wide range of industries. Our sustainable solutions, made from high quality, graded scrap steel, promote circular construction by making piping systems infinitely reconfigured and minimizing environmental impact. Today, our high-quality products are used in more than 140 countries, supporting some of the world's most critical and prestigious structures.

An Industry Leader With a Heart as Big as Its Ambition and Innovation

At Victaulic, we're committed to constructing a better world for and with our people.

Let's Build a Better World Together.

Our commitment to our people is built on four pillars:

• We build from within.

• We stand behind our people.

• We foster an environment for constant learning.

• We engineer change for a more stable and sustainable world.

YOUR IMPACT STARTS HERE

We're seeking a skilled Snowflake dbt Developer to join our growing IT team and build the dbt-based data transformations and Snowflake-native data applications that power reporting, integrations, and AI. This role will focus primarily on developing and extending our production dbt project across the medallion architecture, building the semantic models that power BI and AI consumption, and delivering user-facing solutions with Snowflake Streamlit. The ideal candidate is a hands-on developer with deep expertise in dbt and Snowflake, strong data modeling and SQL skills, a working understanding of data warehousing and lakehouse patterns, and experience building data applications for business users.

WHAT YOU'LL BUILD & OWN

dbt Transformation Development (50%)

• Develop, test, and maintain dbt models across the silver, gold, and platinum layers of the medallion architecture.

• Extend the production dbt project, including migrating remaining legacy transformation logic, such as Qlik Data Integration, into dbt.

• Build and maintain semantic-layer models in the consumption layer to support BI, integration, and AI consumers.

• Implement incremental models, snapshots, and materialization strategies optimized for Snowflake performance and cost.

• Author dbt tests, including generic, singular, and source freshness tests, and enforce layer contracts, naming conventions, and coding standards.

• Maintain dbt documentation, lineage, and exposures so downstream consumers can trust and trace data.

• Develop reusable macros and packages to standardize transformation patterns across subject areas.

• Participate in pull request reviews and follow the team's GitHub branching and release process for the dbt codebase.

• Troubleshoot and resolve dbt model failures, data quality issues, and performance bottlenecks.

• Partner with BI analysts and business stakeholders to translate reporting requirements into well-structured dbt models.

Snowflake Native Application Development (25%)

• Design and develop interactive data applications using Snowflake Streamlit for self-service analytics and operational workflows.

• Implement data-driven solutions leveraging Snowflake's native capabilities to enable business user productivity.

• Build applications that enable business users to interact with data through intuitive interfaces.

• Create reusable application frameworks and component libraries for rapid solution delivery.

• Integrate Snowflake Native Apps and third-party marketplace applications to extend platform capabilities.

• Develop custom UDFs and stored procedures to support advanced application logic and business rules.

Data Modeling and Platform Implementation (15%)

• Implement data models and pipelines that follow established bronze, silver, gold, and platinum medallion architecture standards.

• Apply data warehouse, data lake, and lakehouse patterns, including Apache Iceberg and other open table formats, as directed by the data architecture team.

• Implement secure data sharing solutions using Snowflake Marketplace and data sharing capabilities.

• Process semi-structured data, including JSON, Parquet, and Avro, into well-modeled, consumable structures.

• Optimize query performance, clustering, and warehouse usage for dbt workloads and applications.

• Contribute recommendations on modeling patterns and platform features to architecture discussions.

AI Support Through Semantic Modeling (10%)

• Build and maintain dbt semantic models, metrics, and business definitions that AI applications and agents can consume consistently.

• Develop Snowflake semantic views and semantic model definitions that support natural-language querying tools such as Snowflake Cortex Analyst.

• Enrich dbt models with descriptions, column-level documentation, synonyms, and metadata that improve AI accuracy and retrieval.

• Prepare curated, AI-ready datasets in the consumption layer with clear grain, relationships, and business context.

• Collaborate with AI engineering teams to translate AI use-case requirements into semantic and data model changes.

• Validate that AI-generated answers align with governed metric definitions and help diagnose data-related accuracy issues.

WHAT YOU BRING

Education and Experience

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related technical field.

• Minimum of 3 years of experience in data engineering, analytics engineering, or data development roles.

• At least 2 years of hands-on experience developing and maintaining dbt projects in production.

• At least 2 years of hands-on experience with the Snowflake platform, including advanced features.

• Proven track record of developing data applications or analytical solutions for business users.

Technical Skills

• dbt Development: Production experience with dbt, including model design, Jinja and macros, testing, packages, documentation, and deployment on Snowflake.

• Data Modeling: Strong dimensional modeling skills and experience designing layered transformations, including staging, intermediate, and marts.

• Semantic Modeling: Experience defining metrics, dimensions, and business logic in a semantic layer for BI and AI consumption.

• Snowflake Expertise: Advanced knowledge of Snowflake architecture, including data warehousing, data lakes, and emerging lakehouse features.

• SQL Proficiency: Expert-level SQL skills with experience in complex analytical queries and optimization.

• Application Development: Proficiency with Snowflake Streamlit for building interactive data applications.

• Python Programming: Strong Python skills for Snowpark development, data processing, and application logic.

• Version Control: Experience with GitHub, pull request workflows, and branching strategies for data projects.

Specialized Knowledge

• Experience migrating legacy ETL/ELT transformation logic into dbt.

• Experience with dbt incremental strategies, snapshots, and model contracts on Snowflake.

• Understanding of the dbt Semantic Layer (MetricFlow) and Snowflake semantic views.

• Familiarity with how semantic models and metadata support LLM-based tools such as Snowflake Cortex Analyst.

• Knowledge of medallion architecture patterns and data quality frameworks.

• Understanding of open table formats, including Apache Iceberg, Delta Lake, and Apache Hudi, and their integration with Snowflake.

• Experience with semi-structured data processing, including JSON, Parquet, and Avro, in Snowflake.

• Familiarity with Snowflake features including Dynamic Tables, Snowpipe, Tasks, and Streams.

• Understanding of data sharing, marketplace solutions, and cross-cloud data collaboration.

WHAT SETS YOU APART

Preferred Qualifications

• Certifications: dbt Analytics Engineering Certification; Snowflake SnowPro Core, Advanced Architect, or Data Engineer certification.

• dbt Ecosystem: Experience with dbt packages such as dbt_utils and dbt_expectations, dbt Cloud or dbt Core orchestration, and data observability tools.

• AI/ML Collaboration: Experience supporting AI or data science teams and understanding how data quality and semantics affect model output.

• Development Frameworks: Experience with modern web frameworks, API development, and microservices.

• Cloud Platforms: Knowledge of AWS, Azure, or Google Cloud data services and integration patterns.

• Data Governance: Understanding of data cataloging, metadata management, and governance frameworks.

Key Competencies

Innovation and Solution Design

• Creative problem-solving approach with the ability to design elegant solutions for complex business requirements.

• Strong understanding of user experience principles and ability to design intuitive data applications.

• Proactive in identifying opportunities to leverage emerging Snowflake and dbt capabilities for business value.

• Ability to balance new approaches with practical implementation and long-term maintainability.

Technical Excellence

• Deep expertise in data modeling, dbt, and SQL development.

• Strong analytical mindset for performance optimization and troubleshooting complex issues.

• Commitment to code quality, testing, documentation, and maintainable transformation design.

• Continuous learning approach to staying current with Snowflake and dbt feature sets.

Communication and Collaboration

• Excellent ability to explain technical concepts to non-technical business stakeholders.

• Strong presentation skills for demonstrating applications and gathering user feedback.

• Collaborative approach to working with data engineers, analysts, AI engineers, and business users.

• Ability to translate business requirements into data models, metrics, and implementation plans.

Business Partnership

• Customer-focused mindset with emphasis on delivering solutions that drive business value.

• Understanding of how data models and applications support business processes and decision-making.

• Ability to gather requirements, iterate on solutions, and incorporate user feedback effectively.

• Strategic thinking about how consistent business definitions enable reliable reporting and AI.

WHAT WE OFFER

Build A Better Career

• Competitive compensation with performance-based incentives

• Career development programs and internal promotion pathways-we build from within

• Tuition reimbursement and continuous learning opportunities

Build A Better Future

• Comprehensive health, dental, and vision coverage

• Retirement savings plans with company match

• Life insurance and disability coverage

Build A Better You

• Paid time off, holidays, and flexible work arrangements where applicable

• Employee Assistance Programs (EAP) and wellness resources

• Inclusive, team-oriented culture where people look out for one another

Build A Better World

Join a company whose products contribute to a safer, more sustainable built environment every day.

IMMIGRATION SPONSORSHIP

Victaulic does not provide immigration sponsorship (e.g., H-1B, TN, or other work visa sponsorship) for this position. All applicants must be currently authorized to work in the applicable country on a full-time basis without the need for employer-sponsored immigration support now or in the future.

EQUAL EMPLOYMENT OPPORTUNITY

Victaulic is an Equal Employment Opportunity (EOE/M/F/Vets/Disabled) employer and welcomes all qualified applicants. Applicants will receive fair and impartial consideration without regard to race, gender, color, religion, national origin, age, disability, veteran status, sexual orientation, genetic data, or other legally protected status. (Background checks may be required as part of our pre-employment process).

VICTAULIC STAFFING PARTNER COMMUNICATION POLICY

All staffing agencies are strictly forbidden from directly contacting any Victaulic employees, except those within the Human Resources/Talent Acquisition team. All communications, inquiries and candidate submissions must be routed through Victaulic's Human Resources/Talent Acquisition team. Non-compliance with this policy may result in the suspension of partnership, cancellation of the current contract, and/or the imposition of a mandatory probation period before any future business can resume. Additionally, non-compliance may lead to a permanent ban on future business. This policy ensures a streamlined and compliant recruitment process.

Let's Build a Better World Together.

victaulic.com/careers

Victaulic - confidential