Staff Software Engineer, SQL SME

Sorry, this job was removed at 08:16 p.m. (EST) on Monday, Oct 28, 2024
Be an Early Applicant
Hiring Remotely in US
Remote
217K-255K Annually
Internship
Information Technology • Software • Database • Analytics
The Role

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

Compensation & Benefits

  • Salary: $217,000-$255,000
  • Equity Stake
  • Benefits - dbt Labs offers:
    • Unlimited vacation (and yes we use it!)
    • 401k w/3% guaranteed contribution
    • Excellent healthcare
    • Paid Parental Leave
    • Wellness stipend
    • Home office stipend, and more!

What to expect in the hiring process:

  • An introductory call with a member of our Talent team
  • A technical screen and meeting with the Hiring Manager
  • A panel interview including multiple members of the Engineering Team
  • A final interview with a member of our Engineering Leadership Team

#LI_RC1

Who we are

At dbt Labs, we have developed strong opinions on how companies should practice analytics.

Specifically, we believe that:

  • Code-based transformations offer unmatched flexibility and transparency across various “multi-player” development to power everyone in the organization to collaborate on a common language
  • Data analysts should adopt similar practices and tools to software developers
  • Critical analytics infrastructure should be controlled by its users as open source software
  • Analytic code itself — not just analytics tools — will increasingly be open source

It turns out that a lot of other people believe this too! Today, there are 30,000 companies using dbt every week, 100,000 dbt Community members, and 4,100 companies paying for dbt Cloud. Our customers include JetBlue, Hubspot, Vodafone New Zealand, and Dunelm. dbt is synonymous with the practice of analytics engineering, defining an entire industry. We’re backed by top investors including Andreessen Horowitz, Sequoia Capital, and Altimeter. 

dbt Labs is an equal opportunity employer. We're committed to building an inclusive team that welcomes a diversity of perspectives, people, and backgrounds regardless of race, color, national origin, gender, sexual orientation, age, religion, disability, citizenship, veteran status, or any other protected status. We feel strongly that whether or not your experience exactly fits the job description, your passion and skills will stand out and set you apart even if your career has taken some twists and turns.  If you are on the fence about whether you meet our requirements, we encourage you to apply anyway! Please reach out to us directly at [email protected] if you need assistance or an accommodation

Want to learn more about our focus on Diversity, Equity and Inclusion at dbt Labs? Check out our DEI page here

dbt Labs reserves the right to amend or withdraw the posting at any time. For employees outside the United States, dbt Labs offers a competitive benefits package. Equity or comparable benefits may be offered depending on the legal or country limitations.


Privacy Notice

Supplement to Privacy Notice - Californians

Supplement to Privacy Notice - EEA/UK

The Company
400 Employees
Remote Workplace
Year Founded: 2016

What We Do

At dbt Labs, we make data work.  Our open-source software, dbt, enables anyone who knows SQL to engineer, document, and test data pipelines.  By empowering analysts to work like and with data engineers, dbt drastically increases an organization's ability to model and serve analytics. We’ve built a community of 50,000+ people and are backed by top investors including Andreessen Horowitz and Sequoia Capital. dbt is already used and loved by thousands of companies and dbt Cloud enables this workflow at scale. 

dbt Labs headquarters are in Philadelphia, Pennsylvania, but we are a distributed team and advocate for a remote-first culture. We want our people to work from the places where they are happiest, healthiest, and most inspired to do great things.

Why Work With Us

At dbt Labs, we bring our whole selves to work. We bring our interests and experiences, our cultural influences, our physical and emotional needs, our communication styles and lifestyles, our values, and our curiosity. We have built a lot of trust in each other, and we work hard to be worthy of it.

Gallery

Gallery

Similar Jobs

Square Logo Square

Staff Software Engineer, Orders Platform

eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Remote
Hybrid
New York, NY, USA
12000 Employees
240K-359K Annually
Easy Apply
Remote
United States
360 Employees
143K-174K Annually
Remote
United States
400 Employees

Arcadia Logo Arcadia

Senior Data Engineer

Big Data • Healthtech • Software • Analytics
Remote
USA
370 Employees

Similar Companies Hiring

Hedra Thumbnail
Software • News + Entertainment • Marketing Tech • Generative AI • Enterprise Web • Digital Media • Consumer Web
New York, NY
14 Employees
Hex Thumbnail
Software • Business Intelligence • Big Data Analytics • Big Data • Artificial Intelligence • Analytics
New York, NY
100 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account