Snowflake, dbt Developer

This is a fully remote position, open to applicants in Virginia.

📋 Description

• Design, test, and uphold dbt models across the silver, gold, and platinum medallion layers.

• Enhance the existing production dbt project and transition legacy transformation logic into dbt.

• Create and sustain semantic-layer models for BI, integration, and AI consumers.

• Execute incremental models, snapshots, and materialization strategies optimized for Snowflake.

• Write dbt tests and uphold layer contracts, naming conventions, and coding standards.

• Keep dbt documentation, lineage, and exposures updated.

• Develop reusable macros and packages.

• Engage in pull request reviews and adhere to GitHub branching and release protocols.

• Diagnose dbt model failures, data quality concerns, and performance issues.

• Collaborate with BI analysts and business stakeholders to convert reporting requirements into dbt models.

• Design and build interactive data applications using Snowflake Streamlit.

• Create reusable application frameworks and component libraries.

• Integrate Snowflake Native Apps and third-party marketplace solutions.

• Develop custom UDFs and stored procedures.

• Implement data models and pipelines in accordance with medallion architecture standards.

• Process JSON, Parquet, and Avro into usable structures.

• Enhance query performance, clustering, and warehouse efficiency.

• Establish secure data sharing solutions.

• Construct semantic models, metrics, business definitions, semantic views, and AI-ready datasets.

• Partner with AI engineering teams to validate AI-generated responses against governed metrics.

⛳️ Requirements

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

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

• At least 2 years of practical experience in developing and maintaining dbt projects in a production environment.

• A minimum of 2 years of hands-on experience with the Snowflake platform, including its advanced features.

• A proven history of creating data applications or analytical solutions for business users.

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

• Strong skills in dimensional modeling and experience in designing layered transformations.

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

• Advanced understanding of Snowflake architecture, including data warehousing, data lakes, and lakehouse features.

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

• Proficiency in Snowflake Streamlit.

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

• Familiarity with GitHub, pull request workflows, and branching strategies.

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

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

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

• Knowledge of semantic models and metadata supporting LLM-based tools such as Snowflake Cortex Analyst.

• Familiarity with 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 in processing semi-structured data, such as JSON, Parquet, and Avro, within Snowflake.

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

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

• Must currently possess authorization to work full-time in the applicable country without employer-sponsored immigration support now or in the future.

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

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

• Preferred: Expertise in AI/ML collaboration, modern web frameworks, API development, microservices, cloud data services, and data governance.

🏝️ Benefits

• Competitive salary with performance-based incentives.

• Career development opportunities and internal promotion pathways—we prioritize developing talent from within.

• Tuition reimbursement and ongoing learning opportunities.

• Comprehensive health, dental, and vision insurance coverage.

• Retirement savings plans with company matching contributions.

• Life insurance and disability coverage.

• Paid time off and holidays.

• Flexible work arrangements where applicable.

• Employee Assistance Programs (EAP) and wellness resources.

• An inclusive, team-oriented culture.

• Contributions to creating a safer, more sustainable built environment.