Snowflake DBT Data Engineer

Responsibilities

• Develop DBT Projects Build maintain and manage the endtoend DBT project ensuring modularity reusability and adherence to established data standards
• Advanced SQL Jinja Write complex optimized SQL queries and leverage Jinja templating within DBT models for dynamic transformations and efficient code
• Snowflake Data Cloud Architecture Virtual Warehouses Role Based Access Control Time Travel ZeroCopy Clones Objects and SQL Scripting
• Data Modeling Implementation Design and implement dimensional data models eg Star Schema in Snowflake to serve business intelligence reporting and data science needs
• Materialization Strategy Configure and optimize DBT materialization strategies views tables incremental models Dynamic Tables to balance data freshness query performance and Snowflake compute costs
• Automated Testing Embed comprehensive data quality and integrity tests ex schema checks referential integrity directly into DBT models using DBT tests and custom checks
• Documentation Lineage Maintain highquality DBT documentation and ensure complete data lineage is tracked and visible for all transformed models
• Orchestration CICD Integrate the DBT project with orchestration tools eg Dagster and establish CICD pipelines eg BitBucket for reliable automated deployment of code from development to production environments

Benefits

• Hybrid work arrangement in Irvine, CA.
• At Extend Information Systems (ExtendInfosys), we’re cognizant of shaping the future.
• Ashburn, Virginia, USA
• https://extendinfosys.com
• Distribution of Different Job Fields Receiving Sponsorship
• Represents job field similar to this job
• Engineering and Development
• Management and Executive
• Trends of Total Sponsorships
• *2024
• (1)
• 2023
• (8)
• 2022
• (2)
• Growth Stage
• Company data provided by
• AI Tools
• Customize Your Resume
• Maximize your interview chances
• Build Cover Letter
• Make your application stand out
• Analyze How Well You Fit
• Understand your strength & weakness

Qualifications

• Snowflake

Required skills

• Bitbucket CI/CD, Dagster, Dimensional Data Modeling, Jinja, SQL, Snowflake, Snowflake Role-Based Access Control, Snowflake SQL Scripting, Snowflake Time Travel, Snowflake Virtual Warehouses, Snowflake Zero-Copy Cloning, Star Schema, dbt, dbt Testing

Experience

• Mid level