Snowflake Data Engineer

Snowflake Data EngineerRaise is currently hiring a contract team member on behalf of our client. They're expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader.Job OverviewYour data models show leaders how their projects perform. In this role, you own the analytics layer that turns raw data into trusted star schemas in Snowflake, built with dbt (data build tool) and used in Power BI. You spend about 70% of your time hands-on and the rest reviewing code, coaching engineers, and bringing in new ideas. You don't need industry-specific experience. Strong data engineering practice is what counts.ResponsibilitiesDesign and build star-schema data models in Snowflake using dbt, including fact, dimension, bridge, and aggregate tables.Own the data flow end to end, from intake in Azure Data Factory (ADF), through dbt and a Data Vault layer, to the star schemas that power Power BI reports.Write, tune, and automate complex SQL and large Snowflake workloads.Build dbt tests, documentation, and reusable patterns that keep data quality high.Automate builds and infrastructure with GitHub Actions and Terraform.Review code, spot what works and what doesn't, and coach backend developers and data engineers side by side.Set data modeling standards and shape architecture decisions for the platform.Propose improvements and bring new ideas to the platform.Support the API components that feed data into the platform.Partner with product owners, architects, and business teams to turn project performance questions into data models.QualificationsRequired8+ years in data engineering or data warehousing, including 4+ years of hands-on dbt and Snowflake work.Expert, hands-on dbt experience: you've built models, written tests, and deployed them to production yourself.Expert Snowflake experience, including architecture, performance tuning, and SQL optimization.Proven work designing and building enterprise-scale star-schema (dimensional) data models.Hands-on experience automating SQL workloads and data processes.A track record of working on your own, solving data problems from start to finish, and leading technical design decisions.Hands-on experience with GitHub for version control and team development.PreferredData Vault modeling.Azure Data Factory (ADF), Azure Synapse, or Microsoft Fabric.GitHub Actions and Terraform.Python for data engineering and automation.Experience using AI in data work.Experience with API data integration.Observability tools such as Datadog.SnowPro, DP-203, or similar cloud data certifications.Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we're a certified B Corporation and donate 10% of our profits to charity.We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions), please contact us at View phone number on click.appcast.io or View email address on click.appcast.io#USENSF26