Snowflake +DBT Developer

Request ID: 68231-1Title: Snowflake +DBT Developer Locations: San Jose, CA Duration: 6 Months Salary Range: $45 - $53/Hour on W2 (All inclusive)IntroductionWe are seeking a highly skilled developer to design, develop, and maintain data warehouse solutions using Snowflake and dbt. This role involves collaboration with various teams to define data models and transformations, ensuring high-quality data management and performance optimization. Required Skills & QualificationsStrong SQL expertiseHands-on experience with Snowflake (warehouses, stages, streams, tasks, performance tuning)Proficiency in dbt Core or dbt CloudExperience with Git, CI/CD, and modern data stack toolsPrior work experience at client or in client's IndustryApplicants must be able to work directly for Artech on W2 Preferred Skills & QualificationsFamiliarity with ETL/ELT concepts and data modeling (e.g., Kimball, star schema)Optional but valuable: Airflow, Python, cloud platforms (AWS/Azure/GCP) Day-to-Day ResponsibilitiesDesign, develop, and maintain Snowflake data warehouse solutionsBuild, test, and deploy dbt models (staging, intermediate, marts)Implement SQL-based ELT pipelines using dbt best practices (modularity, documentation, testing)Optimize Snowflake performance (clustering, micro-partitioning, query tuning)Create and manage Snowflake roles, warehouses, schemas, and data-sharing configurationsCollaborate with data engineers, analysts, and business teams to define data models and transformationsMaintain version control (Git) and CI/CD workflows for dbt deploymentsEnsure data quality through dbt tests, data validation, and monitoringWrite efficient, scalable SQL for complex transformationsDevelop and maintain documentation for data models, pipelines, and architecture Company Benefits & CultureCompetitive salary and benefits packageOpportunities for professional growth and developmentInclusive and collaborative work environment For immediate consideration please click APPLY to begin the screening process with Alex.