Staff Software Engineer, SQL SME

About Us

Since 2016, dbt Labs has been on a mission to help analysts create and disseminate organizational knowledge. dbt Labs pioneered the practice of analytics engineering, built the primary tool in the analytics engineering toolbox, and has been fortunate enough to see a fantastic community coalesce to help push the boundaries of the analytics engineering workflow. Today there are 30,000 companies using dbt every week, 100,000 dbt Community members, and over 4,100 dbt Cloud customers. You can learn more about our values here.  

About The Role

We are seeking an experienced Software Engineer to build new capabilities for SQL parsing, transpilation, and optimization. The ideal candidate will have a strong background in SQL and a deep understanding of building and optimizing cloud-based software systems. This role will contribute across current products and have significant impact on our technology strategy.

Responsibilities

• Develop features that increase the performance and capabilities of dbt Core
• Collaborate to build solutions for multiple product engineering teams, including dbt Explorer and our upcoming visual editor.
• Develop underlying libraries, key abstractions, and workflows for working with SQL within our managed cloud product.
• Optimize the performance of our of our SQL parsing and transpilation solutions for cloud data warehouses
• Work on novel capabilities at the intersection of SQL and LLMs
• Drive customer value and engineering excellence in everything we ship

Qualifications

• Have 8+ years of experience as a software engineer
• Minimum requirement of bachelor's degree in a related field (computer science, computer engineering, etc.) OR completed enrollment in engineering related bootcamp

You are a good fit if you have

• Expert-level understanding of ANSI SQL, variations in SQL dialects, and the intersection of SQL and software development
• A deep understanding of query planning, query optimization techniques, and performance-tuning strategies
• Experience with cloud-based data platforms such as Snowflake, Redshift, or BigQuery.
• Python expertise
• Experience building and maintaining high-scale cloud software systems
• Excellent problem-solving skills and the ability to work independently or as part of a team.
• Strong communication skills and the ability to collaborate effectively with cross-functional partners in product, design, and DX.

You have an edge if you have

• Knowledge of generative AI models and their applications in data engineering
• A background in programming languages or distributed data computation
…